1 / 16

Oracle Apps at EMC

Oracle Apps at EMC. Oracle Applications Deployment. 11.0.3. 11i. R12. Partners Japan, China, Korea. Employees, Vendors (Web, Forms, Citrix). Partners, Customers (Web). Employees (Forms, Web). Quoting Pricing Configurator Incentive Compensation Projects Customer Service

cyrus-tyson
Download Presentation

Oracle Apps at EMC

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle Apps at EMC

  2. Oracle Applications Deployment 11.0.3 11i R12 Partners Japan, China, Korea Employees, Vendors (Web, Forms, Citrix) Partners, Customers (Web) Employees (Forms, Web) Quoting Pricing Configurator Incentive Compensation Projects Customer Service Tele Service InstallBase Manufacturing Finance Order Entry SSP Quoting Configurator Firewall Firewall Load Balancer Linux RHEL 4 Dell PE Nodes Linux RHEL VMs Solaris 10 Celera (NAS) Celera (NAS) Web External (9) Concurrent Manager (3) Forms Servers (5) Sun Enterprise E4500/E5500 Web/Forms Internal and External (67) Concurrent Manager (4) Solaris10, 144 GB, 36 Dual Cores 2 Node RAC Solaris 10, 224 GB, 224 Cores 3 Node RAC Linux CXLDBP1 0.5 TB EP01 2 TB CRP01 7 TB DELL R900 Symm DMX 3 Symm DMX 3 Symm DMX 3 Sun Fire 25K Sun Fire 25K Active – Active 3 nodes RAC Oracle 11g Database Linux VMs Web Interface Active – Active 2 nodes RAC Oracle 10g Database Linux App Servers Forms & Web Interfaces Active – Passive Cluster Oracle 8 Database Solaris App Servers Forms Interface Develop and Design Product

  3. Integrated Sales Cycle Order-to-Cash Services Partner Integration Oracle Apps (11.0.3, 11.5.10) Channel Management Commissions SW Development Process Inventory Management Customer Relation-ship Mgmt. Factory Integration Oracle Functional Footprint EMC is leveraging virtually all of the Oracle Applications footprint.

  4. Oracle EBS Infrastructure Design Objectives The nature of EMC’s business required an extremely available architecture for the new implementation - during certain periods, nothing less than 100% availability is satisfactory. Key design characteristics: • Highly Available (> 99% availability) • Accomplished with a combination of hIGHLY Available RAC Cluster (DB Tier), Cisco ACE for the Applications server farm (Application Tier), and Cisco fiber-channel switching (physical layer) • No Data Loss • An abrupt loss of the production site will not result in the loss of any committed transactions • Accomplished through a combination of EMC SRDF and Oracle standby database technology • < 4-hour Recovery Time • In the event of a site failure, IT must be able to fail over to the remote site and return Catalyst to operational condition within 4 hours • Accomplished through rigorous attention to scripting and failover event scripting

  5. Oracle E-Business Suite at EMC Very high usage penetration within the enterprise 50,000+ Named Users 4,000+ Concurrent Users at peak periods 70+ Application Tiers –VM /Linux Two-node RAC Architecture - 224 cores Oracle Database 10g R2, Sun Solaris 10 Extremely dense module usage Largest users of Service, Install Base and Contracts, Oracle Sales, Configurator One of the largest users of iStore, Projects, TCA, Order Management, etc. Application Continuity Tool – keeping 11i available during maintenance One of the largest deployments of Oracle eBusiness Suite in the world.

  6. Oracle 11i Architecture Modules Quoting Pricing Configurator Incentive Compensation Projects Customer Service Tele Service InstallBase Users 50,000 Users Worldwide 4000 Concurrent Users Employees and Partners Technology Oracle 10g database Oracle eBusiness Suite (11i) EMC SAN and NAS Storage Sun 25K Enterprise Servers (RAC) Dell PowerEdge Linux App Servers Cisco Load Balancer Employees, Vendors (Web, Forms, Citrix) Partners, Customers Firewall Cisco Load Balancer crm.emc.com Linux RHEL 4 Linux RHEL 4 Linux RHEL 4 Powerlink Celera (NAS) eServices Web/Forms External (14) Dell PE 2850 Web/Forms Internal (53) Dell PE 2850 Concurrent Manager (2) Dell PE 6850 Catalyst WebMethods 2 Node RAC Solaris 10, 224 GB, 224 Cores Outerbay Sun Fire 25K Dialhome Intergation Services CRP01 7 TB CRI Configurator Connectrix Symm DMX 3

  7. Current Technology Stack ACE Storage (EMC) Unix (Sun, Veritas, EMC) Database (Oracle) Application (Oracle, Redhat) Users Web/Forms Tier (67 VM nodes) Instance 1 (CRP01a) Instance 2 (CRP01b) Apache JVM Forms Database crm.emc.com HBA SQL*Net RAC – 2 nodes CRS Powerpath File Systems JDBC Connectrix Concurrent Tier (4 nodes) Veritas Cluster Volume Manager Solaris 10 OS CRS and Rdbms Database Instances Services Listeners Concurrent Reports Interconnect Veritas odm RAID 10 Protection I/O Fencing Aging component, candidate for upgrade Model - Sun 25 K OS - Solaris 10 CPUs – 224 Cores Memory - 224 GB Veritas RAC 5.0 Powerpath 5.0.2 Oracle 10.2.0.3 Size 7 TB Growth 150 GB / Month SGA 30 GB each 6 Listeners EDL Backup EBusiness Suite Linux RHEL 4 Shared Appltop PCP Enabled CM VMWARE Web Dell PE 6850 CM Symm DMX 3 (4500) 720 x 146 GB drives 95 TB Total RAW RAID 10 Protection Cache 256GB mirrored

  8. Future 11i Technology Stack Database (Oracle) Application (Oracle, Redhat) Storage (EMC) Linux (RedHat, Cisco, EMC) Load Balancer (ACE) Users Web/Forms Tier (67 nodes) Cisco UCS Instance 3 (CRP01c) Instance 1 (CRP01a) Instance 2 (CRP01b) Instance 4 (CRP01d) Apache JVM Forms HBA SQL*Net RAC – 4 nodes CRS Database Powerpath crm.emc.com Concurrent Tier (2 nodes) ASM JDBC Connectrix 10 Gb Interconnect RHEL 5.3 CRS and Rdbms Database Instances Services Listeners Concurrent Reports I/O Fencing Oracle CRS Oracle ASM RAID 10 Protection Symmetrix V-Max 146 FC GB drives SATA & EFD Drives 95 TB Total RAW RAID 10 Protection Cache 256GB mirrored Model – Cisco UCS (Nehalem) OS – RHEL 5.3 CPUs – 2 (test) Memory - 96GB (test) Powerpath 5.3 Oracle 11G Size 7 TB Growth 100 GB / Month SGA 30+ GB each 6 Listeners load balancing EDL Backup EBusiness Suite Linux RHEL 4 Shared Appltop PCP Enabled CM VMware Web VMware CM

  9. Applications and Database Cloning • Challenge: • Copy production database and application code to test environment, apply post clone changes to make it test or development environment. • Copy process has to be very fast to reduce the test and development downtime. • Solution: • Using Open Replicator to copy the data across SAN • Business Benefits: • Only 4 hours Downtime for TEST or Dev for Database Copy • Reduce Test / Dev Database Size during Clone (Subsetting) • No manual intervention or scripting • Preserve Apps DBA Resources • No network Impact 2. Open Replicator Replication (4 hours) Backup (Proxy) Reporting 6. BCV Restore(4 hours) 1. Backup – BCV (30 mins) 3. BCV Restore - (4 hours) 5. BCV Copy (1 hour) TEST DEV PROD (7TB) Production Test / Dev 4. Post Clone, Migrations

  10. Data Data Optimal DR Solution Westboro Hopkinton Dynamic SRDF X Redo Dynamic SRDF Redo Production Database Server DR Database Server Production Database Server DR Database Server Mount to Host Arch Arch Dynamic SRDF Recover Database RDF Link Personality Switch BCV BCV Roll Forward DR Database Roll Forward DR Database Switch Database Roles DR Site - Initial Build Fail Database to DR Break Data RDF Link Database Failure Database is Open – Read Only Custom Script is Running Archive BCV is Mounted Archive Log Files are Registered Background Process Apply’s Logs Alert Log is Monitored for Complete/Errors Primary Database Failure Symetrix/V-Max Recognizes Failure Custom Script is Running Dynamic SRDF Personality Switch ASM is Restarted (Arch BCV Hidden) Redo and Arch Luns Mount to Current DR Recover Database

  11. Production Environments Layout Disaster Recovery (Hopkinton) Production (Westboro) DR Apply Logs Hourly to Keep in Sync • Zero data loss solution • Minimal overhead to production • Automated recovery • No DB block corruption • DR cab be opened as read only • DR Hardwar for performance testing • Fastest backup method • No performance impact to Prod during backup • Database validation before backup DR Prod BCV BCV ACT DR Reporting2 Daily 12AM Reporting HA Reporting1 ACT Monthly Rel Daily 1 PM Initial Build using SRDF Perf Test Near Real Time Shareplex2 Backup Shareplex 1 Near Real Time Daily 5 AM Symmetrix DMX 3 (4500) 720 drives, 146 GB each 95 TB Total RAW RAID 10 Protection Symmetrix DMX 3 (4500) 720 drives, 146 GB each 95 TB Total RAW RAID 10 Protection 30 days retention 90 days retention Tape Library EMC Disk Library

  12. Sky Rocketing Growth • Impact of Growth • Slow Performance • Infrastructure Costs • Continuously adding storage • Additional CPU and Memory • Maintenance Costs • Resource Costs • DBA and development resources • Storage and Unix resources

  13. Storage Multiplier -2008 Tape Backup of Prod 90 TB 153 TB Backup of (Prod, Splx, Dev, Test, etc) Onto EDL with RAID 28 TB 63 TB 35 TB 3TB (Dev, Test, Training, Perf, etc) RAID 12TB (Dev, Test, Training, Perf) 32 TB 20 TB 5TB (Prod, Splx, SBY, ACT, Bkup) Mirror 15 TB 5TB (Prod, Splx, SBY, ACT, Bkup) DR 10 TB 5TB (Prod, Splx, SBY, ACT, Bkup) Mirror 5 TB 5TB (Prod, Splex, SBY, ACT, Bkup) Oracle 11i Multiplier 1 TB of Data

  14. Application Data ILM - Strategy Nearline Database

  15. Storage Multiplier Effect Moving 1TB from Prod to Archive 140 TB 153TB 63TB Removing Tape Backup 60 TB 35TB 32TB Subsetting 1TB from Non-Production Saves 15 TB 20TB 15TB 10TB 5TB Oracle 11i Multiplier 1 TB of Data

  16. Storage Optimization – Archiving / Subsetting Current Year 2008 153 TB 64 TB 40TB Decomm of 3 Environments Elimination of Tape Backups Reduce Backup Retention Rman Backup Subsetting EDL Backup (30) Non Prod (9) Disaster Recovery (5) Production (5) EDL Backup (30) Non Prod (9) Disaster Recovery (5) Production (5) Tape Backup (90) EDL Backup (30) Non Prod (12) Disaster Recovery (5) Production (5) Oracle 11i Multiplier Effect – 1 TB

More Related