Oracle 10g Best Practices on Windows

Document Sample
Oracle 10g Best Practices on Windows Powered By Docstoc
					Peter Sciarra
Technical Staff Member
Oracle Corporation

Courtney Llamas
Database Engineer
ESI Application Services
Oracle Database 10g:
Best Practices for
Windows Deployments

 Oracle Windows Deployment

 HP
Oracle Deployment

   Oracle Architecture on Windows
   Clustering Overview
   Pre-install
   CRS Installation
   RDBMS Installation
   CRS/OCR/Tools
RAC Instance Architecture
                        Public Network
    VIP                       VIP                    VIP

  ASM inst    Private      ASM inst      Network   ASM inst
  DB inst 1                DB inst 2               DB inst 3
    CRS                      CRS                     CRS

   Node 1                   Node 2                  Node 3

 Architecture: Thread Model
                                            SGA contains
             Oracle process                 db buffers,
                                            log buffers
                     SGA                    shared pool,
                                            other memory
3GB                                         allocations
                                            Each thread
8TB                                         consists of
total                                       PGA, stack,
        Background and foreground threads
                                            other memory
                   Code                     allocations
Architecture: Thread Model
 Unlike UNIX ports of Oracle Database 10g,
  Oracle Database 10g on Windows is
  implemented as a single operating system
 Typical “processes” such as PMON and
  LGWR have been converted to native
  Windows threads running in the single large
  Oracle process.
 One process exists per instance on a
  Windows machine.
Architecture: File I/O

 Full support for 64-bit file I/O enables very
  large files to be used by Oracle Database 10g
  on Windows
   –   There are no 2GB or 4GB limitations on
       database file sizes.
   –   The maximum size for an entire database on
       Windows is 4 petabytes (64K files x 16K
       bytes/block x 4M blocks/file).
   32-bit: VLM Support

 of    For O/S, other apps              Windows Server 2003
RAM                                     Memory Limits (32-bit)
                                          Standard Edition:
                                          Enterprise Edition:
            SGA                          Datacenter Edition:
            Code             memory
   32-bit: VLM Support
       Extended memory
rest   available for db        Memory from AWE calls
 of    buffers via AWE calls   used for db buffers only.
RAM                            The amount of AWE
                               memory allocated
        For O/S, other apps    equals db_block_size
                               times db_block_buffers.
        Window on db
        buffers in AWE mem
                                  Oracle operating system
       SGA minus db buffers       process. Normally limited
                                  to 3GB of address space.
                                  With VLM, Oracle can get
              Code                up to 64GB of database
Cluster File System
 Supports data files + shared Oracle Home
    –   CFS will honor buffered flag
 Logical partitions required for CRS install
 Creating additional CFS partitions
    –   Allocate partition, assign drive letter
    –   New partition + w2k: reboot of other nodes
    –   Remove drive letter assignments on other nodes
    –   Ocfsformat /l f: /c 1024 /v data
    –   Stop and start OracleClusterVolumeService
    –   Cfs tools located at %CRSHOME%\cfs
Clustering Overview

 Terminology
 High Availability + Scalability + Recovery
Cluster Terminology

 Shared Data + Shared Cached
   –   Concurrent access to data by all nodes (RAC)
 Shared Nothing
   –   Data partitioned by node (SQL Server)
 Active-Passive Passive-Passive
   –   Provides High Availability of database
   –   Data Guard
   –   FailSafe
RAC Scalability & Availability

 High Availability
    –   Node & Database instance no longer represent
        single point of failure
 Application Scalability
    –   Understand & reduce contention/serialization pts
    –   Expect it to scale on RAC if:
        App scales transparently on a SMP box
Single Points of Failure

    –   NIC’s, Switches, Interconnect, Shared Storage,
        Power Supplies
 Eliminate single points of failure
    –   Decreasing SPOF
          Increases availability
          Increases cost
    –   Understand cost / availability tradeoff
Disaster Recovery
 RAC + DataGuard
   –    Eliminates physical location as SPOF

                    Data Guard
       Single Instance               RAC Cluster
           Boston                        NYC
          Standby                       Primary

 Network Configuration
 Shared Storage
 Installation options
CRS Preinstall tasks

   Setup & verify private/public network settings
   Setup & verify shared storage
   Create partitions for CRS
   Verify partitions on each node

 All nodes should be part of a domain
     –   Use a domain user id with admin privileges
 Private Interconnect
   –   Gigabit Ethernet best choice
   –   Switch (never use cross-over cable for 2 node)
   –   Use non-routable IP address (10.X or 192.168.x)
 Public Network
   –   IP Address for hostname (DHCP/Static) DNS
   –   Additional Static IP for each node (VIP)
         VIP is managed by Oracle
         Provides Fast Application Notification
         Same subnet as public IP
Network Checklist

 Private Interconnect
   Static IP (use hosts file) update & copy to all nodes
   at %systemroot\system32\drivers\etc\
 Public Network VIP
   –   Do not assign VIP to network adapter card
   –   VIPCA will handle initial configuration
   –   Only visible through IPCONFIG (not GUI)
 Adapter Name
   –   Use common and easily identify names
Network Checklist

                     Rename adapter
                      names for easier
                      identification (OUI)
                     Adapter names
                      must be identical
                      on each node (case
Network Checklist

                              • Public adapter
                                should be first
                              • Private adapter
                                should be second
                              • Ping node’s public
                                hostname to verify
                              • Ping each node’s
Network Connections             public & private
Advanced-> Advanced Setting     hostname
Shared Storage on Windows

 Parallel SCSI
   –   SCSI (2 Node limit)
   –   Fiber Channel (2 Nodes or higher)
   –   ISCSI (2 Nodes or higher)
   Currently not supported (NFS/CIFS)
Shared Storage

 Automount must be enabled (Windows 2003)
    –   Diskpart.exe or mountvol can be used
          diskpart> automount enable or mountvol /E
 Creating Partitions
    –   Create all partitions on one node
    –   Use Basic disk, Master Boot Record(MBR)
    –   Windows 2003 requires a reboot
          remove drive letter assignments.
    –   Verify all nodes see all shared partitions
RAC/CRS Install options

 Oracle-Home (LOCAL/OCFS)
 Datafiles (OCFS/RAW/ASM)
         Oracle Home   OCR + VOTE Datafile
 RAW     NO            YES         YES
 OCFS YES              YES         YES
 ASM     NO            NO          YES
 Local   YES           NO          NO
Option   Data    OCR          Oracle   Sizes
         Files   VOTE         Home
1        CFS1    CFS1         CFS2     3G 3G
2        RAW     RAW1         CFS3     100M 100M 3G
         ASM     RAW2
3        CFS1    CFS1         Local    3G
4        RAW     RAW1         Local    100M 100M
         ASM     RAW2
CRS install is always local
(500M of space per node)
CRS Installation

 OUI CRS install
 CRS Installation results
 CRS Patchset installation
CRS Install & Log Files

 Install\crssetup.config.bat

 CSS css\log           css\init
 CRS crs\log           crs\init
 EVM evm\log           evm\init

 Installer Log files at:
CRS Processes
OcfsFindVol.exe   3416 OracleClusterVolumeService
evmlogger.exe     1852 N/A
ocssd.exe         3932 OracleCSService
ocssd.exe         4028 N/A
evmd.exe          4044 OracleEVMService
evmd.exe          2052 N/A
crsd.exe          2236 OracleCRService
crsd.exe          2412 N/A
      drivers (.sys)
ocfs.sys               ocfs
orafencedrv.sys        OraFenceService

 Contains both CRS and RDBMS updates
 Apply CRS Patchset before RDBMS install
   –   Simplifies process
   –   Install patch to all nodes in the cluster
   –   Apply patch to each node
   –   Provides the ability for rolling updates
RDBMS Installation

 RDBMS OUI Install
 CRS Nodeapps
RDBMS Installation

 Select nodes
 Select Enterprise Edition
 Select do not create Oracle Database
  (software only)
 Apply patchset
 Run VIPCA.bat from Oracle_home\bin
CRS NodeApps

 C:\oracle\product\10.1.0\crs\BIN>crs_stat -t
Name                 Type          Target       State         Host
ora....z01.gsd application ONLINE ONLINE iwinaaz01
ora....z01.ons application ONLINE ONLINE iwinaaz01 application ONLINE ONLINE iwinaaz01
ora....z02.gsd application ONLINE ONLINE iwinaaz02
ora....z02.ons application ONLINE ONLINE iwinaaz02 application ONLINE ONLINE iwinaaz02

    CRS
    RDMS
    OCR
    Window’s

   crs_stat, crs_stop, crs_start
   crs_register, crs_unregister
   crs_getperm, crs_setperm
   crs_profile, crs_relocate
   onsctl
   srvctl
     –   Manage resources (services, database,
         instances, nodeapps)
OCR Backup

 Backups of OCR data
   – One CRS instance in a cluster automatically
     creates OCR backups every four hours.
   – Last three backups are kept
   – Full day and end of week retained also
   ocrconfig -showbackup will list locations
   ocrconfig -backuploc <directory> changes location
   Ocrconfig -export
   Orcrconfig -import

   tasklist, taskkill
   tlist (Shows command line args with -c)
   driverquery
   diskpart
   mountvol
   sc (sc query state= all)
   regmon, filemon, procexp, tcpview

Courtney Llamas
Database Engineer
ESI Application Services
HP’s WinterCorp Entries

 Entered 6 of our largest Oracle on Windows
  databases, placed 8 times in 4 categories
   –   3 DSS, 3 OLTP
   –   4 SAP, 2 custom apps
 Largest HP/Windows entry - 3248 GB
   –   2nd amongst OLTP – Windows
   –   8th in overall OLTP (Unix and Windows)
 Largest Number of Rows – 3703 Million Rows
   –   7th in DSS – Windows by Rows
Oracle on Windows at HP
Database Statistics
   HP-IT North America
   Windows Databases Instances        357
   Windows Database Servers           266
   Windows Databases Combined Size   113 TB
   Largest Windows Database          4.8 TB
   Average Size on Windows           326 GB
HP Experience on Windows

 HP has used Oracle on Windows for a wide range of
  applications since 7.3.x
    –   Packaged: SAP, PeopleSoft, Seibel, Remedy, Primavision,
        Captura, I2, Documentum
    –   Custom: Warranty and Serial Numbers, Spare Parts,
        Corporate Data Warehouse, Product Costing
 Standby databases in 7.3.4 with custom automated
 Oracle FailSafe for Windows Clusters - 8.1.7 & 9.2.0
 Oracle 9i RAC on Windows CFS
HP Best Practices

 Standards
    –   Standard builds, configurations, tools and practices
    –   Corporate security and antivirus standards
    –   Reduce overall cost and data center by utilizing shared
        database servers
 Performance
    –   Virtual Bytes
    –   SAN
 Availability
    –   Standbys
    –   Fail Safe
    –   RAC
DBA Tools

   HP Data Protector integration with RMAN
   ODR (Oracle Disaster Recovery – HP written tool)
   HP OpenView Oracle DB SPI
   Oracle Enterprise Manager (9.2, 10g)
   Windows Resource Kit, Perfmon
   Unix Utilities - MS Windows Services for Unix, MKS
   ActivePerl
   Denicomp RSH
   Scripts!
Recent Oracle Advances

 New Features
   –   PGA Aggregate Target
   –   UNDO Tablespaces
 Support for 64-bit Windows
   –   Allows for 1000’s of connections, tested up to 6
       GB virtual bytes
Plans for Future Direction

 Windows 64-bit on HP’s Itanium based Integrity
    –   Scale single instances
    –   Scale RAC instances
    –   Shared database services
 Oracle 10g on Windows
    –   Automatic SGA, Automatic Statistics, ADDM/AWR
    –   Flashback enhancements
    –   Data Pump
    –   Install and Upgrade simplified
 Oracle 10g RAC on Windows
    Vattenfall Europe Information Services
    Energy & Utilities, EMEA
                                     Vattenfall Europe Information Services, a full-service IT provider
                                     for the Vattenfall Group, hosts an Intel Itanium® 2–based HP
                                     Integrity platform running various SAP solutions for its
                                     customers B/A/S and GASAG Berliner Gaswerke AG.

    Business needs                       HP solution
                                         HP solution                    Customer benefits
•   Resolve productivity issues      •   SAP for Utilities, SAP R/3     •   250% increase in computing
    resulting from lengthy batch         4.6C and other SAP solutions       performance
    runtimes                             such as mySAP CRM,             •   33% reduction in TCO
•   Resolve performance                  mySAP SRM, SAP EP and
                                         SAP BI, comp. of SAP           •   Scalability and reliability for
    bottlenecks with bandwidth-                                             mission-critical, data-
    intensive SAP solutions              NetWeaver
                                                                            intensive SAP solutions
                                     •   HP rx5670 Integrity servers
•   Improve scalability to support
                                         (database, application and     •   Leading price/performance
    future growth
                                         test/development systems)      • Innovative offering to extend
•   Cut costs to strengthen
                                     •   HP rx2600 Integrity servers      the benefits of SAP for
    position in competitive                                               Utilities to smaller utility
    marketplace                          (backup and application)
                                                                          companies (through hosting)
                                     •   HP StorageWorks EMA12000
                                                                        • Improved customer service
                                     •   Microsoft Windows Server
                                         2003 and Oracle 9.2.0
Next Steps
 Recommended Parallel Sessions
   –   Oracle Database 10g: Best for Windows
             Monday @ 1:30 in Room 304

   –   Developing Oracle Applications with .NET
            Thursday @ 2:30 in Room 2016

   –   Oracle Developer Tools for Visual Studio .NET
             Thursday @ 4:00 in Room 2016

 Related Demos/Exhibits
   –   Oracle on Windows Lounge - Moscone South
   –   Oracle on Windows demo kiosk - DEMOGrounds

 Oracle on Windows home page
 Oracle Clustering
 Oracle Technology Network’s Windows Development Center
 Oracle Data Provider for .NET
 Oracle on .NET Developer Center

Shared By: