1 / 52

Oracle on Windows

Learn about the synergies, database architecture, systems management, and high availability concepts of Oracle on Windows. Discover how Oracle integrates with Microsoft technologies and the benefits of running Oracle on the Windows Server platform.

demetriae
Download Presentation

Oracle on Windows

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Oracle on Windows Kevin Ashby Enterprise Technical Strategist, Microsoft EMEA kashby@microsoft.com Philip Newlan Principal Product Manager, Oracle Server Technologies philip.newlan@oracle.com

  2. Agenda • Synergies • Database Architecture • Systems Management • HA • Concepts • Data Guard • Oracle Failsafe • RAC • Active Directory, Visual Studio Integration • Summary

  3. demo Oracle Database 10g Release 1Simple Windows install

  4. Commitment to Windows • Oracle7 was the first database to ship on Windows in 1994 • Windows Server is a base development platform for Oracle • Windows Server is a Tier 1, fully supported platform for Oracle • Focused Engineering and Product management groups for Windows-specific integration projects • Supported both 32-bit and 64-bit Windows Server 2003 on day of O/S release

  5. Partnering with Microsoft • Oracle sponsors Microsoft events • (PDC 2003, TechEd 2004, 2005) • Microsoft sponsors Oracle events • OracleWorld 2004, UKOUG • Communication channels open at various levels in the organizations • Joint support contacts for customer escalations • How we jointly solve problems • Conference calls, briefings, etc.

  6. Oracle on Windows: Widely Deployed 2004 Oracle Revenues by OS for new license sales Other 2% Unix 49% Windows 29% 29% of Oracle’s revenues are from Windows Growth of 8.4% on previous year 8.4% Linux 20% Source: Gartner Research - May 2005 ID G00127787

  7. World Record TPC-H 1000 GB Benchmark Using an Bull NovaScale 5160 with 16 Intel Itanium 2 processors on 64-bit Windows 2003, Oracle Database 10g Release 2 achieved 15,070 QphH@1000GB with a price-performance 44.33 US $ per QphH@1000GB. Available December 20, 2005 Source: Transaction Processing Council (TPC), http://www.tpc.org

  8. Information Sources • Oracle Web • http://otn.oracle.com/windows • Windows IT Pro • http://www.windowsitpro.com/oracleonwindows • Microsoft • http://www.microsoft.com • Search for ORACLE • Performance tuning white paper • Email kashby@microsoft.com

  9. Agenda • Synergies • Database Architecture • Systems Management • HA • Concepts • Data Guard • Oracle Failsafe • RAC • Active Directory, Visual Studio Integration • Summary

  10. Database Architecture • Thread model, not a port of Oracle’s process architecture • Oracle.exe, 1 process many threads • 3GB (32-bit) or 8TB (64-bit) maximum memory per database instance. VLM support allows >3GB on 32-bit.

  11. 16GB rest of RAM Windows Server 2003 Memory Limits (32-bit) Standard Edition: 4GB Enterprise Edition: 32GB Datacenter Edition: 64GB For O/S, other apps For Kernel 1GB 32-bit: VLM Support SGA 3GBwith AWE Code database threads/ memory

  12. rest of RAM For O/S, other apps For Kernel 1GB 32-bit: VLM Support Memory from AWE calls used for db buffers only. The amount of AWE memory allocated equals db_block_size times db_block_buffers. Extended memory available for db buffers via AWE calls 16GB Oracle operating system process. Normally limited to 3GB of address space. With VLM, Oracle can get up to 64GB of database buffers. Window on db buffers in AWE mem SGA SGA minus db buffers 3GBwith AWE Code

  13. 64-bit • Interoperability between 32-bit clients and 64-bit servers and vice versa • Improved performance, availability and scalability • Timeline • 10.1.0.4 available NOW • 32-bit to 64-bit upgrade process is simple • 32-bit data files are compatible with 64-bit DB • No need to recreate the database • Full export and import not required • Database Upgrade Assistant automates process • Transparent migration for end-user applications • No changes required to existing client applications when running against 64-bit database

  14. Database Architecture • File I/O • Oracle10g supports asynchronous I/O to all types of files • Logical and physical raw files and partitions are fully supported (faster than NTFS) • Full 64-bit file I/O internally • Maximum file size is 64GB • Maximum database size is 4 petabytes

  15. Database Architecture • Developed for Windows • Integration with Performance Monitor • Integration with Event Log • Integrated with Windows Services • 10TB database in production • Unlimited scalability on 64-bit

  16. New for Windows Server 2003 • Large Page support • For instances with large memory requirements, large page support can improve performance. • NUMA support for memory/scheduling • Database intelligently allocates memory and schedules threads based on node configuration

  17. Buffer Cache Large Batch Jobs Large Pool Buffer Cache SQL Cache SGA Java Pool sort sort PGA Automatic Shared Memory Tuning • Automatically adapts to workload changes • Maximizes memory utilization • Single Parameter makes it easier to use • Helps eliminate out- of-memory errors • Can help improve performance Online Users Large Pool SQL Cache Java Pool

  18. Oracle on Windows • All development Tools in place • ODP Drivers • 10.1.0.4 ODP.Net driver available • Oracle Developer Tools for Visual Studio .NET • Oracle Explorer • Designers and Wizards • Automatic Code Generation • PL/SQL Editor • Beta Support for .Net Language Stored Procedures • Stored Procedure Testing • Oracle Data Window • SQL Query Window • Integrated Help System

  19. Stored Procedure Testing

  20. Cross-platform Security Integration (Kerberos) • With the Oracle Advanced Security Option, cross-platform Kerberos support is enabled • A Windows client can connect to a non-Windows server securely • Integrated with Microsoft Key Distribution Center (MSKDC)

  21. Active Directory Integration • Database registration and name resolution • Store and resolve connect descriptors through AD • Eliminate tnsnames.ora on clients • Centralize configuration, reduce administration • Enhanced tools support for storing connect descriptors • Windows Explorer, AD Users and Computers • Oracle DB Configuration Assistant, Net Manager, Net Configuration Assistant

  22. Database Name Resolution 2 - User specifies AD-stored connect string 4- Connection to database is established Windows Environment Oracle 10g 3 - Connect string is resolved from ADS via Oracle Net 1 – Admin uses Oracle Net Manager or DBCA to populate AD connect string data Microsoft AD

  23. Single Sign-on Support (client/server) • Windows Native Authentication adapter provides: • O/S authentication for database users • Database lookup of O/S-enabled roles • Authentication done via Kerberos • With the purchase of the Advanced Security Option, single sign-on can be done over SSL as well • Integrated with Microsoft Certificate Store (MCS) for X.509 certificates

  24. Single Sign-on Support (three-tier) • Oracle’s mid-tier Single Sign-On server (SSO) is also integrated with Windows and Active Directory • Allows single sign-on support via Web browser credentials • Windows Authentication Plug-in allows interoperability between Oracle iAS (application server) and AD

  25. 2- Oracle Authentication 4- Authentication via Windows Plug-in 3- User identity confirmed User Sign-On to Oracle 1- Userattempts to sign on Oracle Portal Oracle10g Single Sign-On Windows Environment OracleE-Business SuiteRelease 11i Microsoft Active Directory Oracle Internet Directory DelegatedAdministrationConsole

  26. Conclusion • Oracle has been committed to Windows Server since its inception • Oracle is strongly integrated with the Windows Server Platform • Oracle is a top performing DBMS on Windows Server • Oracle is available on all Windows Server implementations (all editions, 32-bit, 64-bit Itanium, & this year 64-bit AMD/EM64T)

  27. Agenda • Synergies • Database Architecture • Systems Management • HA • Concepts • Data Guard • Oracle Failsafe • RAC • Active Directory, Visual Studio Integration • Summary

  28. Systems Management : Grid Control

  29. Agenda • Synergies • Database Architecture • Systems Management • HA • Concepts • Data Guard • Oracle Failsafe • RAC • Summary

  30. HA Concepts • Design for (not all 4) • Performance • Cost • Scalability • Availability • 99.999% is 5 minutes a year • 4 hour • 30 seconds - 5 minutes • Instant ?

  31. Standby - Data Guard Configuration Standby Site A Primary Site • Managed as a single configuration • Primary and standby databases can be Real Application Clusters or single-instance Oracle • Up to nine standby databases supported in a single configuration Standby Site B Broker Physical Standby Database Primary Database Logical Standby Database

  32. Production Database Network Broker Oracle Data Guard Architecture Physical Standby Database Sync or Async Redo Shipping Backup Redo Apply Logical Standby Database Transform Redo to SQL Open for Reports SQLApply Additional Indexes & MVs

  33. Fast-Start Failover Primary Site Standby Site Observer • Data Guard in steady state – transmitting redo • Observer monitoring state of the configuration

  34. Fast-Start Failover Primary Site Standby Site Observer • Disaster strikes the primary – connections lost

  35. Fast-Start Failover Primary Site Standby Site Observer • Observer <=> primary connection times out (timeout threshold configurable) • Observer asks target standby if it is ready to fail over • Observer begins Fast-Start Failover

  36. Fast-Start Failover Primary Site Observer • Target standby automatically becomes new primary

  37. Fast-Start Failover Standby Site Primary Site Observer • After old primary is repaired, Observer re-establishes connection • Observer automatically reinstates old primary to be a new standby • Redo transmission starts from new primary to new standby

  38. Clustering • Fail Safe • provides quick node failover • high availability solution • integrated with Microsoft Cluster Services (MSCS) • Real Application Clusters (RAC) • shared-disk, clustered database • availability, scalability, reliability • Oracle-provided clusterware • Cluster File System (CFS) • Oracle-written file system for shared disks • one software image can be shared by nodes

  39. Oracle Fail Safe • High Availability for solutions deployed on Windows clusters • Supports Windows Server 2003 (and Windows 2000 Server and Windows NT Server) clusters • Support for Oracle Database, iAS, E-Business Suite 11i, Forms 6i, and Reports 6i • Provides fast fail over, high availability • Supports up to 8 nodes on Windows Server 2003 • Integrates with MSCS for resource failover

  40. Oracle Fail Safe Fail Safe Manager Node B Node A Fail Safe Server Fail Safe Server PrivateDisk PrivateDisk MSCS Resource MSCS Resource Resource DLL Resource DLL Cluster Disks

  41. Oracle Fail Safe Server Oracle Fail Safe Server MSCS MSCS Private Disk(s) Private Disk(s) Before Failover… Database Clients Secondary Server for Virtual Server C Primary Server for Virtual Server C Node: A Node: B Virtual Server: C Group 1: Disk Resource IP Address Resource Network Name Resource Net Listener Resource Oracle Database Resource Oracle Fail Safe DatabaseInstance Database Disks Shared I/O Interconnect

  42. Oracle Fail Safe Server Oracle Fail Safe Server MSCS MSCS Private Disk(s) Private Disk(s) Node goes down… Database Clients Secondary Server for Virtual Server C Primary Server for Virtual Server C Node: A Node: B Virtual Server: C Group 1: Disk Resource IP Address Resource Network Name Resource Net Listener Resource Oracle Database Resource Oracle Fail Safe DatabaseInstance Database Disks Shared I/O Interconnect

  43. Oracle Fail Safe Server Oracle Fail Safe Server MSCS MSCS Private Disk(s) Private Disk(s) After failover… Database Clients Secondary Server for Virtual Server C Primary Server for Virtual Server C Node: A Node: B Virtual Server: C Group 1: Disk Resource IP Address Resource Network Name Resource Net Listener Resource Oracle Database Resource Oracle Fail Safe DatabaseInstance Database Disks Shared I/O Interconnect

  44. Real Application Clusters • RAC is database clustering • Shared disk solution • One physical database serviced by multiple cluster nodes/instances • Cluster consists of database nodes, fast cluster interconnect, shared disk subsystem • Oracle provides integrated clusterware and storage management

  45. RAC Architecture Users Application Servers/ Network Centralized Management Console High Speed Switch or Interconnect Interconnect • Each Node runs • Oracle Clusterware • Oracle Instance ClusteredDatabase Instances With Oracle Clusterware Shared Cache Switch Fabric, iSCSI or Shared SCSI ASM Disk Subsystem

  46. 10g 10g 10g Node: A Virtual IP Oracle Listener Oracle Clusterware Private Disk(s) Private Disk(s) Private Disk(s) RAC Cluster Database Clients Node: B Node: C Virtual IP Virtual IP Oracle Listener Oracle Listener Oracle Clusterware Oracle Clusterware Shared Disk

  47. RAC Licensing • RAC is available for 2 Oracle database levels • Oracle Standard Edition • RAC is Free with SE ( up to 4 CPU’s total - 2 or 4 nodes) • Oracle Enterprise Edition ( up to 100 nodes ) • Minimum licence for an SE/RAC cluster is • $3,000 for a 2 node cluster • Oracle Hardware Partners have bundled offerings • RAC in a box (http://www.dell.com/oracle)

  48. Cluster File System • Oracle10g Clustered File System (CFS) on Windows for easier manageability • Support database files on CFS instead of raw partitions, which are much harder to manage • Put ORACLE_HOME on CFS, providing better single system image • Implemented as a Windows file system via kernel-mode driver • Cluster aware installation through the Oracle Universal Installer

More Related