Currently, I have an Oracle8i database on a UNIX server. Now I want to install Oracle9i on the same server, so 9i and 8i will co-exist on it. Would you give me instructions on how to configure the system before the installation of 9i so that the 8i database will not be affected?

    Requires Free Membership to View

In order to install Oracle9i without affecting your existing 8i binaries and databases, you will first need to check system resources (disk space, memory, etc.), kernel parameter settings and OS patch level on the server. The Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems (Part No. A96167-01) available on the Oracle Technology Network provides very detailed information on which checks to perform prior to installing Oracle 9.2. At a very high level, the installation process is as follows. Again, please refer to the Oracle documentation for more detailed information.

  • Create a new ORACLE_HOME. If your 8i ORACLE_HOME is /oracle/product/817, create /oracle/product/920.
  • I will often put a dummy entry into the /etc/oratab file with the new ORACLE_HOME such as:

    DUMMY:/oracle/product/920:NI 
    

    then set my environment to this new dummy instance using oraenv (or whatever method you currently use to set your environment).

  • Start the Oracle Universal Installer from the 9.2 media or staging area; be sure that you provide the new ORACLE_HOME value in the appropriate screens.
  • Follow the installation instructions. When the installation is complete, check the installActions.log file located in the oraInventory/logs subdirectory. Also check the make.log file to ensure there were no relinking errors. Apply all required patches so that you will be at the latest supported version.
  • Before you create a new instance, remove the dummy entry from /etc/oratab and put in a legitimate 9.2.0 entry. Set your new environment to this new SID and ORACLE_HOME and proceed with 9i database creation, either using scripts or through the Database Creation Assistant.

This was first published in July 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: