ORACLE HOME

From Oracle FAQ

ORACLE_HOME refers to either:

1. a directory where the Oracle software is installed; or
2. an environment variable pointing to the directory where the Oracle software is installed.

Contents 1 Windows 2 Unix & Linux 3 Also see 4 External links

[edit] Windows

Check current value:

echo The current ORACLE_HOME is %ORACLE_HOME%

Set the ORACLE_HOME environment variable:

set ORACLE_HOME=C:\oracle\ora10.2

[edit] Unix & Linux

Check current value:

env | grep ORACLE_HOME

Change the ORACLE_HOME environment variable (valid for bash and ksh):

export ORACLE_HOME=/app/oracle/product/10.2.0/db_1

[edit] Also see

• oraenv - utility to change ORACLE_HOME
• ORACLE_SID
• ORACLE_BASE

[edit] External links

• Free replacement for the Windows Oracle Home Selector utility