Home

About Me Contact Me Oracle12cSIG(IOUG)
 
Home  :: Quick Tips

Finding database home information in database

0 Comments


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;

BANNER
--------------------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
PL/SQL Release 12.2.0.1.0 - Production
CORE 12.2.0.1.0 Production
TNS for Linux: Version 12.2.0.1.0 - Production
NLSRTL Version 12.2.0.1.0 - 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;

DIRECTORY_NAME     DIRECTORY_PATH
---------------------------------------- ---------------------------------------------------------
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   

Enjoy...



Posted on : 10/10/2017 by Anuj
 
Comments
No comment found.
 


Add Your Comments
 
Name :
Email :
Comments :

 

 
 
  Archives
 
  Recent Posts

Finding database home information in database
Posted on :   10/10/2017

Beginner to Exadata?
Posted on :   8/31/2017

IOUG Collaborate 17
Posted on :   3/25/2017

  Recent Comments
 

Home  |  About Me  |  Contact  |  Oracle12cSIG(IOUG)

All Rights Reserved 2013 Oracle-12c