Environment Variables (Windows NT) (SAP Library - Database Administration (Oracle) with SAPDBA)

Environment Variables (Windows NT)

ORACLE_SID : System ID of the database instance

Example: C11

SAPSID or sapsid refers to the name of the R/3 System (SAP System ID).

DBSID or dbsid refers to the name of the database instance (database instance system ID).

When a single instance is installed, SAPSID and DBSID are the same.

ORACLE_HOME : HOME directory of the Oracle software.

Standard:<drive>: \orant

Example: D:\orant

SAPDATA_HOME : Directory of the database files.

Standard: <drive>:\ oracle\<DBSID>

Example: E:\oracle\C11

The variables ORACLE_SID , ORACLE_HOME and SAPDATA_HOME must always be set during installation. There is no default.

The following environment variables must only be set if the corresponding paths deviate from the defaults specified here:

SAPARCH: Directory for the BRARCHIVE logs.

Default value: %SAPDATA_HOME%\saparch

SAPBACKUP : Directory for the BRBACKUP logs.

Default value: %SAPDATA_HOME%\sapbackup

SAPCHECK: Directory for the sapdba -check/analyze logs.

Default value: %SAPDATA_HOME%\sapcheck

SAPREORG: Directory for all other SAPDBA logs, as well as shell and SQL scripts. It is also the standard directory for export and unload dump files, if the parameter exireo_dumpdir in the profile init<DBSID>.dba is not set.

Default value: %SAPDATA_HOME%\sapreorg

SAPTRACE: Directory for Oracle trace files and the alert file.

Default value: %SAPDATA_HOME%\saptrace

SAPDATA1: Directory of the DB data files.

Default value: %SAPDATA_HOME%\sapdata1

(Analog for SAPDATA<n>, n=1,...99).

Note: You can distribute the SAPDATA directories across several different drives, without defining the environment variables SAPDATA<n>. The environment variables only have to be defined individually if directories are used that deviate from the default. The drive is automatically recognized by SAPDBA.
(Example: SAPDATA1= F:\data\prod\sapdata1) .

Other environment variables that can be set:

LINES : Definition of the screen height.

Recommended height: ³ 24 lines.

COLUMNS : Definition of the screen width.

Recommended width: ³ 80 columns

SAPDBA_DEBUG : Setting the trace function for error analysis.

See Note 29324 for setting options.