oracle integration at sap
TRANSCRIPT
Oracle Integrationat SAP
Dr. Christian Graf, Development Manager, SAP AG DB Platforms Oracle & Informix
Jan Klokkers, Director SAP Development, Oracle Corporation
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 2
Topics
Introduction
SAP Product strategy
SAP Release strategy
Oracle Release Integration at SAP
MCOD
SAPDBA/BRCONNECT 6.10
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 3
Introduction
More than 12 years SAP – Oracle collaboration
More than 30000 SAP installations on Oracle
Approx. 24000 customer installations on Oracle
Joint SAP & Oracle development (platform) team in Walldorf
Support teams in Rot (Germany) & USA
SAP & Oracle Partner & Presales Teams in Walldorf
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 4
Topics
Introduction
SAP Product strategy
SAP Release strategy
Oracle Release Integration at SAP
MCOD
SAPDBA/BRCONNECT 6.10
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 5
SAP Product Strategy
Until 1996/1997 it had been mainly SAP R/3!
Now it is: mySAP R/3 Core Application
mySAP BW Business Warehouse
mySAP APO Advanced Planner & Optimizer
mySAP EBP/CRM Business to Business Proc. & Customer Relationship Management
mySAP KM Knowledge Warehouse
my SAP Workplace
....
SAPMarkets Market Places
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 6
SAP Product Strategy
Workplace
KM BW
EBP/CRM
APO SAP R/3
Web Application Server (WAS)
Database (Oracle, DB2, Informix, MSS, SAPDB)
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 7
SAP Product Strategy
Currently supported releases: 3.1I, 4.0B, 4.5B, 4.6x, 6.x
Since SAP R/3 Release 4.6x:
WEB Application Server (WAS), formerly R/3 Basis, is now a separateproduct/component:
Serves as infrastructure component for SAP applications Load balancing/dispatching
Covers platform dependencies
ABAP workbench, batch, spool, monitoring, security, ...
Provides common features required by the SAP product family
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 8
Upcoming: SAP R/3 Enterprise
Add On
SAP R/3 Enterprise Core
Web Application Server (WAS)
Database (Oracle, DB2, Informix, MSS, SAPDB)
Add On
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 9
Topics
Introduction
mySAP Product strategy
mySAP Release strategy
Oracle Release Integration at SAP
MCOD
SAPDBA/BRCONNECT 6.10
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 10
SAP Release Strategy
31I 8/2003
40B 8/2003
45B (1.2B) 8/2003
WAS 4.6C/D Kernel 2.0B/2.1C 3/2005
WAS 6.10 3.0A 8/2002
WAS 6.20 3.0B 12/2005
SAP releases/maintenance schedule
Kernel/WASVersion
Supportuntil
BW
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 11
SAP Release Strategy
AIX: (4.3) X X
HP-UX: (11/11I) X X
DEC True 64: (5.1) --- X
Reliant Unix: (5.45B) X X
Solaris: (8.0) X X
Linux (>=40B): (Glibc2.2.2) X ---
WIN: (4.0/W2K) X ---
SAP OS platform coverage: 31I – 46C
32 Bit 64 Bit
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 12
SAP Release Strategy
AIX: (5.1) --- X
HP-UX: (11/11I) --- X
DEC Tru 64: (5.1) --- X
Reliant Unix: (5.45B) --- X
Solaris: (8.0) --- X
Linux: (Glibc2.2.2) X ---
WIN: (4.0/W2K) X X (GA: 6.20)
SAP OS platform coverage: WAS 6.10/6.20
32 Bit 64 Bit
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 13
SAP Release Strategy
SAP Kernel Release Note Number
31I 23875
40x/45x 85838
46x 156548
610 407314
SAP Service Marketplace
http://www.service.sap.com/platforms
SAP OS platform coverage: General info
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 14
Topics
Introduction
mySAP Product strategy
mySAP Release strategy
Oracle Release Integration at SAP
MCOD
SAPDBA/BRCONNECT 6.10
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 15
Oracle Integration
31I 8.1.7 9/2003
40B 8.1.7 9/2003
45B 8.1.7 9/2003
WAS 4.6C 8.1.7 9/2003
WAS 6.10 8.1.7 9/2003
WAS 6.20 planned 9.0.1/9.0.2? 12/2002|6/2004
SAP certified Oracle versions for 31I – WAS 6.20
SAP Oracle OracleSupport
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 16
Oracle Integration
Based on WAS 6.20:
SAP R/3 Enterprise
BW 30B
Start QA Process: GA:
WAS 6.20: Early February/2002 March/2002
BW 30B: March/2002 May /2002
SAP R/3 Enterprise: May/2002 July/2002
Schedule for upcoming mySAP products:
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 17
Oracle feature integration
Bitmap Tablespaces (available with 8.1) Default with WAS 6.x. Recommended for BW 2.x General recommendation for SAP environment in preparation Details see OSS Note: 387946 For tablespace reorganization, Bitmap Tbls is recommended/default
Index rebuild online (Oracle 8.1 required) Sapdba 6.10
Evaluation (9i) Online Table Reorg Undo Tablespaces Automatic PGA Memory Management Bitmap Join Indexes (BW) Upsert (BW) Long to LOB migration Incremental Checkpoints CBO CPU costing
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 18
Topics
Introduction
mySAP Product strategy
mySAP Release strategy
Oracle Release Integration at SAP
MCOD (= Multiple Components One Database)
SAPDBA/BRCONNECT 6.10
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 19
Multiple SAP Systems on Single DB instance
Challenge 1:Currently different mySAP products run on separatedatabase instances!
A common recovery scenario (e.g. Point in Time) spanning several SAP systems is hard to realize!
Challenge 2:A system landscape with several mySAP products onseveral database servers can be hard to administrate.
Solution:Run different SAP components (e.g. R/3, CRM, etc.) inthe same database instance!
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 20
Multiple SAP Systems on Single Oracle Instance
DB Instance: oraclePRD
system
psapPRD
psapPRDusr
psapPRD<rel>
PRD
SAP R/3 PRD
SAP CRM CR1
/oracle/CR1/sapdata/<files>
/oracle/PRD/bin ... /lib /... /sapdata/<files>
Installation Template:Addsys.R3S
psapCR1
psapCR1usr
psapCR1<rel>
CR1
psaproll
psaptemp
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 21
Topics
Introduction
mySAP Product strategy
mySAP Release strategy
Oracle Release Integration at SAP
MCOD
SAPDBA/BRCONNECT 6.10
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 22
SAPDBA 6.x: NEWS
6.10Support of Table partitioning
Range, Hash & Composite partitions
Support of Index partitioning Range, Hash
Online Index reorganizationSince 8.1.7 with parallel option
Full support of locally managed tablespacesDefault for creation of new tablespaces (beside psaproll & system!)Option during tablespace reorganization
6.20Online table reorg (new 9i feature)LOB support
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 23
BRCONNECT 6.10: Motivation
Requiremets resulting from Multi Components in OneDatabase Project (MCOD, note 388866)
SAP<SID> users replace SAPR3 in database Multiple SAP<SID> schemas in single database DBA functions (statistics, check, next, ...) required for one,many or all schemas of a database
Requirements resulting from new functionality of Oracle8i
Support for Oracle 8i table monitoring feature Support for Oracle 8i DBMS_STATS package
Decision: Redesign of SAPDBA command line options,preserving menu-driven functions
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 24
BRCONNECT 6.10: Goals
Fulfillment of MCOD project requirementsSupport for new Oracle 8i featuresExtented functionality compared to SAPDBAIntegration into DBA Planing Calendar (DB13)Extented logging and tracing (BR tools like)Better support for parallel processingBetter qualityBetter serviceability
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 25
BRCONNECT 6.10: Main Functions
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
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 26
BRCONNECT 6.10: Additional Functions
Start up database: brconnect -f dbstart Replaces sapdba –startup
Shut down database: brconnect -f dbshut Replaces sapdba –shutdown
Check database state: brconnect -f dbstate replaces check_db_open
Change user password: brconnect -f chpass Replaces sapdba –sapr3 | –alter_user
Create DBA synonyms: brconnect -f crsyn This a new function
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 27
Stats: Parallel Update Statistics
With parallel threads, especially for large numbers oftables
Option –p|-parallel <thread_cnt> Parameter ‚stats_parallel_degree‘ = <thread_cnt>
With the DBMS_STATS package, especially for largetables
Use ‚stats_dbms_stats‘ parameter (patch level 7):init<SID>.sap: stats_dbms_stats = (<table>:R|B:<degree>,...)
Adaptions to BW requirements Special treatment of Infocube Tables (incl. histograms)
For details see notes 403713, 408532, 424239 & 428212
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 28
BRCONNECT 6.10: Check
Focus on quality
Functional enhancements Support of ‚autoextend‘ feature Enhancements for partitioning
Monitoring space requirements Adaptions of ‚next extent‘ size
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 29
BRCONNECT 6.10: Further info
OSS Notes As mentioned before
SAP Service Market Place
http://www.service.sap.com/DBAORA White paper
SAP AG 2001, Oracle integration at SAP, Dr. Christian Graf 30
No part of this presentation may be reproduced or transmitted in any form or for any purposewithout the express permission of SAP AG. The information contained herein may be changedwithout prior notice.Some software products marketed by SAP AG and its distributors contain proprietary softwarecomponents of other software vendors.Microsoft®, WINDOWS®, NT®, EXCEL®, Word® and SQL Server® are registered trademarks ofMicrosoft Corporation.IBM®, DB2®, OS/2®, DB2/6000®, Parallel Sysplex®, MVS/ESA®, RS/6000®, AIX®, S/390®, AS/400®,OS/390®, and OS/400® are registered trademarks of IBM Corporation.ORACLE® is a registered trademark of ORACLE Corporation, California, USA.INFORMIX®-OnLine for SAP is a registered trademark of Informix Software Incorporated.UNIX®, X/Open®, OSF/1®, and Motif® are registered trademarks of The Open Group.HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C®, World Wide WebConsortium, Laboratory for Computer Science NE43-358, Massachusetts Institute of Technology,545 Technology Square, Cambridge, MA 02139.JAVA® is a registered trademark of Sun Microsystems, Inc. , 901 San Antonio Road, Palo Alto, CA94303 USA.JAVASCRIPT® is a registered trademark of Sun Microsystems, Inc., used under license fortechnology invented and implemented by Netscape.SAP, SAP Logo, mySAP.com, mySAP.com Marketplace, mySAP.com Workplace, mySAP.comBusiness Scenarios, mySAP.com Application Hosting, WebFlow, R/2, R/3, RIVA, ABAP, SAPBusiness Workflow, SAP EarlyWatch, SAP ArchiveLink, BAPI, SAPPHIRE, Management Cockpit,SEM, are trademarks or registered trademarks of SAP AG in Germany and in several other countriesall over the world. All other products mentioned are trademarks or registered trademarks of theirrespective companies.
Copyright