Q

8i and 9i databases on same server

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?

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?
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

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close