Oracle on Windows

1
Oracle on Windows
Kevin Ashby Enterprise Technical Strategist, Micr
osoft EMEA
kashby_at_microsoft.com
Philip Newlan Principal Product Manager, Oracle S
erver Technologies
philip.newlan_at_oracle.com
2
Agenda

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

3
Oracle Database 10g Release 1Simple Windows
install
demo
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 Oracles 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 Itani
um 2 processors on 64-bit Windows 2003, Oracle
Database 10g Release 2 achieved 15,070 QphH_at_1000
GB with a price-performance 44.33 US per QphH_at_
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_at_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 Oracles 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
32-bit VLM Support
SGA
3GB with AWE
Code
database threads/ memory
12
32-bit VLM Support
Memory from AWE calls used for db buffers only.
The amount of AWE memory allocated equals db_bl
ock_size
times db_block_buffers.
Extended memory available for db buffers via AW
E 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
3GB with 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 Oracle10g

• User-thread support
• An extension of the thread support already in
  place since Oracle7.
  
• Run the database in user-thread mode, which
  employs Oracle-scheduled user-mode threads (or
  fibers) instead of O/S-scheduled threads.
  
• For CPU intensive apps, this will provide a
  performance boost and reduce CPU utilization.

17
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

18
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
19
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

20
Stored Procedure Testing
21
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)

22
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

23
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
24
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

25
Single Sign-on Support (three-tier)

• Oracles 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

26
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
27
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)

28
Agenda

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

29
Systems Management Grid Control
30
(No Transcript)
31
(No Transcript)
32
Agenda

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

33
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 ?

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

35
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
36
Fast-Start Failover
Standby Site
Primary Site
Observer

• Data Guard in steady state transmitting redo
• Observer monitoring state of the configuration

37
Fast-Start Failover
Standby Site
Primary Site
Observer

• Disaster strikes the primary connections lost

38
Fast-Start Failover
Standby Site
Primary 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

39
Fast-Start Failover
Primary Site
Observer

• Target standby automatically becomes new primary

40
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

41
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

42
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

43
Oracle Fail Safe
Fail Safe Manager
Node B
Node A
Fail Safe Server
Fail Safe Server
PrivateDisk
PrivateDisk
Resource
MSCS
Resource
MSCS
Resource DLL
Resource DLL
Cluster Disks
44
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 Or
acle Database Resource
Oracle Fail Safe Database Instance
Database Disks Shared I/O Interconnect
45
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 Or
acle Database Resource
Oracle Fail Safe Database Instance
Database Disks Shared I/O Interconnect
46
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 Or
acle Database Resource
Oracle Fail Safe Database Instance
Database Disks Shared I/O Interconnect
47
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

48
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 Clusterw
are
Shared Cache
Switch Fabric, iSCSI or Shared SCSI
ASM Disk Subsystem
49
RAC Cluster
Database Clients
Node B
Node C
Virtual IP
Virtual IP
Oracle Listener
Oracle Listener
Oracle Clusterware
Oracle Clusterware
Shared Disk
50
RAC Licensing

• RAC is available for 2 Oracle database levels
• Oracle Standard Edition
• RAC is Free with SE ( up to 4 CPUs 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)

51
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

52
Oracle Database 10g Release 1Install
CompleteOracle dbcontrol for Systems
Management
demo
53
Ask The ExpertsGet Your Questions Answered

• You can find me at the Microsoft Ask the Experts
  area, located in the Exhibition Hall
  
• Thursday 7 July 1330 1500