ORACLE HOME
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
ORACLE_HOME refers to either:
- a directory where the Oracle software is installed; or
- 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
