Download Patch 11.2.0.4
Check the database name and current version
Sql> select name from v$database;
Sql> select * from v$version;
Make dir new oracle home for 11.2.0.4
$mkdir -P /u02/app/oracle/product/11.2.0.4/db_4
Install patch (p10404530)
su – oracle
cd /mnt/database
$ ./runinstaller -silent -force -responsefile <response file location>
Pre upgrade Step
/u02/app/oracle/product/11.2.0.4/db_4/rdbms/admin/utlu112i.sql
* Change to the directory where utlu112i.sql had been copied in the previous step.
* Start SQL*Plus and connect to the database instance as a user with SYSDBA privileges. Then run and spool the utlu112i.sql file. Please note that the database should be started using the source Oracle Home .
Sqlplus / as sysdba
Sql> spool /tmp/upgrade_info.log
Sql >@utlu112i.sql
Sql> spool off
Check for the integrity of the source database.
Check for the integrity of the source database prior to starting the upgrade by downloading and running the dbupgdiag.sql script from the My Oracle Support article below:
$ sqlplus / as sysdba
Sql>@dbupgdiag.sql
Sql> exit
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.
Sql>@utlrp.sql
Upgrading to 11.2.0.4
Before upgrade take Rman cold backup.
export ORACLE_HOME=/u02/app/oracle/product/11.2.0.4/db_4
export PATH =$ORACLE_HOME/bin:$PATH
Edit /etc/oratab file with new oracle home entry
test:/u01/app/oracle/product/11.2.0.4/db_4:N
$.oraenv
Cd $ORACLE_HOME/rdbms/admin
Sqlplus ‘/ as sysdba’
Sql > startup upgrade
Sql > spool /tmp/upgrade.log
Sql > @catupgrd.sql
Sql > spool off
Run the Post-Upgrade Status Tool $ORACLE_HOME/rdbms/admin/utlu112s.sql which provides a summary of the upgrade at the end of the spool log. It displays the status of the database components in the upgraded database and the time required to complete each
component upgrade. Any errors that occur during the upgrade are listed with each component and must be addressed.
Sqlplus “/ as sysdba”
Sql> startup
Sql > utlu112s.sql
Run catuppst.sql, located in the $ORACLE_HOME/rdbms/admin directory, to perform upgrade actions that do not require the database to be in UPGRADE mode
Sql > @catuppst.sql
This script can be run concurrently with utlrp.sql. Run utlrp.sql to recompile any remaining stored PL/SQL and Java code in another session.
Sql >@utlrp.sql
Upgrade Statistics Tables Created by the DBMS_STATS Package.
If you created statistics tables using the DBMS_STATS.CREATE_STAT_TABLE procedure, then upgrade these tables by executing the following procedure: