Where can I find my oracle home windows directory?

400 Asked by ranjan_6399 in SQL Server , Asked on Feb 7, 2023

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

Answered by Ranjana Admin

To find your 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', HM) ;

SQL > PRINT OHM

Should return a path like this:

C:pporacle_accountproduct

.1.0dbhome_1

Where can I find my oracle home windows directory?

Your Answer