Please follow the steps from R12.2 Installation Document to install R12.2.0
Once we have installed R12.2.0,Please follow below steps to upgrade to R12.2.6.
HOW TO UPGRADE FROM R12.2.0 TO R12.2.6:
A) Upgrade Database to 11.2.0.4 or higher --> Our version is 12.1.0.2
B) Fusion Middleware Technology Stack (FMW) 11.1.1.7 (11gR1 PS6) or higher.
Note: We used StartCD 12.2.0.51. StartCD 51 installs Oracle Fusion Middleware 11g PS7 (11.1.1.9.0) & database 12.1.0.2.
C) Apply Required Database Patches
i) Before you apply the AD and TXK Delta 10 release update packs (RUPs), you must run the latest version (available via Patch 17537119) of the EBS Technology Codelevel Checker (ETCC). Use the command checkDBpatch.sh (on UNIX) or checkDBpatch.cmd (on Windows).
ii) Check that all the required database patches have been applied.To learn more about the prerequisite database patches needed for applying the Delta 8 RUPs, refer My Oracle Knowledge Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes.
Note:Ensure all the required ETCC database objects will be found by the Delta 8 RUP installation process. This means that even if you already have all the required database patches installed, you must still run the latest version of ETCC on your database.
RUN ETCC on DB Tier:
mkdir $ORACLE_HOME/appsutil/etcc
cd $ORACLE_HOME/appsutil/etcc
unzip /home/oracle/1226/ETCC/p17537119_R12_GENERIC.zip
./checkDBpatch.sh contextfile=/u01/oracle/TEST/12.1.0/appsutil/TEST_acsebs.xml
It will give us list of patches which needs to be applied before we proceed with upgrade. Instead of downloading individual patches
you can download Patch 26781264 [EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR AUG 2017] which contains all the required patches.
Download and unzip under $ORACLE_HOME/appsutil/etcc. then apply the required patches after bringing down db & application.
D) Set Database Parameter
Oracle Database 12c Release 1 uses cost based optimization. If you are using Oracle Database 12.1.0.2, the following optimizerparameter should always be set to 'false'. This setting should be completed before proceeding with the next steps and should not be changed thereafter. Set it in spfile or pfile and bounce the database.
optimizer_adaptive_features=false
E) Apply Consolidated Seed Table Upgrade Patch
Note: This step is applicable only for new installation customers and customers upgrading from Oracle E-Business Suite Release 12.2.2 to Release 12.2.6.
Note: If the Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD 12.2.0.51 (Patch22066363), you must apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 by merging with Patch21900871:12.2.0 on the run file system using adop hotpatch mode.
sh $ADMIN_SCRIPTS_HOME/adstpall.sh
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes patchtop=/1226/SEED_TABLE_CUP
F) Apply latest AD & TXK Patches:
i) Run ETCC tool on application Tier and apply missing patches..It will list the patches for below components.
Oracle Forms and Reports 10.1.2.3.0
Oracle Fusion Middleware (FMW) - Web Tier.
Oracle Fusion Middleware (FMW) - oracle_common
Oracle WebLogic Server (WLS)
We have one consolidated patch which will have all the mandatory patches. Apply the patches listed by ETCC.
Patch 26328262 - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2017
a) Apply patches on 10.1.2 Home.by default our env will be pointing to 10.1.2 ORACLE_HOME.NO need to change anything.
b) To Apply Patch in webtier home ,Set env variables below.
export ORACLE_HOME=$IAS_ORACLE_HOME;
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
c)To apply patch in Fusion middleware ORACLE_COMMON home,Set env variables below
export ORACLE_HOME=$FMW_HOME/oracle_common;
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
d)Apply weblogic patches
unzip patch $FMW_HOME/utils/bsu/cache_dir
cd $FMW_HOME/utils/bsu
./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=K25M -prod_dir=$FMW_HOME/wlserver_10.3
If there are any conflict ,You can use below syntax to remove conflict patches.
./bsu.sh -remove -patchlist=1LRI,2GYW,CW9T,VKXF,BLTG -prod_dir=$FMW_HOME/wlserver_10.3
iii) Apply latest 25820806 (R12.AD.C.Delta.10) and Patch 26720905:R12.AD.C in hotpatch mode.
Execute adgrants by following the instructions in the readme of Patch 25820806 (R12.AD.C.Delta.10).
adgrants.sql file in database tier before applying this patch
If Patch 25525148 (Rapid Install consolidated one-off bundle on top of startCD51) was not used while installing your Oracle E-Business Suite Release 12.2 system, apply the patches in the following order:
a. Apply Patch 25820806 (R12.AD.C.Delta.10)
adop phase=apply patches=25820806 hotpatch=yes patchtop=/shared/custom/1226/AD_TXK_LATEST workers=8
b. Apply Patch 26720905:R12.AD.C
adop phase=apply patches=26720905 hotpatch=yes patchtop=/shared/custom/1226/AD_TXK_LATEST workers=4
C. Apply AD crticical patches.
adop phase=apply patches=24591000,26482811 hotpatch=yes merge=yes patchtop=/shared/custom/1226/AD_TXK_LATEST workers=4
D. Apply TXK Delta 10 patch
adop phase=apply patches=25828573 hotpatch=yes patchtop=/shared/custom/1226/AD_TXK_LATEST workers=4
E.Apply TXK critical patches.
adop phase=apply patches=26400116,26720231,25994411 hotpatch=yes merge=yes patchtop=/shared/custom/1226/AD_TXK_LATEST workers=4
F. Run Middle Tier EBS Technology Codelevel Checker (MT-ETCC)
Execute the Middle Tier EBS Technology Codelevel Checker (MT-ETCC) utility checkMTpatch.sh
G. Stop Oracle WebLogic Server's Admin Server and Node Manager services.
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
H. Update database tier with the latest patches
i) Source Run File sysem.
ii) perl $AD_TOP/bin/admkappsutil.pl
iii) On the database tier (as the ORACLE user):
a. Source the environment for RDBMS ORACLE_HOME.
b.Copy or FTP the appsutil.zip(appstier) file to <RDBMS ORACLE_HOME>.
c.cd $ORACLE_HOME; cp -r appsutil appsutil.bkup.nov14;unzip -o appsutil.zip
d. Run Autoconfig on db & apps tier(run).
sh $ORACLE_HOME/appsutil/scripts/${CONTEXT_NAME}/adautocfg.sh
sh $INST_TOP/admin/scripts/adautocfg.sh
I. Apply R12.2.6 Release updatePack
. /u01/applmgr/TEST/EBSapps.env run
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
adop phase=apply apply_mode=downtime patches=21900901
J. Start all application tier services on the run file system.
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
K. Perform adop cleanup action
adop phase=cleanup
L. Synchronize file systems
adop phase=fs_clone
Once we have installed R12.2.0,Please follow below steps to upgrade to R12.2.6.
HOW TO UPGRADE FROM R12.2.0 TO R12.2.6:
A) Upgrade Database to 11.2.0.4 or higher --> Our version is 12.1.0.2
B) Fusion Middleware Technology Stack (FMW) 11.1.1.7 (11gR1 PS6) or higher.
Note: We used StartCD 12.2.0.51. StartCD 51 installs Oracle Fusion Middleware 11g PS7 (11.1.1.9.0) & database 12.1.0.2.
C) Apply Required Database Patches
i) Before you apply the AD and TXK Delta 10 release update packs (RUPs), you must run the latest version (available via Patch 17537119) of the EBS Technology Codelevel Checker (ETCC). Use the command checkDBpatch.sh (on UNIX) or checkDBpatch.cmd (on Windows).
ii) Check that all the required database patches have been applied.To learn more about the prerequisite database patches needed for applying the Delta 8 RUPs, refer My Oracle Knowledge Document 1594274.1, Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes.
Note:Ensure all the required ETCC database objects will be found by the Delta 8 RUP installation process. This means that even if you already have all the required database patches installed, you must still run the latest version of ETCC on your database.
RUN ETCC on DB Tier:
mkdir $ORACLE_HOME/appsutil/etcc
cd $ORACLE_HOME/appsutil/etcc
unzip /home/oracle/1226/ETCC/p17537119_R12_GENERIC.zip
./checkDBpatch.sh contextfile=/u01/oracle/TEST/12.1.0/appsutil/TEST_acsebs.xml
It will give us list of patches which needs to be applied before we proceed with upgrade. Instead of downloading individual patches
you can download Patch 26781264 [EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR AUG 2017] which contains all the required patches.
Download and unzip under $ORACLE_HOME/appsutil/etcc. then apply the required patches after bringing down db & application.
D) Set Database Parameter
Oracle Database 12c Release 1 uses cost based optimization. If you are using Oracle Database 12.1.0.2, the following optimizerparameter should always be set to 'false'. This setting should be completed before proceeding with the next steps and should not be changed thereafter. Set it in spfile or pfile and bounce the database.
optimizer_adaptive_features=false
E) Apply Consolidated Seed Table Upgrade Patch
Note: This step is applicable only for new installation customers and customers upgrading from Oracle E-Business Suite Release 12.2.2 to Release 12.2.6.
Note: If the Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD 12.2.0.51 (Patch22066363), you must apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 by merging with Patch21900871:12.2.0 on the run file system using adop hotpatch mode.
sh $ADMIN_SCRIPTS_HOME/adstpall.sh
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes patchtop=/1226/SEED_TABLE_CUP
F) Apply latest AD & TXK Patches:
i) Run ETCC tool on application Tier and apply missing patches..It will list the patches for below components.
Oracle Forms and Reports 10.1.2.3.0
Oracle Fusion Middleware (FMW) - Web Tier.
Oracle Fusion Middleware (FMW) - oracle_common
Oracle WebLogic Server (WLS)
We have one consolidated patch which will have all the mandatory patches. Apply the patches listed by ETCC.
Patch 26328262 - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2017
a) Apply patches on 10.1.2 Home.by default our env will be pointing to 10.1.2 ORACLE_HOME.NO need to change anything.
b) To Apply Patch in webtier home ,Set env variables below.
export ORACLE_HOME=$IAS_ORACLE_HOME;
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
c)To apply patch in Fusion middleware ORACLE_COMMON home,Set env variables below
export ORACLE_HOME=$FMW_HOME/oracle_common;
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
d)Apply weblogic patches
unzip patch $FMW_HOME/utils/bsu/cache_dir
cd $FMW_HOME/utils/bsu
./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=K25M -prod_dir=$FMW_HOME/wlserver_10.3
If there are any conflict ,You can use below syntax to remove conflict patches.
./bsu.sh -remove -patchlist=1LRI,2GYW,CW9T,VKXF,BLTG -prod_dir=$FMW_HOME/wlserver_10.3
iii) Apply latest 25820806 (R12.AD.C.Delta.10) and Patch 26720905:R12.AD.C in hotpatch mode.
Execute adgrants by following the instructions in the readme of Patch 25820806 (R12.AD.C.Delta.10).
adgrants.sql file in database tier before applying this patch
If Patch 25525148 (Rapid Install consolidated one-off bundle on top of startCD51) was not used while installing your Oracle E-Business Suite Release 12.2 system, apply the patches in the following order:
a. Apply Patch 25820806 (R12.AD.C.Delta.10)
adop phase=apply patches=25820806 hotpatch=yes patchtop=/shared/custom/1226/AD_TXK_LATEST workers=8
b. Apply Patch 26720905:R12.AD.C
adop phase=apply patches=26720905 hotpatch=yes patchtop=/shared/custom/1226/AD_TXK_LATEST workers=4
C. Apply AD crticical patches.
adop phase=apply patches=24591000,26482811 hotpatch=yes merge=yes patchtop=/shared/custom/1226/AD_TXK_LATEST workers=4
D. Apply TXK Delta 10 patch
adop phase=apply patches=25828573 hotpatch=yes patchtop=/shared/custom/1226/AD_TXK_LATEST workers=4
E.Apply TXK critical patches.
adop phase=apply patches=26400116,26720231,25994411 hotpatch=yes merge=yes patchtop=/shared/custom/1226/AD_TXK_LATEST workers=4
F. Run Middle Tier EBS Technology Codelevel Checker (MT-ETCC)
Execute the Middle Tier EBS Technology Codelevel Checker (MT-ETCC) utility checkMTpatch.sh
G. Stop Oracle WebLogic Server's Admin Server and Node Manager services.
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
H. Update database tier with the latest patches
i) Source Run File sysem.
ii) perl $AD_TOP/bin/admkappsutil.pl
iii) On the database tier (as the ORACLE user):
a. Source the environment for RDBMS ORACLE_HOME.
b.Copy or FTP the appsutil.zip(appstier) file to <RDBMS ORACLE_HOME>.
c.cd $ORACLE_HOME; cp -r appsutil appsutil.bkup.nov14;unzip -o appsutil.zip
d. Run Autoconfig on db & apps tier(run).
sh $ORACLE_HOME/appsutil/scripts/${CONTEXT_NAME}/adautocfg.sh
sh $INST_TOP/admin/scripts/adautocfg.sh
I. Apply R12.2.6 Release updatePack
. /u01/applmgr/TEST/EBSapps.env run
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop
sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop
adop phase=apply apply_mode=downtime patches=21900901
J. Start all application tier services on the run file system.
sh $ADMIN_SCRIPTS_HOME/adstrtal.sh
K. Perform adop cleanup action
adop phase=cleanup
L. Synchronize file systems
adop phase=fs_clone
No comments:
Post a Comment