Currently Being Moderated

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.

 

Getting Started

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

 

 

 

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

BR*Tools

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 BRTOOLS in the latest SAP Support Package - see the link on the right of this page.

 

 

More Information

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.

 

Oracle logMiner

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.


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.

 

SAP Systems with External Oracle Databases

This presentation from the 2011 German Oracle Users Conference (DOAG) discusses SAP workload management for the Oracle database.

Delete Document

Are you sure you want to delete this document?

Actions