Find Your Oracle Home (ORACLE_HOME)

ORACLE_HOME is the top-level directory of an Oracle client or database installation. Correctly identifying it is important for patching, configuration (tnsnames.ora, sqlnet.ora), and tooling. Below are reliable, version-neutral approaches. (Browser-based iSQL*Plus is discontinued.)

Quick Answers

• Linux/UNIX (per SID): use oraenv (sets ORACLE_HOME for a given ORACLE_SID), or the utilities orabase / orabasehome.
• Windows: query the Registry for the Oracle Home key, or inspect installed Homes via Oracle Inventory tools.
• Inventory/patching: opatch lsinventory shows Homes and patch levels from within a Home.

Linux/UNIX

1) Set environment from SID with oraenv

oraenv (usually /usr/local/bin/oraenv) sets ORACLE_HOME for a chosen database SID.

# choose the instance
export ORACLE_SID=orcl
. oraenv   # dot-space to source it; follow prompts
echo "$ORACLE_HOME"

2) Ask the utilities

Modern releases provide helpers inside the Home:

$ORACLE_HOME/bin/orabase
$ORACLE_HOME/bin/orabasehome

orabase prints ORACLE_BASE; orabasehome prints the current ORACLE_HOME.

3) From Oracle Inventory

Within a known Home, list inventory:

$ORACLE_HOME/OPatch/opatch lsinventory

4) Avoid database-side guesses

Views like V$DIAG_INFO tell you the ADR/trace paths (under ORACLE_BASE), not the ORACLE_HOME. Don’t infer ORACLE_HOME from ADR alone-it can be misleading.

Windows

1) Registry query

Homes are registered under HKLM\SOFTWARE\Oracle (and ...Wow6432Node... for 32-bit components):

reg query "HKLM\SOFTWARE\Oracle" /s | findstr /i "ORACLE_HOME KEY_"

Look for a KEY_<HomeName> entry and its ORACLE_HOME value.

2) Inventory tools

Inside a Home, run:

%ORACLE_HOME%\OPatch\opatch lsinventory

What lives under ORACLE_HOME (orientation)

• bin/ - executables (sqlplus, tnsping, dbca).
• network/admin/ - tnsnames.ora, listener.ora, sqlnet.ora.
• rdbms/ - database binaries and libraries.
• OPatch/ - patching utility and inventory.
• assistants/ - DBCA and other setup tools.

Common mistakes to avoid

• Using SET SERVERNAME in SQL*Plus: not a valid SQL*Plus connection command.
• Adding tokens like SHARED_SERVERS or WALLET_LOCATION=... to CONNECT: wallet/TCPS is configured in sqlnet.ora or Easy Connect Plus parameters, not as freeform connect options.
• Assuming ADR paths equal ORACLE_HOME: ADR reflects ORACLE_BASE layout; Homes can differ.

Examples

Easy Connect

sqlplus scott@//host.example.com:1521/orclpdb1

TNS alias

sqlplus scott@orcl

Start then connect

sqlplus /nolog
CONNECT scott@//host.example.com:1521/orclpdb1

Show the currently set Home (shell)

echo "$ORACLE_HOME"     # Linux/UNIX
echo %ORACLE_HOME%      # Windows

Summary: On Linux/UNIX, prefer oraenv and the orabase/orabasehome helpers; on Windows, query the Registry or run Inventory tools. Use opatch lsinventory inside a Home for authoritative details.

Title: Locate ORACLE_HOME on Linux/UNIX and Windows (SQL*Plus, oraenv, Registry, Inventory)

Meta Description: Learn reliable methods to find ORACLE_HOME on Linux/UNIX and Windows-using oraenv, orabase/orabasehome, Registry queries, and opatch inventory-plus what lives under the Oracle Home and common pitfalls to avoid.