svr340_oracle on windows by liaoxiuli

VIEWS: 37 PAGES: 52

									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 10g Release 1
 Simple Windows install
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
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.
   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                              8.4%

       Windows
       Growth of 8.4% on
       previous year
                                                   Linux 20%


Source: Gartner Research - May 2005 ID G00127787
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
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
 3GB (32-bit) or 8TB (64-bit) maximum memory
 per database instance. VLM support allows
 >3GB on 32-bit.
32-bit: VLM Support

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



            Code
                                         database
                                         threads/
                                         memory
32-bit: VLM Support
                                                Memory from AWE calls
       Extended memory                          used for db buffers only.
rest   available for db                         The amount of AWE
 of    buffers via AWE calls   16GB             memory allocated
RAM
                                                equals db_block_size
       For O/S, other apps                      times db_block_buffers.

           For Kernel          1GB
                                            Oracle operating system
                                            process. Normally limited
       Window on db                         to 3GB of address space.
       buffers in AWE                       With VLM, Oracle can get
               SGA
       mem                                  up to 64GB of database
       SGA minus db buffers
                                            buffers.
                               3GB   with AWE

              Code
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
     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
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
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

                                                         Automatically adapts
Online                Large Batch   Buffer Cache         to workload changes
Users    Buffer Cache   Jobs                             Maximizes memory
                                    Large Pool
                                                         utilization
         Large Pool                                      Single Parameter
                                                         makes it easier to
         SQL Cache                  SQL Cache
                                                         use
                                                   SGA
         Java Pool                   Java Pool           Helps eliminate out-
                                                   PGA
                                                         of-memory errors
            sort                       sort              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, cross-
 platform 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                   4- Connection to
        connect string                   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                                 Microsoft AD
   connect string
         data
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 iAS (application
    server) and AD
User Sign-On to Oracle
   1- User
  attempts                          Oracle10g Single
   to sign                                                            Oracle
                                        Sign-On
      on                                                              Portal


   Windows
                                                  2- Oracle      Oracle
  Environment
                                                Authentication E-Business
                                                                       Suite
                4- Authentication
                   via Windows                                      Release 11i
                      Plug-in                           3- User
                                                        identity
                                                       confirmed

                Microsoft
                 Active
                Directory                 Oracle                     Delegated
                                         Internet                  Administration
                                         Directory                    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/EM64T)
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
      Primary Site                          Standby Site A




                                                             Standby Site B
                             Broker

                                            Physical
                                            Standby
 Primary                                    Database
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                                                  Backup
Production
Database                                                 Redo Apply                    DIGITAL DATA STORAGE




                                                                                            DIGITAL DATA STORAGE



             Network
                                  Broker




                                                     Logical Standby
                                    Transform          Database                 Open for
                                   Redo to SQL                                  Reports




                                                 SQL
                                                 Apply
                                                                        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, 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
  Oracle Fail Safe

                           Fail Safe Manager


          Node A                                          Node B

              Fail Safe Server               Fail Safe Server
Private                                                            Private
           MSCS        Resource        MSCS           Resource
 Disk                                                               Disk

              Resource DLL                   Resource DLL




                             Cluster Disks
Before Failover…

Primary Server for                 Database Clients       Secondary Server for
 Virtual Server C                                           Virtual Server C
Node: A                                                         Node: B
Virtual Server: C            Oracle Fail                       Oracle Fail
Group 1:                     Safe Server                       Safe Server
 Disk Resource
 IP Address Resource
 Network Name Resource
 Net Listener Resource      MSCS                               MSCS
 Oracle Database Resource



    Oracle Fail Safe Database Instance



                                   Database Disks
 Private                        Shared I/O Interconnect        Private
 Disk(s)                                                       Disk(s)
Node goes down…

Primary Server for                 Database Clients       Secondary Server for
 Virtual Server C                                           Virtual Server C
Node: A                                                         Node: B
Virtual Server: C            Oracle Fail                       Oracle Fail
Group 1:                     Safe Server                       Safe Server
 Disk Resource
 IP Address Resource
 Network Name Resource
 Net Listener Resource      MSCS                               MSCS
 Oracle Database Resource



    Oracle Fail Safe Database Instance



                                   Database Disks
 Private                        Shared I/O Interconnect        Private
 Disk(s)                                                       Disk(s)
After failover…

Primary Server for          Database Clients               Secondary Server for
 Virtual Server C                                            Virtual Server C
Node: A                                                           Node: B

                     Oracle Fail     Virtual Server: C
                                                                 Oracle Fail
                     Safe Server                                 Safe Server
                                     Group 1:
                                      Disk Resource
                                      IP Address Resource
                     MSCS             Network Name Resource
                                      Net Listener Resource      MSCS
                                      Oracle Database Resource


                                        Oracle Fail Safe Database Instance



                          Database Disks
 Private               Shared I/O Interconnect                   Private
 Disk(s)                                                         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

 Centralized                              Application Servers/             Users
 Management                                     Network
 Console


 High Speed                Interconnect
 Switch or                                                       Each Node runs
 Interconnect                                                    • Oracle Clusterware
                                                                 • Oracle Instance
 Clustered
 Database Instances
 With Oracle Clusterware

 Switch
 Fabric, iSCSI
 or Shared
 SCSI

 ASM Disk
 Subsystem
RAC Cluster                             Database Clients



     Node: A                   Node: B                    Node: C

               Virtual IP                 Virtual IP                Virtual IP

     10g       Oracle
                                10g       Oracle
                                                           10g      Oracle
               Listener                   Listener                  Listener

     Oracle Clusterware         Oracle Clusterware        Oracle Clusterware



 Private                    Private                    Private
 Disk(s)                    Disk(s)                    Disk(s)



             Shared Disk
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

 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
demo
 Oracle Database 10g 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

								
To top