Where is my ORACLE_HOME Windows directory? 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
Open up a command prompt

Start -&gt; Run -&gt; "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 &gt; var OHM varchar2(100);
SQL &gt; EXEC dbms_system.get_env('ORACLE_HOME', :OHM) ;
SQL &gt; PRINT OHM


Should return a path like this:


  C:\app\oracle_account\product\12.1.0\dbhome_1