About Me Contact Me Oracle12cSIG(IOUG)
Home  :: Finding database home information in database

Finding database home information in database


I was wondering how to find oracle home information inside database. I found an interesting view dba_directories. It stores information about Oracle home, Oracle base and many more directories. Check this below query.

SQL> select banner from v$version;

Oracle Database 12c Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE Production
TNS for Linux: Version - Production
NLSRTL Version - Production

SQL> column DIRECTORY_NAME format a40
SQL> column DIRECTORY_PATH format a150
SQL> set linesize 200
SQL> select DIRECTORY_NAME,DIRECTORY_PATH from dba_directories;

---------------------------------------- ---------------------------------------------------------
XMLDIR                       /u01/app/oracle/product/12.2.0/dbhome_prod/rdbms/xml
XSDDIR                        /u01/app/oracle/product/12.2.0/dbhome_prod/rdbms/xml/schema
ORA_DBMS_FCP_LOGDIR    /u01/app/oracle/product/12.2.0/dbhome_prod/cfgtoollogs
ORA_DBMS_FCP_ADMINDIR    /u01/app/oracle/product/12.2.0/dbhome_prod/rdbms/admin
OPATCH_INST_DIR   /u01/app/oracle/product/12.2.0/dbhome_prod/OPatch
ORACLE_OCM_CONFIG_DIR    /u01/app/oracle/product/12.2.0/dbhome_prod/ccr/state
DATA_PUMP_DIR      /u01/app/oracle/admin/CDB2017/dpdump/
ORACLE_OCM_CONFIG_DIR2    /u01/app/oracle/product/12.2.0/dbhome_prod/ccr/state
OPATCH_SCRIPT_DIR    /u01/app/oracle/product/12.2.0/dbhome_prod/QOpatch
OPATCH_LOG_DIR     /u01/app/oracle/product/12.2.0/dbhome_prod/rdbms/log
ORACLE_BASE          /u01/app/oracle
ORACLE_HOME     /u01/app/oracle/product/12.2.0/dbhome_prod   


Posted on : by Anuj
No comment found.

Add Your Comments
Name :
Email :
Comments :


  Recent Posts

Open world 2018 is on the corner! Are you attending?
Posted on :   9/7/2018

Step by Step Oracle Database 18c Installation on Oracle Linux 6
Posted on :   9/4/2018

APACOUC Session - Oracle 12cR1 was great Oracle 12c R2 is awesome! by Anuj Mohan
Posted on :   9/4/2018

  Recent Comments

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved 2013 Oracle-12c