210 likes | 495 Views
Session id: 40042. SAP R/3 on RAC at Colgate Palmolive. Arthur Fleiss Jan Klokkers Architect Sr. Director SAP Development Colgate Palmolive Oracle Corporation. Topics. SAP-RAC Scenarios Cluster Filesystem SAP-RAC Scalability
E N D
Session id: 40042 SAP R/3 on RAC at Colgate Palmolive Arthur Fleiss Jan Klokkers Architect Sr. Director SAP Development Colgate Palmolive Oracle Corporation
Topics • SAP-RAC Scenarios • Cluster Filesystem • SAP-RAC Scalability • SAP-RAC Technical Architecture • SAP-RAC at Colgate-Palmolive
SAP Scenario – mySAP Setup with RAC Presentation Multiple SAP Application Servers Multiple RAC Database Instances
SAP R/3System 2 Oracle RACInstance 2 SAP CRMSystem Oracle RACInstance 3 SAP Scenarios – MCOD with RAC SAP R/3System 1 Oracle RACInstance 1
Technical Highlights – Cluster File System • Shared Software Location (Oracle, SAP, others) • Easier Install and Upgrade • Oracle Installer (OUI) is CFS aware • No changes for SAP Install and Upgrades • Simplified Database Storage Management • No need to pre-create each Oracle data file • No need to slice disk for each Oracle data file • Easier to increase Oracle data file size • Simplified Administration and Monitoring – No difference from Single Instance • Single Location for Backup and Archives • Single Location for Configuration Files of Oracle and SAP
Technical Highlights – Cluster File System • Support for vendor Cluster File System (CFS) • Fujitsu Siemens - PrimeCluster • HP Tru64 - TruCluster • IBM AIX – General Parallel File System (GPFS) • Veritas – Database Edition/Advanced Cluster • Oracle Built CFS on Linux and NT
SAP R/3 Scalability with RAC 82% Scalability/Box SAP R/3 4.6C Parallel Three Tier SD Benchmark on RAC 12,000 # Users 6580 3640
Central Instance (ENQ, MSG-Server) SAP R/3 Dialog Instance(s) SAP R/3 Dialog Instance(s) SAP R/3 Dialog Instance(s) SAP R/3 on Cluster - Architecture Node 1 Node 2 Cluster File System Oracle Instance 1 SID Listener
Node 1 Oracle Instance 1 SID Oracle Instance 2 SID DOWN ! Listener 2 Listener 1 Central Instance (ENQ, MSG-Server) Central Instance (Automatic failover with Replicated Enqueue) SAP R/3 Dialog Instance SAP R/3 Dialog Instance(s) SAP R/3 Dialog Instance(s) Automatic with Transparent Application Failover SAP R/3 with RAC - Architecture Node 2 Cluster File System SAP R/3 Dialog Instance(s)
Company Overview • Colgate Palmolive is the worldwide leader in Oral Care, Personal Care, Household Surface Care, Fabric Care and Pet Nutrition • Global presence. Operations in over 200 countries around the world. Worldwide revenues of $9+ billion. • Major global brands include Colgate, Palmolive, Mennen, Kolynos, Ajax, Soupline, Fab, Hill’s Science Diet and Hill’s Prescription Diet Pet Foods.
Company Profile 2001 Sales by Region Europe Latin America 20% 27% Hills 12% Asia / North America Africa 25% 16%
OVERVIEW • Project team • Environment • Results • Plans
Project Team • Colgate • 1 DBA , 1 Sysadmin • Oracle • IBM • SAP
Upgrade Path 0- SAP HR 4.6C / 4.6D kernel – 36 countries 1- Solaris 2.6 – Oracle 8.1 2- Upgrade in place to Oracle 9.2 3- Exp/Imp to Oracle 9.2 on AIX (non clustered) 4- Copy to AIX cluster @ - aix 5.1 - hacmp 4.4 - gpfs 1.5 - ssd 1.3 5- Enable Rac
CABLETRON SSR GB-GPFS IBM 44P ORACLE&SAP MCDATA 6064 IBM ESS F20 100mb RAC IBM 44P ORACLE&SAP CABLETRON SSR IBM 44P ORACLE&SAP 10mb end-user CABLETRON SS6000 IBM S85 SAP only ENVIRONMENT
Results 1- Implementation was not difficult 2- No show-stoppers 3- Performance is good( low single %) 4- No surprises during destructive testing
Plans 1- Will implement in 3 tier HR landscape 2- Will test ‘replicated-ENQ’ 3- Will evaluate for other R3 4- Will look at consolidating multiple non SAP Db’s onto RAC 5- Will upgrade HR to ‘Enterprise’ 6- Upgrade AIX stack
Reminder – please complete the OracleWorld online session surveyThank you.
Q & Q U E S T I O N S A N S W E R S A