- 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:
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.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...continue reading
Can I use /var/opt/oracle/oratab to specify listener information?continue reading
I'm getting errors while installing the Database Configuration Assistant.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.