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 -> 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

StackExchange Database Administrators Q#140568, answer score: 23