Oracle EBS apps Upgrade from 12 2 to 12 2 5 (start CD 51)
By watching this video you can easily upgrade EBS 12.2 to 12.2.5.
EBS Apps 12.2 upgrade to 12.2.5 with start CD 51
First download code checker 17537119, unzip it on both DB and Apps
Step 1A:Apply Consolidated Seed Table Upgrade Patch on run file system Patch 17204589
Follow:
sh $ADMIN_SCRIPTS_HOME/adstpall.sh
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
step 2D:Check which patches need to apply on DB by using code checker
First download code checker 17537119, unzip it on both DB and Apps
./checkDBpatch.sh
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
export PATH=$PATH:$ORACLE_HOME/OPatch
opatch apply
Note: Before apply these patches the Database should be down.
19908836
22540024
22098146
21286665
21321429
21387964
21841318
21864513
21904072
21967332
22496904
Step 3D: Recheck if any patchecs are need to apply on DB by using ETCC.
start the database.
Step 4A: Run ETCC code checker to know which patches are need to apply in Apss.
./checkMTpatch.sh
it suggested below patches:
10.1.2 Patches
================
22698265
FMW webtier
===========
22288381
FMW oracle_common
=================
9905685
21366277
21628307
WLS
===
20780171
22323006
Step 5A: Applied above patches on Apps (Shut down all apps services).
Apply 10.1.2 Patches:
which opatch
/u01/oracle/ebsdb/fs1/EBSapps/10.1.2/OPatch/opatch
opatch apply
Apply FMW webtier Patches:
export ORACLE_HOME=/u01/oracle/ebsdb/fs1/FMW_Home/webtier
$ORACLE_HOME/OPatch/opatch apply
Apply FMW oracle_common Patches:
export ORACLE_HOME=/u01/oracle/ebsdb/fs1/FMW_Home/oracle_common
$ORACLE_HOME/OPatch/opatch apply
Apply WLS Patches:
To Apply Weblogic patches first copy and unzip all patches to /u01/oracle/ebsdb/fs1/FMW_Home/utils/bsu/cache_dir location.
p13729611_1036012_Generic.zip p19687084_1036012_Generic.zip p22128205_1036012_Generic.zip
p17319481_1036012_Generic.zip p20780171_1036_Generic.zip p22323006_1036_Generic.zip
cd $FMW_HOME/utils/bsu
./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=EJUW -prod_dir=$FMW_HOME/wlserver_10.3
To Remove conflicts:
./bsu.sh -remove -patchlist=Y5AP -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -remove -patchlist=BLTG -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -remove -patchlist=1LRI -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -remove -patchlist=VKXF -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -remove -patchlist=2GYW -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -remove -patchlist=CW9T -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -remove -patchlist=FCX7 -prod_dir=$FMW_HOME/wlserver_10.3
To Apply Patches:
./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=EJUW -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=GK5N -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=N5FK -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=8FBW -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=L34G -prod_dir=$FMW_HOME/wlserver_10.3
./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=DI8E -prod_dir=$FMW_HOME/wlserver_10.3
Step 6A: Recheck if any patchecs are need to apply on APPS by using ETCC
Step 7A: Bring up and brought down the Application services.
Step 8A: Start Admin server and Apply below pathes.
Patch 20745242:R12.AD.C.Delta.7
Patch 22123818:R12.AD.C
Patch 20784380:R12.TXK.C.Delta.7
Patch 22363475:R12.TXK.C
Patch 22495069:R12.TXK.C
sh adadminsrvctl.sh start
sqlplus "/as sysdba" @adgrants.sql APPS
adop phase=apply patches=20745242 hotpatch=yes
sqlplus "/as sysdba" @adgrants.sql APPS
adop phase=apply patches=22123818 hotpatch=yes
adop phase=apply patches=20784380,22363475,22495069 hotpatch=yes merge=yes
Step 9D:
alter system set optimizer_adaptive_features=false scope=both;
Step 10A:Bring down the instance and apply the below patch
adop phase=apply apply_mode=downtime patches=19676458
Step 11D:
alter system set optimizer_adaptive_features=true scope=both;
Step 12A: Start the all apps services by using adstrtal.sh script.
Step 13A:
adop phase=cleanup
Step 14A:
adop phase=fs_clone
Step 15D: Set the local listener parameter in parameter file.
alter system set local_listener='ebsdb' scope=both;
Transport tablespace by using RMAN.: • Transport tablespace by using RMAN.
Table Shrinking in Oracle Database : • Table Shrinking in Oracle Database
Transporting tablespace to different platform by Using RMAN : • Transporting tablespace to different platf...