Upgrade from 10.2.0.1 to 10.2.0.4

Before database upgrade it is recommanded to backup the PRODUCTION database.

1. Stop all services of oracle

emctl stop dbconsole

sqlplus “/as sysdba”

SQL> shutdown immediate

2. Install the Database Patch Set

   export DISPLAY=10.13.5.95:0.0
   /u01/stage/patch/Disk1/runInstaller

3. Upgrade Database

   sqlplus “/as sysdba”

SQL> STARTUP UPGRADE

SQL> SPOOL /u01/stage/patch/Disk1/upgrade_info.log

SQL> @?/rdbms/admin/utlu102i.sql

SQL> SPOOL OFF;

SQL> SPOOL /u01/stage/patch/Disk1/patch.log

SQL> @?/rdbms/admin/catupgrd.sql

SQL> SPOOL OFF

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

To compile invalid objects

SQL> @?/rdbms/admin/utlrp.sql

SQL> select comp_name, version, status from sys.dba_registry;