Doag Special Interest Day 20.03.2003 Walldorf

DOAG Special Interest day 20.03.2003 Walldorf

© Copyright 2003 ABB. All rights reserved. - 1 24.03.2003

Jürgen Wingerter, ABB

Insert image here

Running SAP R/3 on Oracle 9.2 Real Application Clusters at ABB

Agenda STRATEGY •Initial situation at ABB GSC Hosting Services in Germany

• How does RAC fit into an SAP R/3 Hosting Center ? MOTIVATION • The reasons to start an RAC implementation THE RAC PILOT AT ABB

© Copyright 2002 ABB - 2 -

•RAC configuration (bits&bytes)

• Status of the RAC pilot tests SUMMARY

ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

© Copyright 2002 ABB - 3 -

ABB – Our businesses Power Technology

Automation Technologies

A broad range of products, services and solutions for power transmission and distribution

Products, systems, software and services for the automation and optimization of industrial, commercial and utility operations

Oil, Gas and Petrochemicals

Financial Services

Oil and gas drilling onshore and offshore, offshore production installations, refineries and petrochemical plants

Financing, sales support, risk management services and insurance for internal and external customers

ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

SAP R/3 Hosting at GSC in Germany at a glance Our Mission:

Internal and External Service Hosting

Productive SAP Systems:

~20

SAP Releases:

3.1I – 4.6C

Productive Users:

10.000 (from 56 Users ... 2400 Users)

Operating Systems:

Tru64, HP-UX, NT, AIX, Linux

Servers:

~100

Storage:

12 TB

Enabling Technology:

Server – Partitioning ( Hard + Soft )

© Copyright 2002 ABB - 4 -

Storage Area Networks SAP New Dimension Products Monitoring-Tools (R3mon) Standby Databases ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

SAP R/3 datacenter strategy SAPGUIs LAN

WAN

Application Server

Application Server

LAN

Application Server

LAN

WAN

OS Cluster + Oracle RAC

© Copyright 2002 ABB - 5 -

SAN Storage

Computer room 1

Host 1

Host 2

Host x

DB 1

DB 1

DB 1

DB 2

DB 2

DB 2

DB n

DB n

DB n

SAN Storage LAN

Shadow Database with ? t= t1

Computer room 2 LAN

WAN

Redolog Shipment

Geographic location 1

Application Server + Shadow-DB 1 Shadow-DB 2 Shadow-DB 3

Geographic location 2 ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

Motivation to start an RAC implementation MOTIVATION 1: Higher availability • New requirements on the availability of the SAP R/3 Servers • Negotiation of maintenance windows is becoming difficult • An increasing number of workplaces rely on SAP R/3 MOTIVATION 2: Improved Agility • Dynamical growth by adding more servers • Better reuse of equipment (mergers and consolidation)

© Copyright 2002 ABB - 6 -

MOTIVATION 3: Cost savings • Buy commodity servers due to a scale out approach • REDUCE MAINTENANCE COSTS BY ELIMINATING SPOFs

ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

SAP R/3 with RAC Pilot Project at ABB

Project objective: Proof of concept Oracle 9i RAC with SAP R/3 4.6C and HP Tru64 UNIX 5.1A Cluster Technology Project duration: 3 months

© Copyright 2002 ABB - 7 -

Project team: Oracle, SAP, HP and ABB SAP R/3 System: SAP HR Rel. 4.6C, DB-Size 250 GB, Oracle 8.0.6

ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

Schematic RAC Pilot Hardware Configuration

Network Interconnect

HOST A

Cluster Interconnect ( Memory Channel )

Fibre Channel

Fibre Channel

© Copyright 2002 ABB - 8 -

HOST B

SAN Storage

ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

Detailed RAC Pilot Hardware Configuration Network Interconnect

Cluster Interconnect MC

Tr.

MEMORY CHANNEL 1

Tr.

MC

MC

Tr.

MEMORY CHANNEL 2

Tr.

MC

FABRIC 1

Switch 1

© Copyright 2002 ABB - 9 -

FC FC

Storage

HP ES45 FC FC

Switch 2

HP ES45

FABRIC 2

MC = Memory Channel HBA Tr = Transceiver Copper/Optical FC = Fibre Channel HBA ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

Technical Architecture for SAP R/3 on Oracle HOST alpha1

HOST alpha2 Cluster Filesystem

Oracle Instance 1 SID

Listener

LISTENER.ORA

© Copyright 2002 ABB - 10 -

SAP R/3 Central Instance

Application Servers

TNSNAMES.ORA

SAP R/3 Dialog Instance

TNSNAMES.ORA

ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

Technical Architecture for SAP R/3 on Oracle RAC HOST alpha1 Oracle Instance 1 P01001

Cluster Filesystem

Oracle Instance 2 P01002

Listener_1

LISTENER.ORA

Listener_2

SAP R/3 Central Instance

© Copyright 2002 ABB - 11 -

HOST alpha2

TNSNAMES.ORA Listener_1 Listener_2

TNSNAMES.ORA Listener_2 Listener_1

SAP R/3 Dialog Instance

TNSNAMES.ORA

Application Servers

Listener_1 Listener_2 ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

Status of the RAC Pilot Project at ABB

? ?

Migrate SAP HR 4.6C with 8.0.6 to 9.2 RAC Check Transparent Application Failover

© Copyright 2002 ABB - 12 -

? Inside the Cluster ? Outside the Cluster ? ? ? ? ? ? ? Status

Check offline brbackup / brrestore with Backint Interface (TSM) Implement Replicated Enqueue (unsupported, for testing only) Check the impact of RAC on the performance of SAP R/3 Implement new SAPDBA Check online backup and Point in Time recovery Check all ABB administration and operation tasks Evaluation of deliverables before productive start of RAC Migrate HR productive system to RAC

19.3.03 ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

Conclusion • Oracle Real Application Clusters ? Oracle Parallel Server !!!! • RAC perfectly fits into our SAP R/3 datacenter strategy • Cluster Filesystem is key for smoothless operation of RAC with SAP • No adjustments in the SAP Application are needed for RAC. • A cluster and a SAN is a good basis for an RAC implementation • RAC is the enabling technology for a scale out approach with SAP R/3

© Copyright 2002 ABB - 13 -

• Oracle Real Application Clusters saves expenses (REAL $$$) • Licensing and Availability of RAC for SAP R/3 needs to be specified • Migration to Oracle RAC is easy. No DB unload and DB load !

ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

© Copyright 2002 ABB - 14 -

Many thanks for your attention !

ABB GSC/ISI-SE Wingerter: Running SAP R/3 on Oracle 9.2 RAC at ABB

Discover great products and services at WWW.ABB.COM