We have to set the following environment variable on the Oracle database server to function SAP system properly.

1. ORACLE_SID – ORACLE_SID is the system ID of the database instance. It is also denoted as DBSID.
2. ORACLE_HOME – ORACLE_HOME is the directory which consists of all the files of Oracle software. This directory consists of 3 sub directories they are…bin, database and network
3. SAPDATA_HOME – SAPDATA_HOME is the folder which consists of all the data files of the SAP system

The location of the control files and offline redo log files is configured in the oracle profile init<DBSID> and the location of the data files and online redo logs are stored in the database itself. The following figure shows that how i have configured environment variables on my Database server on which my SAP ECC 6.0 EHP4 system rely on.

Environment Variables of Oracle Database Server

This entry was posted on February 16, 2012 at 4:32 PM. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Posted in SAP Basis Notes by Raj No Comments Yet