Oracle

Summary
Here are the steps to manual upgrade an Oracle8i (8.1.7.0) database to Oracle9iR2 in the same Unix environment.

1. With the same os user that owns the $ORACLE_HOME (8i) and database files create a new 9i $ORACLE_HOME. You can copy paste the Oracle9i binaries from another server and relink them to make them valid.

2. Set the Oracle 9i environment ($ORACLE_HOME, $ORACLE_SID, $PATH, $LD_LIBRARY_PATH) for the os user

3. Copy the Oracle8i initSID.ora and orapwSID (password file) to the new Oracle9i home. Remove entry for local_listener if exists in initSID.ora and set shared_pool_size = 110485760 (>110 MB)

4. Copy listener.ora and tnsnames.ora files from the old Oracle8i home to the new Oracle9i and start Oracle9i Listener.

5. Shutdown the Oracle8i database

6. Change directory to $ORACLE_HOME/rdbms/admin and execute >sqlplus "/ as sysdba"

7. Execute SQL>startup migrate

8. Execute SQL>SPOOL upgrade.log

9. Execute SQL>@u0801070.sql;

10. Check if the database components have been upgraded

SELECT comp_name, version, status FROM dba_registry;

COMP_NAME                      VERSION                        STATUS
------------------------------ ------------------------------ -----------
Oracle9i Catalog Views         9.2.0.8.0                      VALID
Oracle9i Packages and Types    9.2.0.8.0                      VALID