Oracle Utilities Pocket Reference

Get full access to Oracle Utilities Pocket Reference and 60K+ other titles, with a free 10-day trial of O'Reilly.

There are also live events, courses curated by job role, and more.

Name

dbhome

Use dbhome to get the Oracle Home directory for the given Oracle SID. dbhome reads the value of ORACLE_HOME from the oratab file.

Tip

dbhome is not available on Windows platforms.

Syntax

dbhome [SID]

Parameters

SID: Name of the Oracle SID. The parameter is optional. If not specified, the Oracle Home directory corresponding to the current setting of the ORACLE_SID environment variable is returned.

Examples

The following examples illustrate how to use dbhome with and without the optional parameter.

$ echo $ORACLE_SID
TEST9I
$ dbhome
/u01/app/oracle/product/9.2.0
$ dbhome TEST10G1
/u01/app/oracle/product/10.1.0

Get Oracle Utilities Pocket Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Don’t leave empty-handed

Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.

It’s yours, free.

Get it now

Check it out now on O’Reilly

Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.

Start your free trial Become a member now