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:

About the author
Leave Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

clear formSubmit