ORACLE HOME

From Oracle FAQ
Jump to: navigation, search

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[edit]

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[edit]

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[edit]

External links[edit]