Database Upgrade to 10.2.0.4

Database Upgrade 10G to 10.2.0.4 - DB Upgrade to 10.2.0.4::

Please fine the below steps which will outline 10.2.0.4 DB upgrade action plan.

0)Check the status of all the components before the upgrade:

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

SQL>select count(*) from dba_objects where status='INVALID';

1)Download and unzip patch p6810189_10204_Linux-x86-64.zip in /stage directory.

2)Shutdown database and listener

Set the following env variables:

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/bin/OPatch:$PATH:

ORACLE_HOME=Oracle_home

ORACLE_SID=sid

export ORACLE_HOME ORACLE_SID

3)Install the 10.2.0.4 patch set

From VNC launch the runinstaller.

cd /stage/Disk1

./runInstaller

On the Welcome screen, click Next.....

4)Upgrading the databse to 10.2.0.4

a)Run the Pre-Upgrade Information Tool

Start the database in the UPGRADE mode:

sqlplus '/as sysdba'

SQL> STARTUP UPGRADE

SQL> SPOOL upgrade_info.log

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

SQL> SPOOL OFF

Check the output of the Pre-Upgrade Information Tool in the upgrade_info.log file,Make sure all are fine.

b)Upgrade the Database

SQL> STARTUP UPGRADE

SQL> SPOOL patch.log

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

SQL> SPOOL OFF

c)Restart the database:& Compile Invalids.

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

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

5)Check the status of all the components after the upgrade:

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

SQL>select count(*) from dba_objects where status='INVALID';