Find ORACLE_HOME on any O/S

Struggling to find the ORACLE_HOME for your system?

This works on any Oracle Database version from 9i onwards as long as you can get into the system in the first place!

SQL > var oraclehome varchar2(100);
SQL > EXEC dbms_system.get_env('ORACLE_HOME', :oraclehome) ;
SQL > PRINT oraclehome

Leave a Reply