Database Upgrade from 10.2.0.2 to 10.2.0.3 – R12
Posted by vasselva on October 26, 2007
Oracle Apps certified the 10.2.0.3 database with R12.Metalink Note 454750.1
Here I will explain my upgrade experience.
As a normal practice before doing upgrade please backup your system. Download the required patches.
Operating system |
Unix Users |
Windows users |
Patch set |
5337014 |
5337014 |
Patch |
6319846 |
6344567 |
1. Before Upgrade , check the invalid count in the database
2. Unzip the patch 5337014 .
3. Invoke the run installer for unix and setup.exe for windows users.
4. As a part of post install step
· Start the database in upgrade mode
· @?/rdbms/admin/catupgrd.sql
· After completed upgrade ,Shutdown the database and startup in normal mode.
· @?/rdbms/admin/utlrp.sql
· Apply the additional patches(6319846 and 6344567)
anubhav said
Nice post
Please see this link and post your valuable comments
http://infosysblogs.com/oracle/2008/12/r12_upgrade_whats_in_it_for_re.html#more