Oracle Database Upgrade 11.2.0.1 to 11.2.0.4 on Windows 2008 R2 64-bit

Hello friends,

Again, an upgrade, this was done by my colleague and he has documented this changes, credit goes to him. Thanks buddy!

Database Upgrade 11.2.0.1 to 11.2.0.4 on Windows 2008 R2 64-bit

Download Patchset p13390677 01 and 02 files (2.3gb) from metalink

à Install 11.2.0.4 on a different home

Pre-checks :-

àAfter Installing 11.2.0.4 , Go to 11.2.0.1 database and run :

SQL> spool pre_upgrade.log

SQL> @d:/oracle/11.2.0.4/dbhome_2/rdbms/admin/utlu112i.sql

SQL> spool off

àCopy the following Files to New Home 11.2.0.4 :

1.Spfile/Pfile/init.ora

2.orapwd

3.tnsname.ora

4.Listener.ora

àSet The environment to 11.2.0.4

Set ORACLE_HOME=D:/oracle/product/11.2.0.4/dbhome_2

Set ORACLE_SID=PROTECT

à Bring down the database from 11.2.0.1 and start the database in upgrade mode from 11.2.0.4 home by copying the pfile/spfile of 11.2.0.1 database to 11.2.0.4_HOME/dbs path

                --> SC DELETE <dbservice_name>            (dbservice_ame in services.msc)

                --> oradim -new -sid PROTECT -startmode auto

set ORACLE_SID=protect

sql>startup upgrade

sql>spool cat_upgrd.log

@d:/oracle/11.2.0.4/dbhome_1/rdbms/admin/catupgrd.sql

spool off

sql>startup

@d:/oracle/11.2.0.4/dbhome_1/rdbms /admin/utlrp.sql

shutdown immediate;

Post upgrade steps –

$ sqlplus “/as sysdba”

SQL> STARTUP

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

select comp_name,version,status from dba_registry;

select owner,count(*) from dba_objects where status != ‘VALID’ group by owner;

7àChange the compatibility parameter

Change the compatible parameter and restart the database.

—-SQL> alter system set compatible=’11.2.0.4.0' scope=spfile;

SQL> shutdown immediate;

SQL> startup;

NOTE :-

if OWB component is not upgraded properly, do the following steps...

¦Upgrade the OWB Component to the database version

1.Start SQLPlus and connect with an account having SYSDBA privileges

2.Drop the OWBSYS schema by executing the script:

SQL> @<OH>/owb/UnifiedRepos/clean_owbsys.sql 

3.Re-create the OWBSYS schema with the script:

SQL> spool <a_file_system_path>cat_owb.log

SQL> @<OH>/owb/UnifiedRepos/cat_owb.sql <tablespace_name>