Upgrading Oracle database 11.2.0.2 to 11.2.0.4

1) Patch Set to 11.2.0.3 has been suspended by oracle it means we need to go to 11.2.0.4

Step 1) Download and Install the 11.2.0.4 software binaries
Step 2) Run the pre-upgarde tool . From the existing oracle instance
$ORACLE_HOME/rdbms/admin/utlu112i.sql

If pre-upgrade tool is not run then error is obtained at the time of upgrade 

Step 3) Run dbupgdiag.sql script from the below My Oracle Support article to verify that all the components in dba_registry are valid and no invalid data dictionary objects exist in dba_objects

Metalink id :-- Note 556610.1  ( For downloading the script for step 3)

Step 4) 

If the dbupgdiag.sql script reports any invalid objects, run $ORACLE_HOME/rdbms/admin/utlrp.sql (multiple times) to validate the invalid objects in the database, until there is no change in the number of invalid objects. 

Step 5) After validating the invalid objects, re-run dbupgdiag.sql in the database once again and make sure that everything is fine.

Step 6) Take the backup of the database before upgrade

rman target /
run
{
backup database plus archivelog ;
}

Step 7) Shutdown the database 

Step 8) Copy the pfile,passwordfile to new dbs directory from old dbs directory

Step 9) Copy the listener.ora,tnsnames.ora and sqlnet.ora from old $ORACLE_HOME/network/admin to new $ORACLE_HOME/network/admin

Step 10) Set ORACLE_HOME to new binary location

Step 11) sqlplus / as sysdba
             sql > startup upgrade
             sql > @$ORACLE_HOME/rdbms/admin/catupgrd.sql;
             sql > shutdown immediate
Step 12) Restart the database in normal mode

Step 13) @$ORACLE_HOME/rdbms/admin/catuppst.sql

Step 14) @$ORACLE_HOME/rdbms/admin/utlrp.sql;

Step 15) Run Script from step 3

Step 16) Upgrade the time zone to latest version using DBMS_DST

Follow document link Note 1201253.1