Jerry Held

1
(No Transcript)
2
SAP R/3 on RAC at Colgate Palmolive
Session id 40042

• Arthur Fleiss Jan Klokkers
• Architect Sr. Director SAP
  Development
• Colgate Palmolive Oracle Corporation

3
Topics

• SAP-RAC Scenarios
• Cluster Filesystem
• SAP-RAC Scalability
• SAP-RAC Technical Architecture
• SAP-RAC at Colgate-Palmolive

4
SAP Scenario mySAP Setup with RAC
Presentation
Multiple SAP Application Servers
Multiple RAC Database Instances
5
SAP Scenarios MCOD with RAC
Oracle RACInstance 1
SAP R/3System 1
6
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

7
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

8
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
9
SAP R/3 on Cluster - Architecture
Node 1
Node 2
Cluster File System
Oracle Instance 1 SID
Listener
10
SAP R/3 with RAC - Architecture
Node 2
Cluster File System
SAP R/3 Dialog Instance(s)
11
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,
Hills Science Diet and Hills Prescription Diet
Pet Foods.
12
Company Profile 2001 Sales by Region
Europe
Latin
America
20
27
Hills
12
Asia /
North America
Africa
25
16
13
OVERVIEW

• Project team
• Environment
• Results
• Plans

14
Project Team

• Colgate
• 1 DBA , 1 Sysadmin
• Oracle
• IBM
• SAP

15
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 _at_
• - aix 5.1
• - hacmp 4.4
• - gpfs 1.5
• - ssd 1.3
• 5- Enable Rac

16
ENVIRONMENT
17
Results

• 1- Implementation was not difficult
• 2- No show-stoppers
• 3- Performance is good( low single )
• 4- No surprises during destructive testing

18
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
  Dbs onto RAC
• 5- Will upgrade HR to Enterprise
• 6- Upgrade AIX stack

19
Reminder please complete the OracleWorld
online session surveyThank you.
20
A
21
(No Transcript)