Where is my ORACLE_HOME Windows directory?

Question

I'm trying to find my listener.ora file to edit it, but the docs say it's in the ORACLE_HOME directory, but where is that?

I'm running 12.1.0 on Windows Server 2008

Answer 1

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

Answer 2

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.

Answer 3

On cmd, type echo %ORACLE_HOME%. If ORACLE_HOME is set it will return you the path or else it will return %ORACLE_HOME%.

Answer 4

• Start 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.