Wednesday, October 28, 2020
    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 -

    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 -

    Command of dbhome:

    dbhome [SID]

    Example of dbhome:

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


    $dbhome                               (This command provides current oracle home)


    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


    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 -
    - Advertisment -

    Most Popular

    Identifying important information in Big Data

    The way in which Big Data technologies have evolved in the real word enterprise goes on to show that even technologists and scientists who might have disparaged the word (Big Data) previously

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    oracle 19c new features – Automatic Indexing

    A major Oracle 19c autonomous database new Feature automatic indexing using DBMS_AUTO_INDEX some details and how to article.

    Recent Comments