How to find ORACLE_HOME in Windows directory?

Step 1:- Go to Command promt and connect as sysdba using sqlplus.
sqlplus / as sysdba

Step 2:- There is a stored procedure to get the Oracle home from the database server.
SQL > var home varchar2(100);
SQL > EXEC dbms_system.get_env('ORACLE_HOME', :home ) ;
SQL > PRINT home 
Output should be as below.

image

Thank You !!!
How to find ORACLE_HOME in Windows directory? How to find ORACLE_HOME in Windows directory? Reviewed by Pubudu Dewagama on 9:53:00 PM Rating: 5

No comments: