ORACLE_HOME

 

Specifies the directory, where your Oracle® product is installed.

 

Syntax:

 

ORACLE_HOME=<path>

 

Usage:

 

The ORACLE_HOME environment variable specifies the directory, where your Oracle product is installed.

 

To be able to connect to Oracle database, ORACLE_HOME should always be set. Refer to Setting up Oracle Connection for more details on how to use ORACLE_HOME.

 

ORACLE_HOME applies at runtime (inet.env) and at compilation (env.properties). You can set ORACLE_HOME in system environment variables but it is not recommended unless you have experience in such modifications.

 

Example:

 

Sets the following path for ORACLE_HOME on Windows:

 

ORACLE_HOME=C:\ORACLE\instantclient_ver._No

 

 

Related articles:

DBTEMP

Lycia configuration

ORACLE_SID

QXTRANS

Setting up Oracle connection

TNSADMIN