Environment Variables (Windows) - Oracle and BR tools

Environment variables define parameter values used by the Oracle database and BR*Tools. 

The following variables are required:

·        ORACLE_SID

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.

·        ORACLE_HOME

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.

·        SAPDATA_HOME

Directory of the database files.

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

Example: E:\oracle\C11

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:

·        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 BRCONNECT logs.

Default value: %SAPDATA_HOME%\sapcheck

·        SAPTRACE

Directory for Oracle trace files and the alert file.

Default value: %SAPDATA_HOME%\saptrace

·        SAPDATA1

Directory of the database data files.

Default value: %SAPDATA_HOME%\sapdata1

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

You can distribute the SAPDATAdirectories 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.

For example: SAPDATA1= F:\data\prod\sapdata1.

Other environment variables that you can set for BR*Tools:

·        BR_LINES

Definition of the number of lines in list menus.

Recommended height: ³ 20 lines.

For more information, see Configuring the Scroll Line Count for BR*Tools.

·        BR_LANG

Definition of the message language:

¡        E: English

¡        D: German

·        BR_TRACE

Setting the trace function for error analysis.

See also:

Environment Variables (UNIX)

Source: http://help.sap.com/saphelp_nw04/helpdata/en/e7/4fb2a8ee10294dbb23378a23e84e46/content.htm