Definition
Environment variables define parameter values used by the Oracle database and SAPDBA. This section describes the variables used when the operating system is Windows NT.
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. This variable no longer needs to be set. If not set, the SAP tools determine its value from the registry.
Standard:
<drive>:\orantExample:
D:\orantThis variable is optional with Oracle version 8.1 and later.
Directory of the database files.
Standard:
<drive>:\oracle\<DBSID>Example:
E:\oracle\C11The variables
ORACLE_SID and SAPDATA_HOME must always be set. There is no default.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 BRCONNECT logs.
Default value:
%SAPDATA_HOME%\sapcheckDirectory for SAPDBA logs, as well as shell and SQL scripts. It is also the standard directory for export dump files, if the parameter
exireo_dumpdir in the profile init<DBSID>.dba is not set.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 ).You can distribute the
For example:
SAPDATA1= F:\data\prod\sapdata1 .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
See also:
Environment Variables (UNIX)