Oracle environment variables

 

 

Oracle_base: Specifies the top-level directory of Oracle software.

Example:/u01/APP/Oracle

ORACLE_HOME: Specifies the installation directory of Oracle software.

The recommended directory for ofa is $ oracle_base/product/release.

Example:/u01/APP/Oracle/product/10.2.0

Oracle_sid: Specifies the routine name. The name of the Oracle routine running on the same computer must be unique.

Ora_nls33: required when creating a database with a non-us7ascii character set.

Example: $ ORACLE_HOME/ocommon/NLS/admin/Data

Path: Specifies the executable search for the operating systemProgram(Such as SQL * Plus.

The Oracle10g executable program is located in the $ ORACLE_HOME/bin directory and needs to be added to the PATH variable.

.

LD_LIBRARY_PATH: Specifies the directory where the operating system and Oracle database files are located.

Example: $ ORACLE_HOME/lib