Definition
Environment variables define parameter values used by the Oracle database and SAPDBA. This section describes the variables used when the operating system is UNIX.
Use
The database uses the parameter values for many different purposes. SAPDBA also uses the parameter values.
Structure
The following variables are required:
System ID of the database instance
Example:
C11SAPSID
or sapsid refers to the 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.Home directory of the Oracle software.
Standard:
/oracle/<DBSID>Directory of the database files.
Standard:
/oracle/<DBSID>
The variables
The following environment variables must only be set if the corresponding paths deviate from the defaults specified here:
Directory for the BRARCHIVE logs.
Default value:
$SAPDATA_HOME/saparchDirectory for the BRBACKUP logs.
Default value:
$SAPDATA_HOME/sapbackupDirectory for the
sapdba -check/-analyze/-statistics logs.Default value:
$SAPDATA_HOME/sapcheckDirectory for all other SAPDBA logs, as well as shell and SQL scripts. It is also the standard directory for export dump files, if the parameter
Default value:
$SAPDATA_HOME/sapreorgDirectory for Oracle trace files and the alert file.
Default value:
$SAPDATA_HOME/saptraceDirectory of the database data files.
Default value:
$SAPDATA_HOME/sapdata1(The same for
SAPDATA<n>, n=1,...99).The environment variables
SAPDATA<n> must only be defined if directories are used that differ from the default.Identification of a remote database system.
This environment variable must be left unset.
Other environment variables that can be set:
Definition of the screen height.
Recommended height: ³ 24 lines.
Definition of the screen width.
Recommended width: ³ 80 columns
Setting the trace function for error analysis.
See Note 29324 for setting options.
See also:
Environment Variables (Windows NT)