Jerry Held

1
(No Transcript)
2
Oracle and SAP Development Update
Session id 40041

• Dr. Christian Graf Jan Klokkers
• Development Manager Senior Director
• DB Platforms Oracle SAP Development
• SAP AG Oracle
  Corporation

3
Topics

• Introduction
• SAP Technical Product Architecture
• SAP Platform Support
• SAP-Oracle Certification Matrix
• SAP-Oracle Release Strategy
• SAP-Oracle Product Integration
• SAP BRNews

4
Introduction

• More than 14 years of SAP Oracle cooperation
• More than 10,000 SAP customers use Oracle
• 2 out of 3 SAP installations run on Oracle
  Database
• Joint SAP Oracle development/platform team in
  Walldorf
• Joint support teams in Rot (Germany) US
• SAP Oracle Partner/Presales teams in Walldorf

5
SAP Technical Product Architecture
Oracle Database
6
SAP Platform Support

• AIX --- X
• HP-UX PA-RISC --- X
• HP-UX IA64 --- Ramp
  Up
• HP Tru64 ---
  X
• Solaris ---
  X
• Linux (SLES8, RH AS 2.1)H X Ramp Up
• Windows X X

7
SAP Platform Support
OS platform coverage General info

• SAP Kernel Release Note Number
• 3.1I 23875
• 4.0x/4.5x 85838
• 4.6x 156548
• 6.x 407314
• http//www.service.sap.com/platforms

8
SAP on Oracle Certification Matrix
SAP

• 31I 8.1.7 9.2 12/03 12/05
• 40B 8.1.7 9.2 12/03 12/05
• 45B 8.1.7 9.2 12/03 12/05
• WAS 4.6C 8.1.7 9.2 12/03 12/05
• WAS 6.10 8.1.7 9.2 12/03 12/05
• WAS 6.20 (8.1.7) 9.2
  12/03 12/05
• WAS 6.30 9.2 12/05
• WAS 6.40 (Q4/03) 9.2 12/05

9
Oracle Database 10g Status at SAP

• SAP AG is Active Beta Partner
• SAP Product Certification planned with Terminal
  Release of Oracle Database 10g in 2005

10
SAP will support Oracle 10g, the safe, reliable
and scalable clustered database.
Karl-Heinz Hess, Member of the Extended
Management Board, SAP AG
11
Oracle Functionality in SAP Products (Part I)

• Data Guard Physical Standby
• Cost Based Optimizer and CBO Hints
• Partitioning
• Parallel Query
• NT Failsafe
• OCI
• JDBC
• PL/SQL
• RMAN
• Bitmap Indexes (SAP BW)

12
Oracle Functionality in SAP Products (Part II)

• Star Query Optimization with specific SAP
  enhancements
• LMTS
• ASSM
• Automatic PGA
• Automatic SGA
• SP Files
• Online Redefinition Package

• DBMS_STATS Package
• DBMS_METADATA Package
• Connect By
• SQL Merge
• Unrecoverable Operations
• LOBS
• Transportable Tablespaces
• Table Monitoring Attribute

13
Oracle 9.2 Feature Integration
SAP OSS note 598678 Entry point for 9i feature
recommendations!
14
Real Application Clusters Certification Process

• RAC certification per platform
• Three step process
• Technical validation
• Pilot customer
• Ramp Up Phase
• Intensive OS Partner collaboration required
• Hardware
• Engineers

15
Real Application Clusters Requirements

• Global/Cluster Filesystem. Initial Certification
  Examples
• Fujitsu Siemens Net App Filer (Solaris, Linux)
  or
• Fujitsu CFS
• HP Tru64 TruCluster
• HP-UX PA-RISC Veritas Advanced Cluster
• HP-UX IA-64 Veritas Advanced Cluster
• IBM AIX GPFS
• Linux Oracle CFS
• SUN Sun Cluster with PxFS
• Windows Oracle CFS

16
Real Application Clusters Certification Status
by Platform

• HP Tru64
• First productive customer ABB
• Ramp Up Phase (up to ten more customers)
• IBM AIX
• One Pilot customer finished
• Second Pilot Customer
• Ramp Up Phase in Q4CY2003
• Other platforms
• Certification process started
• Ramp Up Phase in Q1/Q2CY2004

17
BRTool News

• Major enhancement requirements
• Support for MCOD configurations
• Support for RAC configurations
• Automatic desaster recovery
• Support of new Oracle features (e.g. Online
  Redefinition)
• Introduction of uniform menu-driven user
  interfaces
• Graphical user interface
• Character user interface
• Better integration of BRBACKUP, BRARCHIVE and
  BRRESTORE during database recovery
• Improved Quality

18
BRTool Milestones

• 2002
• BRCONNECT Statistics, Check, etc.
• 04/2003
• BRRECOVER Recovery
• BRGUI Graphical User Interface
• Q3/2003
• BRSPACE Space Object Management

19
BRCONNECT

• Check and update statistics brconnect f stats
• Replaces sapdba checkopt analyze
  statistics delete
• Check database system brconnect f check
• Replaces sapdba check
• Adapt NEXT extents brconnect f next
• Replaces sapdba next
• Cleanup DBA logs brconnect f
  cleanup
• Replaces sapdba cleanup

20
BRRECOVER

• Design decisions
• Complete redesign of SAPDBA recovery
  functionality
• Integration in the BRTools package
• New menu-driven user interface, including
  graphical frontend
• Significant funtional enhancements
• Main Functions
• Complete database recovery
• Database point-in-time recovery
• NEW Tablespace point-in-time recovery (MCOD)
• Whole database reset
• Restore of individual backup files (Expert only)
• Restore and application of archivelog files
  (Expert only)
• NEW Disaster recovery

21
BRSPACE

• Space Management
• Extend tablespace
• Create tablespace
• Drop tablespace
• Alter tablespace
• Show tablespaces
• Alter database file
• Move database file
• Show database files
• Object Management
• Reorganize tables/indexes (online)
• Alter table/index
• Show tables/indexes

• Instance Management
• Startup/Shutdown database (single instance and
  RAC)
• Switch redolog file
• Toggle archivelog mode
• Show instance(s) status
• Alter/Show database parameters

Available in Q3-Q4 2003 for WEB AS 6.40
22
BRGUI Screenshots
23
(No Transcript)
24
(No Transcript)
25
Sources of Information

• BRCONNECT SAP note 403704
• BRRECOVER SAP note 602497
• BRSPACE SAP note 647697, 646681(Reorg)
• BRGUI SAP note 611493
• Technical documents
• http//service.sap.com/dbaora -gt Media Library -gt
  
• General -gt BRCONNECT
• Backup and Recovery -gt Restore and Recovery
• Space Management -gt BRSPACE (in development)

26
Outlook

• WEB AS 6.40 and beyond
• All SAPDBA functions moved to BRTools
• BRTools 6.40 package replaces SAPDBA completely
  (no SAPDBA shipment planned)
• SAPDBA will be maintained for older releases but
  not developed any more

27
Reminder please complete the OracleWorld
online session surveyThank you.
28
A
29
(No Transcript)