Oracle Database - Oracle Home Directory (ORACLE_HOME|OH)

Card Puncher Data Processing

About

The Oracle home directory (ORACLE_HOME) is the directory where you choose to install the software for a particular Oracle product. You must install different Oracle products or different releases of the same Oracle product in separate Oracle home directories. When you run Oracle Universal Installer, it prompts you to specify the path to this directory as well as a name that identifies it. The directory that you specify must be a subdirectory of the Oracle base directory. Oracle recommends that you specify a path similar to the following for the Oracle home directory:

oracle_base/product/11.2.0/dbhome_1

Oracle Universal Installer creates the directory path that you specify under the Oracle base directory. It also sets the correct permissions on it. You do not need to create this directory.

During installation, you must not specify an existing directory that has predefined permissions applied to it as the Oracle home directory. If you do, then you may experience installation failure due to file and group ownership permission errors.

Question mark

In Oracle Database files and programs, a question mark (?) represents the value of the ORACLE_HOME environment variable. For example, Oracle Database expands the question mark in the following SQL statement to the full path of the Oracle home directory:

SQL> ALTER TABLESPACE TEMP ADD DATAFILE '?/dbs/temp02.dbf' SIZE 200M

How to identify an existing Oracle home directory

On Windows

To check the path of the Oracle home directory:

  • From the Start menu, choose Programs, then Oracle - HOME_NAME, then Oracle Installation Products, then Universal Installer.
  • When the Welcome window appears, click Installed Products.
  • The Inventory window appears, listing all of the Oracle homes on the system and the products installed in each Oracle home.

Oracle Home Location

On Linux

Enter the following command to display the contents of the oratab file:

# more /etc/oratab

Entries are of the form:

$ORACLE_SID:$ORACLE_HOME:<N|Y>

where: ORACLE_SID

If the oratab file exists, then it contains lines similar to the following:

*:/u03/app/oracle/product/11.2.0/dbhome_1:N
*:/opt/orauser/infra_904:N
*:/oracle/9.2.0:N

The directory paths specified on each line identify Oracle home directories. Directory paths that end with the user name of the Oracle software owner that you want to use are valid choices for an Oracle base directory. If you intend to use the oracle user to install the software, then you can choose one of the following directories listed in the previous example:

/u03/app/oracle
/oracle

If possible, choose a directory path similar to the first one (/u03/app/oracle). This path complies with the OFA guidelines.

Confirmation

From the orainventory dir:

cat /u01/app/oraInventory/ContentsXML/inventory.xml





Discover More
Companion Oracle 10g Product
Installation of Oracle Workflow 2.6.4 for Oracle Database 10gR2

Download the Companion CD on OTN : Oracle Database 10g Release 2 (10.2.0.1.0) , File : 10201_companion_win32.zip...
Obiee 11.1 Internet Explorer 6 Not Supported
OBIEE 11g - Oracle Business Intelligence 11.1 Simple installation steps on Windows and OEL Linux 32 bit

Open the setSOADomainEnv.cmd file, located in your Update the PORT_MEM_ARGS entry as follows: set PORT_MEM_ARGS=-Xms512m -Xmx1024m Save the file and close. ;-) Oracle®...
Card Puncher Data Processing
Oracle Database - (initialization|server) parameter file (init.ora | spfile.ora)

How to manage the initialization parameters when the database start. By default, the preconfigured database uses a parameter file (spfile) named spfilesid.ora, which is stored in the $ORACLE_HOME/dbs...
Oracle Database 12c Step 12
Oracle Database - 12c Installation on Windows 64 bit

Installation of Oracle Database 12c (12.1.0.1.0) on Windows. You can download the oracle software from OTN or better...
Card Puncher Data Processing
Oracle Database - Configuration of the Listener (listener.ora)

A listener is configured with one or more listening protocol addresses, information supported services, and parameters that control its run-time behavior. The listener configuration is stored in the configuration...
Oracle Registry Windows
Oracle Database - Environment Variables / Registry Values

To configure the database installation, Oracle provide several Environment variable / Registry Value. : oracle_sid is used for a local connection - direct to the server - without using a listener...
Hs Odbc Excel Define Name
Oracle Database - How to read data through an ODBC connection with Gateway (Heterogeneous services)

This article is aimed to show how you can access data from oracle database via an odbc connection direct by using the gateway odbc agent (or program) generic connectivity. In this example, an odbc connection...
Oracle Database 11gr2 Typical Installation
Oracle Database - Installation 11g Release 2 (11.2) on Linux OEL 5 (X86)

Installation of Oracle Database 11g Release 2 (11.2) on Oracle Enterprise Linux 5. Linux OEL installation login as root RAM: At least 1 GB swap space The following table describes...
Card Puncher Data Processing
Oracle Database - ORACLE_SID environment variable

ORACLE_SID is an environment variable which identify the System Identifier (SID) of the database. The at sign (@) represents the ORACLE_SID environment variable. For example, to indicate a file that...
Oracle Database Net Manager
Oracle Database - Oracle Net Manager

Oracle Net Manager enables you to configure Oracle Net Services for an Oracle home on a local client or server host. You can use Oracle Net Manager to configure the following network components: ...



Share this page:
Follow us:
Task Runner