Oracle Database manual upgrade from 9.2.0.7 to 10.2.0.3

This upgrade is also similar to upgrade from 10.2.0.2 to 10.2.0.3 except in 9i there is no SYSAUX tablespace. We have to manually create the SYSAUX tablespace before we do upgrade.

Just follow all the steps described in my previous post "Oracle Database manual upgrade from 10.2.0.2 to 10.2.0.3" In Step 7 modify the steps as below.

Step 7: Start the upgrade
UNIX PROMPT> mkdir /tmp/upgrade/ -> create this directory to store the log files.
UNIX PROMPT> sqlplus "/as sysdba"
SQL> startup upgrade

After giving “statup upgrade” create the sysaux tablespace as follows.
SQL> CREATE TABLESPACE sysaux DATAFILE '/opt/mis/oracle/data/data/sysaux1a.dbf'
SIZE 1024M REUSE
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
ONLINE;

SQL> spool upgrade.log
SQL> @?/rdbms/admin/catupgrd.sql
Now the upgrade process will starts. It will take atleast 45 mins to 1:15 mins.
At last it will show the components list and their status.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.3.0 00:28:27
JServer JAVA Virtual Machine VALID 10.2.0.3.0 00:04:42
Oracle XDK VALID 10.2.0.3.0 00:01:02
Oracle Database Java Packages VALID 10.2.0.3.0 00:00:36
Oracle Expression Filter INVALID 10.2.0.3.0 00:00:22
Oracle Enterprise Manager VALID 10.2.0.3.0 00:03:51

SQL>spool off;