SAP on Oracle - DBA Overview
Use the resources on this topic page to get started in your role as database administrator for an Oracle database hosting an SAP application.
New User Concept
This presentation describes the new user concept for SAP NetWeaver-based installations with Oracle on Unix.
This is the full Oracle Database Administration Guide for SAP NetWeaver as HTML.
This is the full Oracle Database Administration Guide for SAP NetWeaver as PDF (21 MB).
SAP Tools for Oracle Database Administration
- As of SAP Web AS 6.40, SAPDBA is no longer being released.
- You can continue to use SAPDBA 6.20 linked to Oracle 9i with SAP Web AS 6.40. However, we strongly recommend you to only use BR*Tools instead.
- You cannot use SAPDBA with Oracle 10g or higher.
- BR*Tools 6.40, including BRSPACE, can be used for all SAP Releases based on Oracle 9i.
- BR*Tools 7.00, including BRSPACE, can be used for all SAP Releases based on Oracle 10g
You can use these SAP tools for Oracle database administration both in daily routine tasks and in less frequent, complex tasks, such as recovering or reorganizing the database. You can configure and execute functions individually.
BR*Tools also offer certified interface solutions for external backup tools using BACKINT and integrate the latest in database technology, including standby databases and split-mirroring.
You can download BRTOOLS in the latest SAP Support Package - see the link on the right of this page.
You can use the DBA Cockpit to administer your Oracle database. Particularly suited to Oracle 10g and RAC-compatible, you can use DBA Cockpit to monitor database performance and space usage, as well as to run the DBA Planning Calendar and check DBA and backup logs. DBA Cockpit is packed with functionality that was previously scattered in different transactions. You can find an extract from the SAP Library covering DBA Cockpit for Oracle here.
To help you quickly recognize and analyze Oracle database problems, SAP provides comprehensive and fully integrated database system checking. By running regular checks and looking at the results, you can rapidly identify potential problems and take the required action before the database crashes. This SAP whitepaper explains how.
With this article from the Oracle German Users Conference (DOAG), you can see how to use logMiner for Oracle 10g to analyze redo logs. Two in-depth real-life case studies are presented to illustrate the ideas.
This presentation summarizes the ways in which you can tune certain default values in the SAP-Oracle database interface (database shared library, DBSL). We also look at how this affects the ongoing operation of the SAP system. The presentation is tailored to the SAP kernel as of Version 7.10, although most details are valid for all currently supported SAP releases.
This presentation focuses on the major issues found with BRSPACE online reorganizations and how to avoid them.
This presentation from the 2011 German Oracle Users Conference (DOAG) discusses SAP workload management for the Oracle database.
This presentation from the 2011 German Oracle Users Conference (DOAG) discusses BR*Tools support for Oracle 11g Automatic Storage Management (ASM) and Real Application Clusters (RAC),.