Upgrade to R12 (Round 2)

Preupgrade

Restore R11i backup of 30th Nov

Database Backup
Nov 30 23:34 /backup/ERPPJD/2012_11_30
Application Backup
Nov 30 23:45 /backup/ERPPJD/2012_11_30_20

Set up

Set appstier env to R11i
Go to Maintenance mode sqlplus apps/clone @${AD_TOP}/patch/115/sql/adsetmmd.sql ENABLE    

From R12.1 Upgrade Guide part# E16342-04:
Apply patch 7705743 (TUMS)
Round 1 applied patch 5120936.  This should be replaced by patch 7705743.  

Skipping step "Drop custom triggers".  This needs custom schema name and password and drops triggers named ALR_%.  All our ALR_% triggers are owned by APPS.  

Set initialization parameters alter system set recyclebin=off scope=spfile; and bounce database.  

SHOULD HAVE TURNED OFF ARCHIVELOG MODE HERE.    

Unset the R11i environment (edit the .bash_profile and login again to applpjd)

Check GUEST password
select fnd_web_sec.validate_login('GUEST','') from dual; Should return Y.

applpjd@gsulerpd13 /backup/R12.1.1.32bit/startCD/Disk1/rapidwiz   Disk space after removing erpr12 (keeping some backups in /u14/app/erpr12.back.after1stattemp):  

Filesystem                                                         Size Used Avail Use% Mounted on
172.29.158.27:/vol/gsulerpd13_applbase_u14/gsulerpd13_applbase_u14 130G 71G  60G   55% /u14

Create R12 Apps Tier filesystem

Follow the same steps as per Round 1 but using the 32 bit Apps s/w.

[applpjd@gsulerpd13 /backup/R12.1.1.32bit/startCD/Disk1/rapidwiz]$ nohup ./rapidwiz &

Tools is in oraAS/Disk1: [applpjd@gsulerpd13 /backup/R12.1.1.32bit]$ grep -i tools ora*/Disk*/disk.label
oraAS/Disk1/disk.label:Label=Oracle Applications Rapid Install - Tools
oraAS/Disk2/disk.label:Label=Oracle Applications Rapid Install - Tools
oraAS/Disk3/disk.label:Label=Oracle Applications Rapid Install - Tools
Elapsed: about 1hr. 

Filesystem                                                         Size Used Avail Use% Mounted on
172.29.158.27:/vol/gsulerpd13_applbase_u14/gsulerpd13_applbase_u14 130G 98G 33G 75% /u14=> 17GB used.

 

Patches discovered in previous run

Set the environment to R12 (edit the .bash_profile and login again to applpjd)



Create the R12 defaults file in the usual way.  This required the R12 adgrants.sql to be applied first.  

For ORA-00979: not a Group by in pechktsk.sql, apply patch 8855023 in R12 env in preinstall mode.  (2 mins)  

For PMI_REP_PROD_STATUS Will Not Compile, apply Patch 9062910 in R12 env in preinstall mode.  (3 mins)  

As a result of these 2 steps adpatch,

• creates $APPL_TOP/admin/$TWO_TASK/preinstall directory and populates them with the drivers from these 2 patches.
• updates the scripts in $PER_TOP and $PMI_TOP

The following 3 steps "AD.B Patches", "CUP", "Main R12 Upgrade Patch" are from the 12.1.1 Release Notes 798258.1

AD.B Patches

Merge and apply patches 9179588, 9477107, 7461070.   Unzip these 3 patches into  /capgemshare/other/R12/merge1.in
[applpjd@gsulerpd13 /capgemshare/other/R12]$ admrgpch -s merge1.in -d merge1.out -admode -merge_name merged_ADB

Start: 2:32 pm 03/01/2013
adpatch defaultsfile=/u14/app/erpr12/ERPPJD/apps/apps_st/appl/admin/ERPPJD/adalldefaults.txt.ERPPJD logfile=u_merged_ADB-1.log patchtop=/capgemshare/other/R12/merge1.out driver=u_merged_ADB.drv workers=4 interactive=Y

Elapsed: 15 mins [COULD USE > 4 WORKERS HERE!]

From the REAME of 7461070, run adgrants.sql:
sqlplus / as sysdba @adgrants.sql APPLSYS
NOTE: This caused problems later on with asostats.sql and afffvst1.sql unable to compile FND_STATS (see below)

Consolidated Upgrade Patch (CUP)

Merge and apply in preinstall mode, 7303029 and 33 patches from Note 1448102.1 Pre-install patches Report.

These patches were saved into /u14/app/erpr12.back.after1stattemp
Only the patches in the Upgrade Script Failure column were selected. 


[applpjd@gsulerpd13 /u14/app/erpr12.back.after1stattemp/ERPPJD/apps/apps_st/appl/au/12.0.0/patch/115/driver]$ ls p*.zip

while read fname
> do
> unzip -q $fname -d /capgemshare/other/R12/merge2.in
> done

admrgpch -s merge2.in -d merge2.out -merge_name merged_CUP

time adpatch preinstall=y defaultsfile=/u14/app/erpr12/ERPPJD/apps/apps_st/appl/admin/ERPPJD/adalldefaults.txt.ERPPJD logfile=u_merged_CUP-2.log patchtop=/capgemshare/other/R12/merge2.out driver=u_merged_CUP.drv workers=12 interactive=Y
Elapsed: about 2 mins.

This further populates the R12 $APPL_TOP/admin/$TWO_TASK/preinstall folder with u_merged_CUP.drv

Main R12 Upgrade Patch

Following the README from 7303029,
cd $AU_TOP/patch/115/driver
time admrgpch -d . -preinstall -master u6678700.drv
Elapsed: about 2 mins

Start: Thu Jan 03 2013 15:41:55
time adpatch options=nocopyportion,nogenerateportion defaultsfile=/u14/app/erpr12/ERPPJD/apps/apps_st/appl/admin/ERPPJD/adalldefaults.txt.ERPPJD logfile=u_merged_AMEngUPG-2.log patchtop=$AU_TOP/patch/115/driver driver=u_merged.drv workers=16 interactive=Y

Notes

After 5 mins, get "Do you want to run AutoPatch with these actions turned off [Yes] ?" Yes (lost 30 mins here)

Fri Jan 04 2013 00:35:27

FAILED: file asostats.sql on worker 3.
FAILED: file afffvst1.sql on worker 5.

This is due to inability for APPS to compile FND_STATS.  This was a post-install step for patch 7461070, but is was run with APPLSYS parameter instead of APPS.
Fix:
sqlplus / as sysdba @adgrants.sql APPS, not APPLSYS.
Restart workers.
(lost 8 hours here)  continuing ...