How To Set Oracle_home And Oracle_sid In Windows

Oracle Database - Oracle Home Directory (ORACLE_HOME|OH)

Most

The Oracle dwelling house directory (ORACLE_HOME) is the directory where y'all choose to install the software for a particular Oracle product. You lot must install unlike Oracle products or different releases of the aforementioned Oracle product in separate Oracle domicile directories. When you run Oracle Universal Installer, it prompts you lot to specify the path to this directory as well every bit a name that identifies it. The directory that yous specify must be a subdirectory of the Oracle base directory. Oracle recommends that you lot specify a path like to the following for the Oracle dwelling 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 right 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 equally the Oracle dwelling house directory. If you exercise, then you may experience installation failure due to file and group ownership permission errors.

Articles Related

Question marking

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 marker in the following SQL statement to the full path of the Oracle abode directory:

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

How to identify an existing Oracle abode directory

On Windows

To check the path of the Oracle dwelling directory:

From the Offset carte, cull Programs, then Oracle - HOME_NAME, so 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.

On Linux

Enter the post-obit 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, and so information technology contains lines similar to the post-obit:

              *:/u03/app/oracle/production/11.2.0/dbhome_1:Due north *:/opt/orauser/infra_904:Due north *:/oracle/9.2.0:North

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

              /u03/app/oracle /oracle

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

Confirmation

From the orainventory dir:

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

Recommended Pages

Installation of Oracle Workflow two.vi.iv for Oracle Database 10gR2

Prerequisites Download the Companion CD on OTN :

Oracle Database 10g Release two (x.ii.0.i.0) , File : 10 "...

OBIEE 11g - Oracle Business organisation Intelligence 11.i Simple installation steps on Windows and OEL Linux 32 bit

This commodity covers the installation of Oracle Business Intelligence 11.1. Oracle Business Intelligence Enterprise Edition refers toAnswerDashboardDeliverRepository Administration TooOfficOracle Passenger vehicle "...

Oracle Database - (initialization|server) parameter file (init.ora | spfile.ora)

How to manage the initialization parameters when the database showtime. Articles Related Management File Location Past default, the preconfigured database uses aparameteORACLE_HOMdatabasAutomatic Storage M "...

Oracle Database - 12c Installation on Windows 64 bit

Installation of Oracle Database 12c (12.1.0.1.0) on Windows. Y'all can download the oracle software from

OTN or ameliorate "...

Oracle Database - Configuration of the Listener (listener.ora)

A listener is configured with 1 or more than listening protocol addresses, information supported services, and parameters that control its run-time behavior. The listener configuration is stored in the c "...

Oracle Database - Environment Variables / Registry Values

To configure the database installation, Oracle provide several Environs variable / Registry Value. : oracle_sid is used for a local connexion - direct to the server - without using a listLOCAL "...

Oracle Database - How to read data through an ODBC connection with Gateway (Heterogeneous services)

This article is aimed to show how you tin access data from oracle database via an odbc connection straight by using the gateway odbc agent (or program) generic connectivityexcdatabase lindefine a nSIglo "...

Oracle Database - Installation 11g Release 2 (11.2) on Linux OEL 5 (X86)

Installation of Oracle Database 11g Release 2 (11.ii) on Oracle Enterprise Linux 5. Articles Related Prerequisites Linux OEL installation Preinstallation Requirements login as rooAdd Swap spacenvir "...

Oracle Database - ORACLE_SID environment variable

ORACLE_SID is an environment variable which identify the Arrangement Identifier (SID) of the database. Articles Related At sign (@) The at sign (@) represents the ORACLE_SID surroundings variable. For examp "...

Oracle Database - Oracle Net Director

Oracle Cyberspace Managing director enables you to configure Oracle Net Services for an Oracle home on a local client or server host. You can use Oracle Net Director to configure the post-obit network components: Loc "...