Oracle on Windows Kevin Ashby Enterprise Technical Strategist

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

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

demo Oracle Database 10 g Release 1 Simple Windows install

Commitment to Windows Oracle 7 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

Partnering with Microsoft Oracle sponsors Microsoft events (PDC 2003, Tech. Ed 2004, 2005) Microsoft sponsors Oracle events Oracle. World 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.

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

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

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

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

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

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

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

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

Database Architecture File I/O Oracle 10 g 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 64 GB Maximum database size is 4 petabytes

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

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

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

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 Stored Procedure Testing Designers and Wizards Oracle Data Window Automatic Code Generation SQL Query Window PL/SQL Editor Integrated Help System Beta Support for. Net Language Stored Procedures

Stored Procedure Testing

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

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

Database Name Resolution 2 - User specifies AD-stored connect string 4 - Connection to database is established Windows Environment Oracle 10 g 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

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

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 i. AS (application server) and AD

User Sign-On to Oracle 1 - User attempts to sign on Oracle 10 g Single Sign-On Windows Environment Oracle Portal Oracle 2 - Oracle Authentication E-Business Suite Release 11 i 4 - Authentication via Windows Plug-in Microsoft Active Directory 3 - User identity confirmed Oracle Internet Directory Delegated Administration Console

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/EM 64 T)

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

Systems Management : Grid Control

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

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 ?

Standby - Data Guard Configuration Standby Site A Primary Site Standby Site B Broker Primary Database Physical Standby Database Logical Standby Database 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

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

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

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

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

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

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

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

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, i. AS, E-Business Suite 11 i, Forms 6 i, and Reports 6 i Provides fast fail over, high availability Supports up to 8 nodes on Windows Server 2003 Integrates with MSCS for resource failover

Oracle Fail Safe Manager Node B Node A Fail Safe Server Private Disk MSCS Resource Fail Safe Server MSCS Resource DLL Cluster Disks Private Disk

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

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

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

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

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

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

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)

Cluster File System Oracle 10 g 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 kernelmode driver Cluster aware installation through the Oracle Universal Installer

demo Oracle Database 10 g Release 1 Install Complete & Oracle dbcontrol for Systems Management

Ask The Experts Get Your Questions Answered You can find me at the Microsoft Ask the Experts area, located in the Exhibition Hall: Thursday 7 July 13: 30 – 15: 00