References Document 1926201.1, Interoperability Notes Oracle EBS 12.2 with Oracle Database 12c Release 1 Document 1623879.1, Interoperability Notes E-Business Suite Release 12.2 with Database 11g Release 2 Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1) Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1) Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1) http://www.theappsarchitects.com/planning-to-install-to-r12-2-5-fresh-instance-steps-are-here/ https://www.toadworld.com/platforms/oracle/b/weblog/archive/2014/12/15/12cr1-upgrade-in-oracle-applications-ebs-r12-2 http://balaoracledba.com/2014/10/ ------------------------------ Database Tier patches ----------------------------- Step-1 -> ETCC Check Note 1594274.1 Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes You need to run codelevel checker utility checkDBpatch.sh –For Database Patches checkMTpatch.sh –For MiddleTier Patches p17537119_R12_GENERIC.zip - ETCC patch utility ./checkDBpatch.sh ------------------------------------------------------------------------------- Oracle Database Release 12.1.0.2 (No PSU applied) ------------------------------------------------------------------------------- Patch 23595848 - Filename: p23595848_121020_Linux-x86-64.zip Patch 18793246 - Filename: p18793246_121020_Generic.zip Patch 26043804 - Filename: p26043804_121020_Linux-x86-64.zip Patch 19591608 - Filename: p19591608_121020_Linux-x86-64.zip Patch 20766180 - Filename: p20766180_121020_Generic.zip Patch 25967939 - Filename: p25967939_121020_Linux-x86-64.zip Patch 22098146 - Filename: p22098146_121020_Linux-x86-64.zip Patch 21321429 - Filename: p21321429_121020_Generic.zip Patch 21864513 - Filename: p21864513_121020_Linux-x86-64.zip Patch 21904072 - Filename: p21904072_121020_Linux-x86-64.zip Patch 21967332 - Filename: p21967332_121020_Linux-x86-64.zip Patch 22338374 - Filename: p22338374_121020_Linux-x86-64.zip Patch 22496904 - Filename: p22496904_121020_Linux-x86-64.zip Patch 22731026 - Filename: p22731026_121020_Generic.zip Patch 23089357 - Filename: p23089357_121020_Linux-x86-64.zip Patch 24560906 - Filename: p24560906_121020_Linux-x86-64.zip Patch 25643931 - Filename: p25643931_121020_Linux-x86-64.zip A consolidated zip file with the required patches for Database release 12.1.0.2.0 is available on My Oracle Support via: Patch 26781264 [12.1.0.2.0 version] - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR AUG 2017 -------------- unzip p26781264_121020_Linux-x86-64.zip cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/database/12.1.0.2 1> Patch 23595848 cd 23595848 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply $ORACLE_HOME/OPatch/opatch lsinventory |grep 23595848 2> patch 18793246 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 3>26043804 cd 26043804 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 4> 19591608 cd 19591608 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 5> 20766180 cd 20766180 6> 25967939 cd 25967939 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 7> 22098146 cd 22098146 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 8> 21321429 cd 21321429 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 9> 21864513 cd 21864513 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 10> 21904072 cd 21904072 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 11> 21967332 cd 21967332 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Conflicts/Supersets for each patch are: Patch : 21967332 Conflict with 18893947 Conflict details: /d01/oracle/PROD/12.1.0/lib/libgeneric12.a:qcdo.o Following patches have conflicts: [ 18893947 21967332 ] $ORACLE_HOME/OPatch/opatch rollback -id 18893947 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 12> 22338374 22338374 cd 22338374 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Patch : 22338374 Conflict with 21188532 Conflict details: /d01/oracle/PROD/12.1.0/lib/libserver12.a:kkqvm.o $ORACLE_HOME/OPatch/opatch rollback -id 21188532 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 13> 22496904 cd 22496904 $ORACLE_HOME/OPatch/opatch apply 12> 22731026 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ cd 22731026 $ORACLE_HOME/OPatch/opatch apply 13> 23089357 cd 23089357 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply 14> 24560906 cd 24560906 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ cd 24560906 $ORACLE_HOME/OPatch/opatch apply 15> 25643931 cd 25643931 $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ $ORACLE_HOME/OPatch/opatch apply Start the listener and database Note: Perform any post install patches. Post install steps cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/database/12.1.0.2 1> cd 23595848 (IV) Postinstallation ---------------------- The following steps load modified SQL files into the database. 1. Navigate to the /OPatch directory: $ cd $ORACLE_HOME/OPatch 2. Install the SQL portion of the patch by running the following command: $ datapatch $ORACLE_HOME/OPatch/datapatch SQL Patching tool version 12.2.0.0.0 on Sun Oct 29 05:58:05 2017 Copyright (c) 2014, Oracle. All rights reserved. Connecting to database...OK Determining current state...done Adding patches to installation queue and performing prereq checks...done Installation queue: The following patches will be rolled back: 20476776 () The following patches will be applied: 18793246 () 21321429 () 22098146 () 22731026 () 23595848 () http://www.carajandb.com/en/blogs/blog-jahrends-en/232-oracle-12c-datapatch-en Database 12c Post Patch SQL Automation (Doc ID 1585822.1) catcon: ALL catcon-related output will be written to /tmp/sqlpatch_catcon__catcon_7456.lst catcon: See /tmp/sqlpatch_catcon_*.log files for output generated by scripts catcon: See /tmp/sqlpatch_catcon__*.lst files for spool files, if any Installing patches... Patch installation complete. Total patches installed: 6 Validating logfiles...done SQL Patching tool complete on Sun Oct 29 06:08:40 2017 - ONLY ONCE WE NEED TO RUN 2> cd 22098146 (III) Postinstallation --------------------- 1. Navigate to the /OPatch directory: $ cd /OPatch 2. Install the SQL portion of the patch by running the following command: $ datapatch 3> cd 21321429 (III) Postinstallation --------------------- 1. Navigate to the /OPatch directory: $ cd /OPatch 2. Install the SQL portion of the patch by running the following command: $ datapatch Note: For a RAC environment, perform these steps on only one node. cd 22731026 (V) Postdeinstallation ----------------------- 1. Navigate to the /OPatch directory: $ cd /OPatch 2. Deinstall the SQL portion of the patch by running the following command: $ datapatch Note: For a RAC environment, perform these steps on only one node. -------------------------------------------------------------------------------- Run ETCC once more ./checkDBpatch_20742.log Bugfix XML file version: 120.0.12020000.33 This file will be used for identifying missing bugfixes. Mapping XML file version: 120.0.12020000.6 This file will be used for mapping bugfixes to patches. [WARNING] DB-ETCC: Bugfix XML file (./txk_R1220_DB_base_bugs.xml) in current directory is more than 30 days old. Check if a newer version is available in patch 17537119. Identifying database release. Database release set to 12.1.0.2. Connecting to database. Database connection successful. Database PROD is in READ WRITE mode. Identifying APPS and APPLSYS schema names. - APPS schema : APPS - APPLSYS schema : APPLSYS Checking for DB-ETCC results table. Table to store DB-ETCC results already exists in the database. Checking if InMemory option is enabled. InMemory option is not enabled in the Database. Checking Bugfix XML file for 12.1.0.2 Obtained list of bugfixes to be applied and the list to be rolled back. Now checking Database ORACLE_HOME. The opatch utility is version 12.1.0.1.10. DB-ETCC is compatible with this opatch version. Found patch records in the inventory. Checking Mapping XML file for 12.1.0.2 All the required one-off bugfixes are present in Database ORACLE_HOME. Stored Technology Codelevel Checker results in the database PROD successfully. Finished prerequisite patch testing : Thu Jan 26 03:34:46 EST 2017 Log file for this session: ./checkDBpatch_20742.log =============================================================================== ------------------------------ Middle Tier patches ----------------------------- ETCC ./checkMTpatch.sh ------------------------------------------------------------------------------- Oracle Forms and Reports 10.1.2.3.0 ------------------------------------------------------------------------------- Patch 25768948 - Filename: p25768948_101232_LINUX.zip ------------------------------------------------------------------------------- Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0 ------------------------------------------------------------------------------- Patch 22288381 - Filename: p22288381_111190_Generic.zip ------------------------------------------------------------------------------- Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0 ------------------------------------------------------------------------------- Patch 9905685 - Filename: p9905685_111190_Generic.zip Patch 17428617 - Filename: p17428617_111190_Generic.zip Patch 21366277 - Filename: p21366277_111190_Generic.zip Patch 21628307 - Filename: p21628307_111190_Generic.zip Patch 24606362 - Filename: p24606362_111190_Generic.zip Patch 24843064 - Filename: p24843064_111190_Generic.zip ------------------------------------------------------------------------------- Oracle WebLogic Server (WLS) 10.3.6.0.7 ------------------------------------------------------------------------------- Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018] - Filename: p23743997_1036_Generic.zip Apply the required patches and rerun this script. +-----------------------------------------------------------------------------+ A consolidated zip file with the required application tier patches is available on My Oracle Support via: Patch 26328262 - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2017 +-----------------------------------------------------------------------------+ [WARNING] Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018] is missing. =============================================================================== *********************************** FORMS PATCH ******************************* cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/forms/10.1.2.3.0 cd 25768948 $ORACLE_HOME/OPatch/opatch apply -- pending ------------------------------------------------------------------------------- Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0 ------------------------------------------------------------------------------- Patch 22288381 - Filename: p22288381_111190_Generic.zip 22288381 cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/webtier/11.1.1.9.0/22288381 export ORACLE_HOME=/d01/oracle/PROD/fs1/FMW_Home/webtier $ORACLE_HOME/OPatch/opatch lsinventory $ORACLE_HOME/OPatch/opatch apply ------------------------------------------------------------------------------- Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0 ------------------------------------------------------------------------------- Patch 9905685 - Filename: p9905685_111190_Generic.zip Patch 17428617 - Filename: p17428617_111190_Generic.zip Patch 21366277 - Filename: p21366277_111190_Generic.zip Patch 21628307 - Filename: p21628307_111190_Generic.zip Patch 24606362 - Filename: p24606362_111190_Generic.zip Patch 24843064 - Filename: p24843064_111190_Generic.zip export ORACLE_HOME=/d01/oracle/PROD/fs1/FMW_Home/oracle_common Patch 9905685 export ORACLE_HOME=/d01/oracle/PROD/fs1/FMW_Home/oracle_common cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/oracle_common/11.1.1.9.0/9905685/oui $ORACLE_HOME/OPatch/opatch apply cd 17428617 cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/oracle_common/11.1.1.9.0/17428617 $ORACLE_HOME/OPatch/opatch apply export ORACLE_HOME=/d01/oracle/PROD/fs1/FMW_Home/oracle_common cd 21366277 cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/oracle_common/11.1.1.9.0/21366277 $ORACLE_HOME/OPatch/opatch apply cd 21628307 cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/oracle_common/11.1.1.9.0/21628307 $ORACLE_HOME/OPatch/opatch apply cd 24606362 cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/oracle_common/11.1.1.9.0/24606362 $ORACLE_HOME/OPatch/opatch apply cd 24843064 cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/oracle_common/11.1.1.9.0/24843064/oui $ORACLE_HOME/OPatch/opatch apply 20780171 ------------------------------------------------------------------------------- Oracle WebLogic Server (WLS) 10.3.6.0.7 ------------------------------------------------------------------------------- Patch 20780171 [SU Patch [EJUW]: WLS PSU 10.3.6.0.12] - Filename: p20780171_1036_Generic.zip ------------------------------------------------------------------------------- Oracle WebLogic Server (WLS) 10.3.6.0.7 ------------------------------------------------------------------------------- Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018] - Filename: p23743997_1036_Generic.zip cd /home/oracle/patches cp p23743997_1036_Generic.zip /d01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir/ cd /d01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir/ unzip p23743997_1036_Generic.zip export FMW_HOME=/d01/oracle/PROD/fs1/FMW_Home ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=K25M -prod_dir=$FMW_HOME/wlserver_10.3 Checking for conflicts.... Conflict(s) detected - resolve conflict condition and execute patch installation again Conflict condition details follow: Patch K25M is mutually exclusive and cannot coexist with patch(es): CW9T,VKXF,FCX7,Y5AP,1LRI,2GYW,BLTG cd $FMW_HOME/utils/bsu ./bsu.sh -remove -patchlist=CW9T -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=VKXF -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=1LRI -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=CW9T -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=2GYW -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=BLTG -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=FCX7 -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=Y5AP -prod_dir=$FMW_HOME/wlserver_10.3 export FMW_HOME=/d01/oracle/PROD/fs1/FMW_Home ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=K25M -prod_dir=$FMW_HOME/wlserver_10.3 Checking for conflicts.... No conflict(s) detected Installing Patch ID: K25M.. Result: Success ------------------------------------------------------------------------------- Oracle WebLogic Server (WLS) 10.3.6.0.161018 ------------------------------------------------------------------------------- Patch 24608998 [SU Patch [QMJP]] - Filename: p24608998_10360161018_Generic.zip Patch 13729611 [SU Patch [Z9PC]] - Filename: p13729611_10360161018_Generic.zip Patch 13964737 [SU Patch [YVDZ] Required for FMW 11.1.1.9] - Filename: p13964737_1036_Generic.zip Patch 17319481 [SU Patch [9KCT]] - Filename: p17319481_10360161018_Generic.zip Patch 19259028 [SU Patch [KRDE]] - Filename: p19259028_10360161018_Generic.zip Patch 25804598 [SU Patch [EQDE]] - Filename: p25804598_10360161018_Generic.zip Patch 22323006 [SU Patch [DI8E]] - Filename: p22323006_1036_Generic.zip Patch 25333306 [SU Patch [SUY4]] - Filename: p25333306_1036_Generic.zip cd /home/oracle/patches/etcc-bundle/LINUX_X86-64/wls/10.3.6.0.161018 /d01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir/ cp p24608998_10360161018_Generic.zip p17319481_10360161018_Generic.zip p13729611_10360161018_Generic.zip p13964737_1036_Generic.zip p19259028_10360161018_Generic.zip p25804598_10360161018_Generic.zip p22323006_1036_Generic.zip p25333306_1036_Generic.zip $FMW_HOME/utils/bsu/cache_dir copy patches to below folder Exception in thread "main" java.lang.OutOfMemoryError: GC overhead limit exceeded Follow these steps to resolve the issue: Go to $FMW_HOME/utils/bsu Edit bsu.sh (for UNIX) or bsu.cmd (for Windows). Here you will find the following: MEM_ARGS="-Xms256m -Xmx512m" Increase these values as needed: for example, to "-Xms2048m -Xmx2048m". cd $FMW_HOME/utils/bsu/cache_dir cd $FMW_HOME/utils/bsu export FMW_HOME=/d01/oracle/PROD/fs1/FMW_Home ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=QMJP -prod_dir=$FMW_HOME/wlserver_10.3 export FMW_HOME=/d01/oracle/PROD/fs1/FMW_Home ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=Z9PC -prod_dir=$FMW_HOME/wlserver_10.3 export FMW_HOME=/d01/oracle/PROD/fs1/FMW_Home ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=YVDZ -prod_dir=$FMW_HOME/wlserver_10.3 export FMW_HOME=/d01/oracle/PROD/fs1/FMW_Home ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=9KCT -prod_dir=$FMW_HOME/wlserver_10.3 export FMW_HOME=/d01/oracle/PROD/fs1/FMW_Home ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=KRDE -prod_dir=$FMW_HOME/wlserver_10.3 export FMW_HOME=/d01/oracle/PROD/fs1/FMW_Home ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=EQDE -prod_dir=$FMW_HOME/wlserver_10.3 export FMW_HOME=/d01/oracle/PROD/fs1/FMW_Home ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=DI8E -prod_dir=$FMW_HOME/wlserver_10.3 ./bsu.sh -remove -patchlist=CIH8 -prod_dir=$FMW_HOME/wlserver_10.3 export FMW_HOME=/d01/oracle/PROD/fs1/FMW_Home ./bsu.sh -install -patch_download_dir=$FMW_HOME/utils/bsu/cache_dir -patchlist=SUY4 -prod_dir=$FMW_HOME/wlserver_10.3 --------------- ./checkMTpatch.sh +===============================================================+ | Copyright (c) 2005, 2016 Oracle and/or its affiliates. | | All rights reserved. | | Oracle E-Business Suite Release 12.2 | | Middle Tier Technology Codelevel Checker | +===============================================================+ Using context file from currently set applications environment: /d01/oracle/PROD/fs1/inst/apps/PROD_erp/appl/admin/PROD_erp.xml Starting Middle Tier Technology Codelevel Checker, Version: 120.0.12020000.25. Fri Mar 4 19:11:51 EST 2016 Log file for this session: /home/oracle/patches/checkMTpatch_806.log Bugfix XML file version: 120.0.12020000.21 This file will be used for identifying missing bugfixes. Mapping XML file version: 120.0.12020000.1 This file will be used for mapping bugfixes to patches. Checking for prerequisite bugfixes in File Edition: run Enter the password for the APPS user: Connecting to database. Database connection successful. The installed AD.C codelevel does not support storing the results in the database. =============================================================================== Oracle Forms and Reports =============================================================================== Now examining product Oracle Forms and Reports. Oracle Home = /d01/oracle/PROD/fs1/EBSapps/10.1.2. Product version = 10.1.2.3.0. Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0. All required bugfixes are present for Oracle Forms and Reports. Checking required bugfixes for RSF within Forms 10.1.0.5.0. All required bugfixes are present for RSF within Forms. =============================================================================== Oracle Fusion Middleware (FMW) - Web Tier =============================================================================== Now examining product Oracle Fusion Middleware (FMW) - Web Tier. Oracle Home = /d01/oracle/PROD/fs1/FMW_Home/webtier. Product Version = 11.1.1.9.0 Checking required bugfixes for FMW - Web Tier 11.1.1.9.0. All required bugfixes are present for FMW - Web Tier. Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0. All required bugfixes are present for RSF within FMW Web tier. =============================================================================== Oracle Fusion Middleware (FMW) - oracle_common =============================================================================== Now examining product Oracle Fusion Middleware (FMW) - oracle_common. Oracle Home = /d01/oracle/PROD/fs1/FMW_Home/oracle_common. Product Version = 11.1.1.9.0 Checking required bugfixes for FMW - oracle common 11.1.1.9.0. All required bugfixes are present for FMW - oracle common. =============================================================================== Oracle WebLogic Server (WLS) =============================================================================== Now examining product Oracle WebLogic Server (WLS). Oracle Home = /d01/oracle/PROD/fs1/FMW_Home/wlserver_10.3. Product Version = 10.3.6.0.12 Note that for Oracle WebLogic Server, patches rather than bugfixes are verified. Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.12. All required patches are present for Oracle WebLogic Server (WLS). =============================================================================== All required one-offs are confirmed as present. Finished checking prerequisite patches for File Edition: run. Fri Mar 4 19:12:06 EST 2016 Log file for this session: /home/oracle/patches/checkMTpatch_806.log =============================================================================== --------------------- /software/R12.2/R1226_latest/TXK Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1) Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1) Set Database Parameter (Conditional) Oracle Database 12c Release 1 uses cost based optimization. If you are using Oracle Database 12.1.0.2, the following optimizer parameter should always be set to 'false'. This setting should be completed before proceeding with the next steps and should not be changed thereafter. optimizer_adaptive_features=false You can verify the parameter was set correctly by running the following command, which should return the value FALSE: SQL>show parameter optimizer_adaptive_features Section 5: Apply Consolidated Seed Table Upgrade Patch (Required) 17204589 • Stop all Application tier services on the run file system. sh $ADMIN_SCRIPTS_HOME/adstpall.sh Start up only the Weblogic AdminServer service on the run file system. sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start Apply the consolidated seed table upgrade Patch 17204589:12.2.0 on the run file system using adop hotpatch mode. Note: If the Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD 12.2.0.51 (Patch 22066363), you must apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 by merging with Patch 21900871:12.2.0 on the run file system using adop hotpatch mode. $ adop phase=apply patches=17204589,21900871 merge=yes hotpatch=yes • Start up all Application tier services sh $ADMIN_SCRIPTS_HOME/adstrtal.sh Step-2 -> 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 patchtop=/home/oracle/patches/consolidated sh $ADMIN_SCRIPTS_HOME/adstrtal.sh -------------------------------------------------------- We are having issues applying Delta 10 patches, so ware applying Delta 8 patches -- Copy the adgrants from the patch to the database tier Patch 21841299 (R12.AD.C.Delta.8) Patch 21830810 (R12.TXK.C.Delta.8) sqlplus "/as sysdba" @adgrants.sql APPS adop phase=apply patches=21841299 hotpatch=yes patchtop=/home/oracle/patches/TXK_8 adop phase=apply patches=21830810 hotpatch=yes patchtop=/home/oracle/patches/TXK_8 EBSapps.env will be created ... ------------------------------------------- Apply the R12.AD.C.Delta.10 and R12.TXK.C.Delta.10 Release Update Packs Unzip patches and run adgrants. Download and unzip the following patches: Patch 25820806 (R12.AD.C.Delta.10) Patch 25828573 (R12.TXK.C.Delta.10) Patch 26720905:R12.AD.C ADOP Exiting With Status = 9 (Fail) ORA-04043 On ADOP_VALID_NODES Table (Doc ID 2230021.1) Unable to find appltop_id for host erp in database ADOP Fails With Error Unable to Find Appltop_id (Doc ID 1907419.1) -- DONT APPLY DELTA 10 PATCHES, APPLY AFTER DELTA 8 PATCHES --- getting below error -- AutoPatch error: Error while inserting row in AD_TIMESTAMPS AutoPatch error: ORA-01400: cannot insert NULL into ("APPLSYS"."AD_TIMESTAMPS"."ATTRIBUTE") AutoPatch error: aijhip(): Error calling aijmgrInsertHangingRowInAdTmStmp() ----------------------- solution http://www.databaseusers.com/article/6024215/Error+applying+R12.AD.C.Delta.8+(21841299) I dug around and found two patches that helped me get past the errors trying to apply Delta 8. It's confusing so there is probably a simpler way but here is what I did. 1. Abandon the Delta 8 patch and get back to a clean file system.2. Apply the Delta 7 patches3. Apply 221238184. Apply 22700342 Patch 22700342 fixes bug 22664007 - AD_FILE_UTIL FAILED WITH ORA-04068 DURING PATCHING. After applying those patches I was then able to successfully apply the Delta 8 patches.The confusing part is it seems you need to apply the Delta 7 patches plus to two extra patches before you can apply the Delta 8 patches. Of course this shouldn't need to be done since the Delta patches are cumulative, but nevertheless, that was the only way I could get it to work. adop phase=apply patches=25828573 hotpatch=yes run adgrants from 25820806 adop phase=apply patches=25820806,26720905 merge=yes patchtop=/home/oracle/patches/TXK_10 hotpatch=yes select name,APPLICATIONS_SYSTEM_NAME from AD_APPL_TOPS; adop phase=apply patches=25828573 patchtop=/home/oracle/patches/TXK hotpatch=yes As per subsection 4.1 Critical AD Patches adop phase=apply patches=24591000,26482811,26400116,26720231,25994411 patchtop=/home/oracle/patches/TXK_10 hotpatch=yes Stop the Oracle WebLogic Server Admin Server on the run file system. sh adadminsrvctl.sh stop adop phase=apply apply_mode=downtime patches=24690690 patchtop=/d01/oracle/software/patch/R1227 workers=8 adop phase=cleanup adop phase=fs_clone adop phase=apply patches=24690800 hotpatch=yes patchtop=/home/oracle/patches/TXK_10 run preclone on db tier and appstier Take a backup