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.

Tags:

Windows

Oracle