Wednesday, August 5, 2020
dbametrix
More
    Home Oracle Internals Undocumented Oracle Utility-dbhome

    Undocumented Oracle Utility-dbhome

    Hi Friends,

    Today we are going to discuss one another undocumented Oracle utility called DBHOME. Yes I think you understood usage of utility as per it’s name.

    - Advertisement -
    dbametrix

    Usage of dbhome:

    For checking $ORACLE_HOME environment variable. This utility is very useful for getting location of Oracle home. We can use dbhome utility instead of “echo” command of Unix and Linux.

    But it is very useful for checking location of another ORACLE_HOME in same server because “echo” command provides only value of current environment variable of Oracle home.

    Kindly note that, dbhome utility doesn’t available on Windows platforms.

    Command of dbhome:

    dbhome [SID]

    Example of dbhome:

    $ dbhome gpt1                      (This command provides non-current oracle home)

    /oracle/apps/10g

    $dbhome                               (This command provides current oracle home)

    /oracle/apps/ora92

    Providing SID name is not mandatory because if we use only “dbhome” alone without SID then it returns current environment variable of oracle home location.

    dbhome is providing same output of echo oracle_home just as follows.

    $ echo $ORACLE_HOME

    /oracle/apps/10g/gpt1

    I think this article will be useful to you in your routine database administration work.

    For more Oracle DBA tips and Articles kindly check our site section called Oracle DBA Tips.

    All the best.

    Thanks and regards,

    Remote DBA Support

    0
    - Advertisment -
    dbametrix

    Most Popular

    The Life of DBAs is Changing

    Article explains how The Life of DBAs is Changing in Self-Managing Oracle Database. An detail introduction of Oracle Autonomous Database Cloud

    MySQL as PHP database

    The article illustrates the relationship between data and semantics of data stored in a database with reference to the semantic WEB

    Supply Chain Management in ERP

    The article provides detail of what is supply chain management system and what is the importance.

    Business Intelligence Market

    The blog explains how business intelligence is growing in Global market and what is the future of BI.

    Recent Comments