Friday, May 14, 2021
dbametrix
More
    HomeOracle InternalsUndocumented 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.

    - Advertisement -
    dbametrix

    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

    - Advertisement -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    Recent Comments