Oracle 10 g RAC on Linux with Networked

Oracle 10 g RAC on Linux with Networked Storage An Overview Sunil Mahale Database Storage Solutions Architect Network Appliance, Inc mahale@netapp. com Network Appliance Inc 10/17/2021 1

Objectives 4 Oracle 10 g RAC Architecture - Overview 4 Why Oracle 10 g RAC on Linux ? 4 Oracle 10 g RAC – Validated Solution 4 Performance & Scalability 4 NFS O_DIRECT enhancements in RHEL 3 4 Customer Case Study 4 Q&A Network Appliance Inc 10/17/2021 2

Oracle 10 g RAC Architecture - Overview 4 Each instance – – – 4 Own SGA Background processes Data and control files are shared Own redo logs Own set of rollback/undo tablespaces Cache fusion Guarantees cache coherency – No disk I/O costs – Network Appliance Inc 10/17/2021 3

Oracle 10 g RAC Architecture Instance A Instance B SGA Cluster Manager Global Cache Service Comm. Layer Cluster Interconnect Shared Disk Driver Node 1 Comm. Layer Cluster Manager Shared Disk Driver Node 2 Shared Disk Sub-system Network Appliance Inc 4

Oracle 10 g RAC Architecture 4 Integrated Clusterware Management (CRS) 4 All nodes must be on the same OS 4 Works with existing vendor clusterware 4 SSI Management 4 Fast Connection Failover (VIPCA) 4 Zero Downtime Patching Network Appliance Inc 5

CRS Architecture 4 CRSD (Cluster Ready Services Daemon) – – – 4 OCSSD (Oracle Cluster Synchronization SD) – – – 4 Engine for HA operation Manages application resources (start, stop, fail) Maintains configuration profile in OCR Runs in RAC and single instance with ASM Node membership Group services Provides cluster locking Internode communication & voting disk monitoring EVMD (Event Manager Daemon) – Generates Events Network Appliance Inc 6

CRS Architecture 4 CRS should be installed before installing 10 g RAC 4 CRS_HOME & ORACLE_HOME, different 4 Shared location for voting disk and OCR 4 Network Interfaces: – – 4 Public Interface (Node Name/Host Name) Private Interface (Cluster Interconnect) Virtual Interface (VIPCA) Storage Interface (Dedicated Network Interface for Storage) Ora. Inventory cannot be shared Network Appliance Inc 7

Why Oracle 10 g. RAC on Linux with Net. App 4 Designed for shared disk 4 A shared file system is built in 4 Improved manageability 4 Snapshot™/Snap. Restore™ Reduces planned downtime – Allows for flexible upgrade/testing options – 4 Immediate online storage scalability 4 High degree of uptime Network Appliance Inc 8

Oracle 10 g RAC on NFS – Validated Solution 4 Minimum Hardware Requirements – – 4 Cluster Nodes • 2 * 2 way, 2 GB RAM Intel architecture based servers • 2 * Gigabit Ethernet NICs (cluster interconnect) • 2 * Gigabit Ethernet NICs (for filer i/o) Storage • 1 * Network Appliance filer (F 2 xx/F 9 xx) • 1 * 8 port Gigabit Ethernet Switch • 1 * Gigabit Ethernet NIC Software Requirements – – Oracle 10 g RAC Release 10. 1. 0. 2 with RAC license Red Hat Enterprise Linux 3, Update 2, kernel 2. 4. 21 -15 Network Appliance Inc 10/17/2021 9

Oracle 10 g RAC – Validated Solution Public Network/ VIP 10/100 Switch eth 0 eth 2: heartbeat eth 0 CPQRH 1 CPQRH 2 Gigabit switch eth 1 Private network e 5 Dedicated Gigabit Network to the Filer Cluster Interconnect network Network Appliance Inc 10/17/2021 10

Oracle 10 g RAC - Validated Solution 4 Volumes – – – 4 Volhome (Shared Oracle/CRS Home) Vollog (Oracle log files, control files & arch logs) Voldb (Shared Oracle datafiles) Mount options rw, bg, hard, nointr, rsize=32768, wsize=32768, tcp, actimeo=0, vers=3 – – cssfile for CRS voting disk ocrfile for Cluster Management utilities such as dbca, olsnodes, etc Network Appliance Inc 10/17/2021 11

Oracle 10 g RAC - Validated Solution 4 Installation Highlights (contd…) – Install and configure Oracle 10 g RAC CRS – Install Oracle 10 g RAC on the cluster nodes. Do not create database during the install – Enable direct IO for database, filesystemio_options=direct. IO – Run netca & dbca after the Oracle installation process – Refer to: www. netapp. com/tech_library/3339. html Network Appliance Inc 10/17/2021 12

Oracle RAC Validated Configurations Network Appliance Inc 10/17/2021 13

10 g RAC Backup and Recovery 4 Backups in Real Application Cluster – Recommendations • Separate volumes • Accessible from all nodes – Online redo and archive log • Reside in a single volume • Accessible from all the nodes – Use Net. App “snap create” to take snapshots – More details at http: //www. netapp. com Network Appliance Inc 10/17/2021 15

Fast Recovery from Unplanned Downtimes Database Recovery Scenario - An Example 1. 300 GB database 2. Tape recovery time is 60 GB/hour 3. Normal Recovery time is 5 hours + log replay 4. Recovery time with Net. App: 2 min + log replay Oracle 10 g RAC Multiple Instances One Database Oracle 10 g RAC Database Gigabit Ethernet Oracle Logs Network Appliance Inc 10/17/2021 16

Case Study: 8 -Node 9 i RAC Deployment Load generator Cisco Switch 8 Intel Xeon Processor based Servers running RH 3. 0 AS DB Server DB Server 4 way – 2 GHz Cisco Switch Net. App® FAS 960 Clustered Filer Network Appliance Inc 10/17/2021 17

Test environment · Telco App : A online telco app that allows a customer to log on and create a list of friends and family, they can then obtain discounts when phoning these numbers. The benchmark simulates the SQL that is generated by the mid tier. 70% of all transactions perform an insert or update. · Order Entry : Similar to the TPC-C benchmark. Simulates customers ordering products and the associated transactions. · Insurance Warehouse : A large star schema that tests scanning and aggregation performance. Network Appliance Inc 10/17/2021 18

Metric – Transactions Network Appliance Inc 10/17/2021 19

Metric – Node scalability Network Appliance Inc 10/17/2021 20

NFS O_DIRECT Enhancement in RHEL 3 4 NFS O_DIRECT – – 4 Bypasses file system buffer cache Available in RHEL 3 Update 2 Enabling O_DIRECT – – – Metalink patch for Oracle 9 i (2448994) Set filesystemio_options=direct. IO Oracle 10 g Direct IO is built in Network Appliance Inc 10/17/2021 21

NFS O_DIRECT Enhancement in RHEL 3 Network Appliance Inc 10/17/2021 22

Summary The Solution Oracle: Oracle 10 g Real Application Clusters on RHEL 3 2. Network Appliance: Net. App FAS 9 XX/F 8 XX 3. Linux: RHEL 3. 0 with Direct. IO 1. Network Appliance Inc 10/17/2021 23

Q& A QUESTIONS ANSWERS Network Appliance Inc 10/17/2021 24