Undocumented Oracle Utility-dbhome

December 16, 2010 | By

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.

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

Be Sociable, Share!

Tags: , , , , , , , , , ,

Category: blog, blogging, database services, oracle 10g dba, oracle 11g dba, oracle 9i dba, oracle dba, oracle utilities, software, technology

Comments are closed.