Entering content frameObject documentation Environment Variables (Windows NT) Locate the document in its SAP Library structure

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: C11

SAPSID 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>:\orant

Example: D:\orant

This variable is optional with Oracle version 8.1 and later.

Directory of the database files.

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

Example: E:\oracle\C11

Note

The 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%\saparch

Directory for the BRBACKUP logs.

Default value: %SAPDATA_HOME%\sapbackup

Directory for the BRCONNECT logs.

Default value: %SAPDATA_HOME%\sapcheck

Directory 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%\sapreorg

Directory for Oracle trace files and the alert file.

Default value: %SAPDATA_HOME%\saptrace

Directory of the database data files.

Default value: %SAPDATA_HOME%\sapdata1

(The same 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.

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)

Leaving content frame