Show TOC

Database Administration for OracleLocate this document in the navigation structure


You need to perform various tasks to administer your Oracle database in an SAP environment.

Getting Started

If you are new to the Oracle database, see Getting Started with Oracle and the SAP System.

For information on the concepts behind Oracle database administration (DBA), see Approach to Oracle DBA.


You can use the following SAP tools for Oracle DBA:

Tasks on Demand

The table below shows tasks that you need to perform when required:


If you see a space management alert (see below in Periodic Tasks), indicating that your tablespaces are running out of space, you perform space management to correct the problem.



More Information

Database start or stop

Instance Management with BR*Tools

Instance Management

Database failure with data loss

Restore and Recovery with BR*Tools

Restore and Recovery

Tablespace or data file management

Space Management with BR*Tools

Space Management

Table or index management

Segment Management with BR*Tools

Segment Management

Performance problem

Maintain Database Parameters


New database version

Database upgrade

Start of the navigation path Next navigation step Other Documentation Next navigation step Database Upgrades Next navigation step Oracle End of the navigation path

System copy required

Database copy

Start of the navigation path Next navigation step SAP NetWeaver Next navigation step SAP NetWeaver <Product> 7.1 Next navigation step Installation End of the navigation path

Periodic Tasks

The table below shows tasks that you need to perform periodically:


Whenever possible, use the DBA Planning Calendar for these tasks.

You can choose from a range of predefined action patterns that include the tasks listed here.


The following problems are the most common in an Oracle environment:

More Information