UPGRADE 11.2.0.2 to 11.2.0.4

UPGRADE 11.2.0.2 to 11.2.0.4

1) Put DB in no archive log mode

2) Backup database using RMAN (cold backup would preferable) or DATAPUMP depending on

size of DB

3) Run this from 11.2.0.2 home

Run Pre-upgrade Information Tool

SQL>spool /tmp/utlu112i.log

SQL>@ORACLE_HOME/rdbms/admin/utlu112i.sql

SQL>spool off

Note: view log for any errors that need to be fixed.

4) On 11.2.0.2 home run EXECUTE dbms_stats.gather_dictionary_stats;

5) Changes will need to be made in the init.ora or spfile.

6) Run dbupgdiag.sql.Check any invalid objects in dba_registry.

Valid all Dba_registry object by running utlrp.sql

sqlplus / as sysdba

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

7) Shut down database normal:

8) Set New Oracle_HOME,PATH,LIBRARY_PATH.Copy tnsnames.ora,listener.ora,spfile,pfile &

password to new oracle_home location.Update /etc/oratab.

a) Update oratab.

vi /etc/oratab

#adstest:/opt/oracle/product/11.2:N

adstest: /u02/app/oracle/product/11.2.0.4/db_1:N

+ASM:/u01/app/11.2.0/grid:N

b) export ORACLE_HOME=/u02/app/oracle/product/11.2.0.4/db_1

 export ORACLE_SID=adstest

c)  Copy pfile,spfile & password files

cp *ora /u02/app/oracle/product/11.2.0.4/db_1

$vi initadstest.ora

/u02/app/oracle/product/11.2.0.4/db_1/dbs

Note: make sure you edit right pfile the one from new home is the one you need to modify

 d)Copy tnsnames.ora,listener.ora & sqlnet.ora

9) Upgrade database manually

10) Start upgraded db

11) Run the post upgrade script utlu112s.sql to display the results of the upgrade and

run catuppst.sql to finish the upgrade. Finally run utlrp.sql to recompile any remaining stored

PL/SQL and Java code and verify that all expected packages and classes are valid:

Post things:

1) Edit pfile and uncomment hidden parameter

2) Create spfile from pfile and start db with spfile

Backup up new database after upgrade

Enable archive log mode

HAPPY UPGRADE!!!!!!!!!