ORACLE HOME

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.

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

On Windows the ORACLE_HOME may also be stored in the registry:

• HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
• HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID
• HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES
• HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services

Unix & Linux

Check current value:

env | grep ORACLE_HOME
# or
dbhome

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

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

Get the value of ORACLE_HOME for a specific instance:

 dbhome <SID>

Note: dbhome returns result from oratab file.

Also see

• oraenv - utility to change ORACLE_HOME
• oratab
• ORACLE_SID
• ORACLE_BASE

External links

• Free replacement for the Windows Oracle Home Selector utility