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
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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: