Oracle RAC 10gRAC
Agenda 1. Why Oracle on Dell Dell Oracle on Linux Dell Oracle Dell Oracle 2. Oracle Clustering Solution Oracle Real Application Cluster 3. Case Study 4. Oracle RAC Solution on Dell Oracle RAC
1. Why Oracle on Dell/Linux? Oracle9i/10g Oracle9i/10g RAC Linux Dell Dell EMCDell EMC Oracle 1 st Dell RedHat Oracle9i RAC 1 st Dell RedHat Oracle9i 1 st Bottom line: Oracle on Linux is pre-conditioned to run on Dell 9i RAC + emc = Dell 10gRAC
Dell/Oracle (US) US Oracle9i RAC 1 250,000 IT 2,000 Dell Linux 1997 Dell Oracle Oracle9i RAC 2000 Linux Dell Oracle9i RAC 2002 2,000 1998 2001 Linux EMC EMC Oracle9i RAC *Dell s Sales ODS database is processing over 250,000 transactions per hour in peak hours. It is also responding to 100,000+ queries/requests per hour at the same time. (as of April 2003)
Dell/Oracle Running Oracle 9i on Linux, Dell is: 1. 47% faster 1 4CPU UNIX 47% 2. 39% Less expensive 1 4CPU UNIX 39% 3. More reliable UNIX Dell 4. Faster to Deploy 2 Dell Oracle 5. Safe Oracle Dell Dell Oracle Linux 6. Easy UNIXLinux 1 Source: Migrating Oracle9i - Based Sun Servers to Dell Servers Running Linux, Part 2 (January 2003), by Todd Muirhead and Dave Jaffe 2 www.sun.com & www.dell.com
(2003 9 18 ) Oracle Direct i-seminar Xeon Oracle 10g SE RAC AS OCS EBS 10g On Oracle
Oracle 10g Public LAN Oracle10g SAN DB DB Tape PowerEdge 2650 x 2 Xeon TM 3.06GHz x 2CPU 2GB 36GB 3 Dell EMC CX300 Oracle Database 10g SE 10 Named User Plus OS Enterprise Linux AS 3 Microsoft Windows Server TM 2003() PowerConnect 5212 3 1
Oracle Collaboration Suite Oracle Files Oracle Oracle Web Conferencing TV Web Oracle Email Collaboration Suite 100 4,213,000 PowerEdge 2600 Xeon TM 2.40GHz 2GB 36GBHDD x 3
2. Oracle Clustering Solution Real Application Clusters Oracle9i Oracle RDBMS Active/Active DB
Real Application Clusters TAF Transparent Application Failover H/W Cache Fusion RAC
vs. 3-Node Cluster vs. 12-Way 9:36:00 8:24:00 7:12:00 6:00:00 4:48:00 3:36:00 2:24:00 1:12:00 0:00:00 Time (sec) 1 Node 8CPU Index Build 4B Row Table Table Scan 4B Row Table Table Scan w/ Aggregates 4:33 1 Node 12CPU 2 Node 8CPU 2:13 3 Node 12CPU Source: Intel Telco Customer Performance Study, DEC01
: 2-Node Cluster vs. 8-Way Two Dell 4-ways 4 Running Database Workload Outperform HP 8-way8 26% Savings 1.7X X Performance Superior Availability 12,392 TPM $83K 21,494 TPM $62K Source: Application Scale-out with the Dell PowerEdge 6650: Clustered Enterprise Database, by Dave Jaffe http://www.dell.com/downloads/global/solutions/6650_database_wpapr.pdf
3. Case Study A ( ) UNIX UNIX Linux Oracle9i RAC : Oracle9i RAC H/W SAN IA Linux SAN Dell EMC CX300 Oracle 2 RAC PowerEdge 2650 x2 DB Red Hat Linux AS2.1 73GB HDD x10 Oracle9i RAC PowerEdge 750 NetVault) PowerVault 122T
B ( ) WWW J2EE DB PowerEdge 2650 2 Xeon DP 2CPU) Dell EMC CX400 CPU 100 7 5 ROI IA Oracle RAC DELL+EMC 15
C Oracle RAC DB PowerEdge2650 x 2 DELL EMC CX200 HDD 73GBx7 MSCS PowerEdge2650 x 2 DELL EMC CX200 HDD 73GBx6 LAN 1/10 24 265
4. Oracle RAC Solution on Dell Intel / SnapView Dell EMC / / 1 IA IA RAC Dell EMC 2
1. HBA,NIC,FC-Switch etc. 2. SnapView MirrorView < PowerPath > HBA HBA HBA Sync Production < SnapVIew CLONE> Backup Reverse Sync Oracle
Oracle RAC on Dell EMC (US) ORACLE US) OS Dell Oracle Team(US) RAC
RAC on Dell Oracle9i /10g RAC EE for Linux RedHat 2004 8 24 SAN DB DB DB RAC CX300,CX500,CX700 DB PE26xx/(28xx) or PE66xx/(68xx) HBA QLA2340 2 /node Node 2 8 node RAW OCFS ASM Backup RAW:CLONE ASM:RMAN OS 9i: RedHat EL2.1 10g: RedHat EL3.0 Update2
RAC on Dell Oracle10g RAC SE for Linux RedHat 2004 8 24 SAN DB DB RAC CX300,(CX500,CX700) DB PE26 /(28 ) HBA QLA2340 2 /node Node 2node ASM Backup RMAN OS RedHat EL3.0 Update2 OracleRDMBS R10.1.0.2
Oracle 10g RAC on Dell AP DB
IT DPS Dell 3Tier
Dell Oracle RAC DB Oracle Oracle Oracle Oracle / /