Use the resources on this topic page to get started in your role as database administrator for an Oracle database hosting an SAP application.
SAP Database Administration for Oracle
For a short introduction to SAP database administration for Oracle, check out this white paper.
SAP Database Guide: Oracle (in the SAP help portal)
This is the full Oracle Database Administration Guide for SAP NetWeaver 7.1 as HTML.
SAP Database Guide: Oracle
This is the full Oracle Database Administration Guide for SAP NetWeaver 7.1 as PDF (756 pages).
SAP Tools for Oracle Database Administration
We provide you with BR*Tools, including BRSPACE and BRCONNECT, to help you administer your Oracle database:
- 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 BRGUI and BRTOOLS in the latest SAP Support Package - see the link on the right of this page. For more on information on BRGUI, see here.
BR*Tools - SAP's recommended solution for administering the Oracle database for your SAP system - has now been extended with a browser-based GUI. But BR*Tools Studio is way more than just another GUI. Reconnectable client-server architecture, role-based multi-user environment, job scheduling, and favorite tasks add up to a powerful combo that enables DB admins to go the extra mile in their daily work.
You can download BR*Tools Studio and read our white paper.
DBA Cockpit for Oracle
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.
BR* Tools Patches and Extensions
This is a full list of the patches and extensions for BR*Tools, version 7.00. You can find a detailed list of recent changes to BR*Tools BR*Tools Extensions.
Oracle Database Monitors and Tools
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.
High Availability SAP Customers only
This Oracle whitepaper discusses using Oracle Clusterware to provide high availability for SAP resources such as the SAP Enqueue Service.
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.
Monitoring of Remote Oracle Databases with RZ20
This presentation shows how you can remotely monitor Oracle databases with transaction RZ20
Configuration of the SAP-Oracle Database Interface
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.
BRSPACE Online Reorganizations: Advanced Reorganisations
This presentation focuses on the BRSPACE online reorganization of tables, which also includes tablespace reorganizations.
BRSPACE Online Reorganizations: Top Ten Pitfalls and Problems
This presentation focuses on the major issues found with BRSPACE online reorganizations and how to avoid them.
Partitioning for SAP ERP: A Guide for planning and setting up Oracle
This paper describes and explains the partitioning methods used for SAP ERP systems. The fundamental partitioning techniques are presented as is the concept of partitioning used within the SAP ERP system. It is a conceptual guideline for customers interested in using Oracle partitioning in SAP ERP systems.
SAP Systems with External Oracle Databases
This presentation from the 2011 German Oracle Users Conference (DOAG) discusses SAP workload management for the Oracle database.