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_envfor 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:
regedit(search for it from the Start menu)
- Open the HKEY_LOCAL_MACHINE folder
- Open the Oracle folder
- Open a folder called ORACLEMTSR
- Open the setup folder
- Access to the current version
There you will find a "file" called HOME; open it and you will see where Oracle was installed.
At a guess, you've left out `SOFTWARE` under `HKEY_LOCAL_MACHINE` (on my machine, the items under `HKEY_LOCAL_MACHINE` are all generic, and there's only 6 of them - I'd expect Oracle's registry entry to be in `SOFTWARE`). Also, I suspect that `ORACLEMTSR` might actually be `ORACLEMSTR` (though I'm not sure, as I don't have an Oracle install handy to check). Could you double-check, to make sure the answer is in fact complete and correct?