Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multiple Oracle Homes with 9i

Re: Multiple Oracle Homes with 9i

From: NorwoodThree <norwoodthree_at_my-deja.com>
Date: 17 Sep 2002 11:59:30 -0700
Message-ID: <ba03e2c.0209171059.3726ec55@posting.google.com>


Bookmark Fixed font Go to End

Doc ID: Note:73963.1
Subject: WIN: Using multiple ORACLE HOMES on Windows platform Type: BULLETIN
Status: PUBLISHED
 Content Type: TEXT/PLAIN
Creation Date: 03-SEP-1999
Last Revision Date: 31-MAY-2002  

PURPOSE     Explains the usage of multiple ORACLE_HOMES on the Windows platform  

SCOPE & APPLICATION     Anyone doing installations on Windows 95, Windows 98, Windows NT or   Windows 2000.  


 

Using Multiple ORACLE HOMES on Windows 32-bit platforms

Multiple Oracle Homes is a feature that is available starting with the Oracle 8.0.4 release on NT. It is applicable for 32-bit installations only.

Versions prior to Oracle8 8.0.4 must still reside in the same Oracle Home,
and the difference for those versions is still made by the second digit.

Examples:
- Oracle7 7.2.2.4 and 7.3.4 can be installed together in same Oracle Home.
- Oracle7 7.3.3 and 7.3.4 can not be installed together. - Oracle8 8.0.3 and 8.0.4 can be installed together on the same machine
  in separate Oracle Homes. However, 8.0.3 should still be installed in
  the first default Oracle Home.

The reason for the above limitation was due to the fact that the Oracle executables
were named using the version numbers. Server Manager was named svrmgr23 or svrmgr30.
 In the case of svrmgr23, if Oracle version 7.3.4 was installed into the same home
as 7.3.3, then the executables would be over written. This naming convention has been dropped since Oracle 8i.

The Oracle Installer (ORCA) Oracle version 8.0


When using the Oracle Installer for version 8.0.X, there were still some limitations
imposed when installing into multiple Oracle homes. This version of the installer
divided the products up into the following categories:

  Multiple Oracle HOME Compliant Products :

Note:

   Although the Oracle Intelligent Agent is a Multiple Oracle Home Enabled

   Product, and thus can be installed multiple times, ONLY ONE VERSION can be

   running at a given time.

The Oracle Universal Installer (OUI) Oracle version 8.1.X - 9.1.X


With the release of Oracle 8i, the restrictions on Multiple Home compliant
products has been removed. All database products installed are now multiple home compliant



Installation

The Oracle Installer - Oracle8 8.0.4 - 8.0.6


The Oracle Installer will prompt you for an Oracle Home. With this screen, both
the starting location and the 'description/logical name' can be given.

The Oracle Universal Installer - Oracle8i and Oracle 9i - all versions


The Oracle Universal installer will prompt you for the name of an Oracle Home
and its path.

        It is highly suggested that each version of the Oracle database be installed into
its own home. This makes maintenance easier and will allow the deletion of homes
in the event that the version is no longer needed.

        A suggested layout for Oracles homes is                 

		X:\Oracle
			...\Admin
			...\Ora816
			...\Ora817
			...\Ora911
			...\Oradata

	With the above disk layout, we have a separate Oracle home for Oracle
8.1.6, 8.1.7
and Oracle 9.1.1. The directories ADMIN and ORADATA contain administrative and datafiles respectively.

System Changes



The name of the Windows group "Oracle for Windows NT" is appended with the
name given during install to your new Oracle Home. The group for an Oracle HOME installation named HOME_804 will be created as "Oracle for Windows NT - HOME_804"

The new Oracle Home name is included in the service names. As an example, a listener
installed in an ORACLE_HOME named HOME_804 will be registered as a service named "OracleHOME_804Listener80".

The database service will NOT include the Oracle Home name. A database with the
sid name of PROD installed into an Oracle Home will be named OracleServicePROD.

Registry settings



New registry keys have been added in the ORACLE tree to support multiple
Oracle homes.

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES holds :

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\IDx, where x is the identifier of the Oracle Home, holds:

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx, where x is the identifier of the
Oracle Home, holds:

How it Works



Everything is based upon the BIN directory from which an executable is started.

Oracle knows from which BIN directory a particular executable has been started and searches in this BIN directory for a file named oracle.key.
In this file Oracle finds the reference to the environment it should use
e.g. SOFTWARE\ORACLE\HOME1. If the oracle.key file is not present, then
the Default Oracle Home is used. This is the case for Non-Multiple Oracle
Home products.

The user should always be aware of which executable they are using.

The user should either start the executable from within a Windows Group e.g.
"Oracle for Windows NT - HOME_804", in which case the target of the shortcut
includes the ORACLE_HOME\BIN directory or start the executable from a DOS prompt,
in which case the order of the ORACLE_HOME directories in the PATH are of importance.

A utility, the Oracle Home Selector, is provided to allow the switching of
Oracle Homes. This utility does nothing other than set the ORACLE_HOME\BIN
directory, of the Oracle Home one has chosen to use, as the first directory
in your PATH variable. When using the Oracle Home Selector, you will need to
re-open your DOS window in order for those changes to take effect. The Oracle
Home Selector utility is only installed when you choose to install the Oracle
Installer.

Removing an Oracle Home


WARNING: THIS SECTION SHOULD BE USED WITH THE GREATEST OF CAUTION. IT
IS POSSIBLE TO RENDER ALL ORACLE SOFTWARE UNUSABLE IF THIS PROCEDURE IS
NOT FOLLOWED EXACTLY. Assume x is the identifier of the Oracle Home one wants to remove.

  1. Registry :
    • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES :
      • LAST_HOME := LAST_HOME - 1
      • HOME_COUNTER := HOME_COUNTER - 1
      • Delete the IDx key
      • For all IDy, where y > x, IDy := IDy-1 (rename keys with regedit)
    • HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE :
      • Delete the HOMEx key
      • For all HOMEy, where y > x, HOMEy := HOMEy-1 (rename keys with regedit)
  2. For all HOMEy, where HOMEy has been renamed to HOMEy-1 (see step 1), edit the ORACLE_HOME\BIN\oracle.key file and change HOMEy to HOMEy-1 The ORACLE.KEY file contains the registry hive in which the settings for that particular ORACLE_HOME are stored. Since the 'HOME' number has changed, the value of this file must be adjusted as well.
  3. In each 'HOMEy' key, check for a registry parameter called 'ID'. The value of this parameter must match the home number assigned to that ORACLE_HOME.
  4. Delete the Windows Group of the removed Oracle Home
  5. Delete the complete directory of the removed Oracle Home
  6. Remove the ORACLE_HOME\BIN directory, of the removed Oracle Home, from your PATH variable (Control Panel - System - Environment - System Variables)
  7. Delete all services related to the removed Oracle Home Deleting of the services should be done with either the 'SC.EXE' or the 'SRVINSTW.EXE' from the NT resource kit. Removing the service directly from the services key in the registry, will leave behind the LEGACY service which is kept for the hardware profiles. These 'orphaned' services can later pose problems if software is reinstalled or re-used.

Further reading


The Oracle platform specific Windows documentation contains more information on configuring multiple Oracle homes.

Please refer to the following manuals:

8i
Oracle8i Administrator's Guide for Windows NT

9i
Oracle9i Database Getting Started for Windows .  


 

 Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use. Received on Tue Sep 17 2002 - 13:59:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US