RelationalDBDesign RelationalDBDesign

DB Creation   «Prev  Next»
Lesson 3Locating Oracle Home
Objective Find your Oracle Home directory.

Locating Oracle Home

Understanding Oracle Home

Next we are going to discuss the Oracle Home directory.
When you install Oracle software, you end up with a large directory structure that contains all the executables and other files that make Oracle work. All these directories sit under one top-level directory referred to as the Oracle Home directory. The diagram below shows some of the directories that you might find in a typical installation. Move your mouse over the diagram to learn about each directory:

  1. Bin: Contains executable files
  2. rdbms: Contains Oracle supplied DBA scripts
  3. plus: Contains files related to SQL*Plus
  4. network: Contains SQL*Net configuration files
  5. orainst: Contains the Oracle installer software

Directories Oracle Home

Finding your Oracle Home

If you are running the UNIX operating system, you will have an environment variable named ORACLE_HOME that points to the top-level Oracle directory. You can make that directory your current working directory by issuing the following command:


If you are running Oracle8 software under Windows, and if you accepted all the defaults when first installing Oracle, your home directory will be one of the following:

c:\orant (Windows NT, prior to version 8i)
c:\oracle\ora81 (Beginning with release 8.1.5, the 8i release)

Oracle Home Directory

If you currently have access to Oracle8, take a moment now to be sure that you can find your Oracle Home directory.

Determining the Default Oracle Home

By default, when you start Oracle Universal Installer, the software searches your system to determine the default Oracle home where Oracle software should be installed.
In all cases, the ORACLE_HOME name is taken first from the command line if it is specified, or else from the response file if specified.
If not specified, the value of DEFAULT_ORACLE_HOME_NAME in the oraparam.ini file is examined. Typically, the following convention is used for the name: