- 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.
This was first published in July 2005