Where is my ORACLE_HOME Windows directory?
Open up a command prompt
Start -> Run -> "cmd.exe"
Start sqlplus as administrator
sqlplus / as sysdba
There's a system stored procedure called get_env
for retrieving the value for ORACLE_HOME
, thanks Sabdar Syed for the query.
SQL > var OHM varchar2(100);
SQL > EXEC dbms_system.get_env('ORACLE_HOME', :OHM) ;
SQL > PRINT OHM
Should return a path like this:
C:\app\oracle_account\product\12.1.0\dbhome_1
On Windows platform you can find oracle_home path in the registry.
Run regedit, then navigate to:
hkey local machine/software/oracle
Under oracle folder in the registry you will find something like:
KEY_OraDb10g_home1
There you can see oracle_home variable.