1 / 29

Oracle and SAP Development Update

Session id: 40041. Oracle and SAP Development Update. Dr. Christian Graf Jan Klokkers Development Manager Senior Director DB Platforms Oracle SAP Development SAP AG Oracle Corporation. Topics. Introduction

colby
Download Presentation

Oracle and SAP Development Update

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Session id: 40041 Oracle and SAP Development Update Dr. Christian Graf Jan Klokkers Development Manager Senior Director DB Platforms Oracle SAP Development SAP AG Oracle Corporation

  2. Topics • Introduction • SAP Technical Product Architecture • SAP Platform Support • SAP-Oracle Certification Matrix • SAP-Oracle Release Strategy • SAP-Oracle Product Integration • SAP BR*News

  3. 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

  4. Enterprise Portal SRM/CRM KM BW APO R/3 Enterprise ... Java Apps ABAP Java Web Application Server (WAS) ABAP Stack J2EE Java Stack thin JDBC ... ... thin JDBC Oracle Call Interface SAP Technical Product Architecture Oracle Database

  5. 32 Bit 64 Bit 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

  6. 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

  7. Oracle Desupport Oracle SAP on Oracle Certification Matrix 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 SAP

  8. 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

  9. “SAP will support Oracle 10g, the safe, reliable and scalable clustered database.” Karl-Heinz Hess, Member of the Extended Management Board, SAP AG

  10. 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)

  11. 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 Oracle Functionality in SAP Products (Part II)

  12. Oracle 9.2 Feature Integration SAP OSS note 598678: Entry point for 9i feature recommendations!

  13. Current status in OSS Note 527843 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

  14. 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

  15. 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

  16. BR*Tool 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

  17. BR*Tool Milestones • 2002 • BRCONNECT: Statistics, Check, etc. • 04/2003 • BRRECOVER: Recovery • BRGUI: Graphical User Interface • Q3/2003 • BRSPACE: Space & Object Management

  18. 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

  19. BRRECOVER • Design decisions • Complete redesign of SAPDBA recovery functionality • Integration in the BR*Tools 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

  20. BRSPACE • Instance Management • Startup/Shutdown database (single instance and RAC) • Switch redolog file • Toggle archivelog mode • Show instance(s) status • Alter/Show database parameters • 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 Available in Q3-Q4 2003 for WEB AS 6.40

  21. BRGUI – Screenshots

  22. 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 -> Media Library -> • General -> BRCONNECT • Backup and Recovery -> Restore and Recovery • Space Management -> BRSPACE (in development)

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

  24. Reminder – please complete the OracleWorld online session surveyThank you.

  25. Q & Q U E S T I O N S A N S W E R S A

More Related