6.1 Apply Required Database Patches
Download the latest ETCC patch (available via Patch 17537119) of the EBS Technology Code level Checker (ETCC). Use the command checkDBpatch.sh and apply all recommended patches. Please note ETCC patch keeps getting updated, so the patches it recommends might vary from time to time
6.1.1 Source DB environment and run the below script.
[oracle@fbsebs etcc]$ ls -alt
total 124
drwxrwxrwx. 2 oracle oinstall 39 Dec 14 13:39 .
-rw-r--r--. 1 oracle oinstall 126868 Dec 14 13:35 p17537119_R12_GENERIC.zip
drwxrwxrwx. 5 oracle dba 41 Dec 7 11:59 ..[[oracle@fbsebs etcc]$ ls
p17537119_R12_GENERIC.zip
[oracle@fbsebs etcc]$ unzip p17537119_R12_GENERIC.zip
Archive: p17537119_R12_GENERIC.zip
inflating: checkDBpatch.cmd
inflating: checkMTpatch.cmd
inflating: checkMTpatch.sh
creating: db/
creating: db/cloud/
inflating: db/cloud/txk_R1220_EXABM_mappings.xml
inflating: db/cloud/txk_R1220_DBCS_base_bugs.xml
inflating: db/cloud/txk_R1220_DBCS_RAC_base_bugs.xml
inflating: db/cloud/txk_R1220_VMDB_RAC_base_bugs.xml
inflating: db/cloud/txk_R1220_EXACS_mappings.xml
inflating: db/cloud/txk_R1220_EXACS_base_bugs.xml
inflating: db/cloud/txk_R1220_DBCS_RAC_mappings.xml
inflating: db/cloud/txk_R1220_DBSI_base_bugs.xml
inflating: db/cloud/txk_R1220_VMDB_RAC_mappings.xml
inflating: db/cloud/txk_R1220_DBSI_mappings.xml
inflating: db/cloud/txk_R1220_DBCS_mappings.xml
inflating: db/cloud/txk_R1220_EXABM_base_bugs.xml
creating: db/onprem/
inflating: db/onprem/txk_R1220_DB_mappings.xml
inflating: db/onprem/txk_R1220_DB_base_bugs.xml
inflating: db/onprem/txk_R1220_GRID_base_bugs.xml
creating: mw/
inflating: mw/txk_R1220_MT_base_bugs.xml
inflating: mw/txk_R1220_MT_mappings.xml
inflating: README.txt
inflating: db/cloud/txk_R1220_EXACC_base_bugs.xml
inflating: db/cloud/txk_R1220_EXACC_mappings.xml
inflating: db/cloud/txk_R1220_ENTDBV_RAC_GOV_base_bugs.xml
inflating: db/cloud/txk_R1220_ENTDBV_RAC_GOV_mappings.xml
inflating: db/cloud/txk_R1220_ENTDBV_SI_GOV_base_bugs.xml
inflating: db/cloud/txk_R1220_ENTDBV_SI_GOV_mappings.xml
inflating: db/cloud/txk_R1220_EXADBD_GOV_base_bugs.xml
inflating: db/cloud/txk_R1220_EXADBD_GOV_mappings.xml
inflating: checkDBpatch.sh [oracle@fbsebs etcc]$ ls -ltr
total 312
drwxr-xr-x. 4 oracle oinstall 33 May 8 2018 db
drwxr-xr-x. 2 oracle oinstall 73 Jan 13 2023 mw
-rwxr-xr-x. 1 oracle oinstall 55333 Jan 17 2024 checkDBpatch.cmd
-rwxrwxrwx. 1 oracle oinstall 52450 Apr 12 2024 checkMTpatch.sh
-rw-------. 1 oracle oinstall 31993 Apr 30 2024 README.txt
-rwxr-xr-x. 1 oracle oinstall 116061 May 22 2024 checkDBpatch.sh
-rwxr-xr-x. 1 oracle oinstall 56282 May 28 2024 checkMTpatch.cmd
drwxr-xr-x. 2 oracle oinstall 68 Dec 14 13:28 log
[oracle@ebstest ~]$ cd /u01/patches/etcc/
[oracle@ebstest etcc]$ ./checkDBpatch.sh
+===============================================================+
| Copyright (c) 2005, 2025 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Database EBS Technology Codelevel Checker |
+===============================================================+
Database environment not set, going to check for GridHome.
Oracle Grid Infrastructure not identified.
Database environment not set and no Grid home found, so context file must be specified.
Enter full path to database context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml
Validating context file: /u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml
Using context file from user input:
/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml
Starting Database EBS Technology Codelevel Checker, Version 120.137
Sun Jul 20 09:20:34 EAT 2025
Log file for this session:
/u01/patches/etcc/log/checkDBpatch_320791.log
Identifying database release.
Database release set to 19.27.0.0.
Multitenant identified.
- Container database (CDB) identified via s_cdb_name is fbscdb
- Pluggable database (PDB) identified via s_pdb_name is FBS
Connecting to database.
Database connection successful.
Database FBS is in READ WRITE mode.
Identifying APPS and APPLSYS schema names.
- APPS schema: APPS
- APPLSYS schema: APPLSYS
Checking for existence DB-ETCC results table.
Table to store DB-ETCC results already exists in the database.
Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml: 120.0.12020000.93
This file will be used for identifying missing bugfixes.
Mapping file ./db/onprem/txk_R1220_DB_mappings.xml: 120.0.12020000.70
This file will be used for mapping bugfixes to patches.
[WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is
more than 30 days old.
+---------------------------------------------------------------------------------------+
Always use the latest version of ETCC available in patch 17537119,
as new bugfixes will not be checked by older versions of the utility.
You should apply the latest recommended RU, BP, or PSU as appropriate.
+---------------------------------------------------------------------------------------+
Identified database DST version: 44
Checking Bugfix XML file for tag 19.27.0.0_RU.
Obtained list of bugfixes to be applied and list to be rolled back.
Validating OPatch version:
The OPatch utility is version 12.2.0.1.45.
DB-ETCC is compatible with this OPatch version.
Checking for applied patch history:
Found patch history in the inventory.
Checking mapping XML file for tag 19.27.0.0.250415DBRU.
All the required one-off bugfixes are present in database ORACLE_HOME.
+---------------------------------------------------------------------------------------+
Finished checking fixes for database FBS: Sun Jul 20 09:20:54 EAT 2025
Log file for this session:
/u01/patches/etcc/log/checkDBpatch_320791.log
This file should be reviewed for errors after the ETCC run.
=========================================================================================
6.1.2 As per the reports, Download and apply the patches mentioned (patch 36925840).
Make sure Database and application services are down if any patches are required
6.1.3 Apply all patches and once applied start the DB and run the below command.
[oracle@fbsebs etcc]$ cd $ORACLE_HOME/OPatch
[oracle@fbsebs OPatch]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Sat Dec 14 14:26:37 2024
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 1073741824 bytes
Fixed Size 2932632 bytes
Variable Size 650117224 bytes
Database Buffers 406847488 bytes
Redo Buffers 13844480 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@fbsebs OPatch]$ ./datapatche Database and re-run the checkDBpatch.sh again to make sure all patches at DB level are applied.6.2 Set the database parameters
_disable_actualization_for_grant=true
SQL> alter system set "_disable_actualization_for_grant"=true; System altered. SQL> show parameter _disable_actualization_for_grant NAME TYPE VALUE------------------------------------ ----------- ------------------------------_disable_actualization_for_grant boolean TRUE6.3 Apply Consolidated Seed Table Upgrade Patch (Required)
Note: You can skip this step if you have upgraded to Release 12.2.0 using the latest Consolidated Upgrade Patch 34754463:12.2.0 (CUP15) or earlier Consolidated Upgrade Patches if not applied on section 5.1.3
Patch 28853097:12.2.0 (CUP10)
Patch 26924710:12.2.0 (CUP9)
Patch 24690520:12.2.0 (CUP8)
Stop all application tier services on the run file system.
sh $ADMIN_SCRIPTS_HOME/adstpall.sh
Start-up only the Oracle Weblogic Admin Server on the run file system.
$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
Apply the consolidated seed table upgrade Patch 34754463:12.2.0 on the run file system using adop hotpatch mode.
[applmgr@fbsebs op]$ adop phase=apply patches=34754463 hotpatch=yesValidate the patch is applied successfully and move ahead to the next step.
6.4 Apply the Latest AD and TXK Delta Release Update Packs
The latest RUPs are R12.AD.C.Delta.16 (Patch 36119925) and R12.TXK.C.Delta.16 (Patch 36117775).
Source the run edition environment file.
Start-up only the Oracle Weblogic Admin Server on the run edition application tier file system.
sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start
Execute adgrants by following the instructions in the readme of Patch 36119925, which includes the latest version of adgrants.
connect to the pluggable database
$ export ORACLE_PDB_SID=FBS
36119925/admin-------@$ORACLE_HOME/appsutil/admin/adgrants.sql apps
ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;
ALTER USER SYSTEM IDENTIFIED BY K0Junga#;
ALTER USER EBS_SYSTEM IDENTIFIED BY K0Junga#;
On the run edition application tier file system, apply Patch 36119925 (R12.AD.C.Delta.16) in hotpatch mode.
Note: Do not merge Patch 36119925 with any other patches.
[applmgr@fbsebs patch]$ adop phase=apply patches=36119925 hotpatch=yesNo AD critical patches were available to be applied.
Apply Patch 36117775 (R12.TXK.C.Delta.16) (plus any additional critical patches)
[applmgr@fbsebs patch]$ adop phase=apply patches=36117775 hotpatch=yes[applmgr@fbsebs patch]$ adop phase=apply patches=31904550 merge=yes hotpatch=yes
Verify all patches are applied successfully.
6.5 Apply other important patches
Apply Patch 19259764:R12.FND.C.
[applmgr@fbsebs patch]$ adop phase=apply patches=19259764 hotpatch=yes6.6 Run the Middle Tier EBS Technology Codelevel Checker (MT-ETCC) on the run file system.
Source run file system
EBSapps.env run
Run the MT-ETCC utility checkMTpatch.sh
[applmgr@fbsebs etcc]$ ./checkMTpatch.shAll reported patches can be applied later for Middle Tier application.
6.7 Apply RUP for 12.2.14
Source the run edition applications environment.
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
Apply Oracle E-Business Suite 12.2.14 Release Update Pack Patch 36026788 on the run edition application environment, using downtime mode.
[applmgr@fbsebs patch]$ adop phase=apply apply_mode=downtime patches=36026788It took 14 hrs to complete for me.
6.8 Complete the patching cycle by running the following commands in the order.
. /u01/app/FBS/EBSapps.env run
[applmgr@fbsebs patch]$ adop phase=cleanup
6.9 Apply Oracle E-Business Suite Release 12.2.14 Online Help Patch 36026775 using adop hotpatch mode on the run file system.
Please note new patching cycle session will be opened at this stage. Make sure are tablespaces have sufficient free space.
[applmgr@fbsebs patch]$ adop phase=apply patches=36026775 hotpatch=yes[applmgr@fbsebs patch]$ adop phase=cleanup
6.10 Update Database Tier to Latest Code
On the application tier (as the applmgr user):
Source the run edition environment file.
. <EBS_ROOT>/EBSapps.env run
perl $AD_TOP/bin/admkappsutil.pl
Copy or FTP the appsutil.zip file to <RDBMS ORACLE_HOME>.
Uncompress appsutil.zip, under <RDBMS ORACLE_HOME>.
$ cd <ORACLE_HOME>
$ unzip -o appsutil.zip
Run AutoConfig on <RDBMS ORACLE_HOME>.
[oracle@fbsebs FBS_fbsebs]$ ./adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/app/FBS/db/tech_st/12.1.0/appsutil/log/FBS_fbsebs/12160813/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/app/FBS/db/tech_st/12.1.0
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
Classpath : :/u01/app/FBS/db/tech_st/12.1.0/jdbc/lib/ojdbc6.jar:/u01/app/FBS/db/tech_st/12.1.0/appsutil/java/xmlparserv2.jar:/u01/app/FBS/db/tech_st/12.1.0/appsutil/java:/u01/app/FBS/db/tech_st/12.1.0/jlib/netcfg.jar:/u01/app/FBS/db/tech_st/12.1.0/jlib/ldapjclnt12.jar:/u01/app/FBS/db/tech_st/12.1.0/jlib/orai18n.jar
Using Context file : /u01/app/FBS/db/tech_st/12.1.0/appsutil/FBS_fbsebs.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db121
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed successfully.
Run AutoConfig on the Application run file system.
As the applmgr user, run AutoConfig on all application tier nodes by executing whichever of these commands applies to your system:
UNIX:
$ sh <INST_TOP>/admin/scripts/adautocfg.sh
if you get an ERRORMSG: Directory object does not exist for path : run
perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml -oraclehome=/u01/app/FBS/db/tech_st/19c -outdir=/u01/app/FBS/db/tech_st/19c/appsutil/log -mode=addUtlFileDir
perl /u01/app/FBS/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/app/FBS/db/tech_st/19c/appsutil/FBS_ebstest.xml -oraclehome=/u01/app/FBS/db/tech_st/19c -outdir=/u01/app/FBS/db/tech_st/19c/appsutil/log -mode=syncUtlFileDir
[applmgr@fbsebs ~]$ . /u01/app/FBS/fs1/EBSapps/appl/APPSFBS_fbsebs.env
[applmgr@fbsebs ~]$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/app/FBS/fs1/inst/apps/FBS_fbsebs/admin/log/12160901/adconfig.log
wlsDomainName: EBS_domain_FBS
WLS Domain Name is VALID.
AutoConfig is configuring the Applications environment...
AutoConfig will consider the custom templates if present.
Using CONFIG_HOME location : /u01/app/FBS/fs1/inst/apps/FBS_fbsebs
Classpath : /u01/app/FBS/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/u01/app/FBS/fs1/EBSapps/comn/java/classes
Using Context file : /u01/app/FBS/fs1/inst/apps/FBS_fbsebs/appl/admin/FBS_fbsebs.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring MSC_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
Configuring BIS_TOP.......COMPLETED
Configuring CZ_TOP........COMPLETED
Configuring SHT_TOP.......COMPLETED
Configuring AMS_TOP.......COMPLETED
Configuring CCT_TOP.......COMPLETED
Configuring WSH_TOP.......COMPLETED
Configuring CLN_TOP.......COMPLETED
Configuring OKE_TOP.......COMPLETED
Configuring OKL_TOP.......COMPLETED
Configuring OKS_TOP.......COMPLETED
Configuring CSF_TOP.......COMPLETED
Configuring IBY_TOP.......COMPLETED
Configuring JTF_TOP.......COMPLETED
Configuring MWA_TOP.......COMPLETED
Configuring CN_TOP........COMPLETED
Configuring CSI_TOP.......COMPLETED
Configuring WIP_TOP.......COMPLETED
Configuring CSE_TOP.......COMPLETED
Configuring EAM_TOP.......COMPLETED
Configuring GMF_TOP.......COMPLETED
Configuring PON_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
6.11 Synchronize the file systems.
[applmgr@fbsebs ~]$ adop phase=fs_clone
This completed update to R12.2.14. Verify all services
SQL> select release_name from apps.fnd_product_groups; RELEASE_NAME--------------------------------------------------12.2.14
Known Issues:
https://www.funoracleapps.com/2020/12/the-server-is-not-able-to-service-this.html
References:
Oracle E-Business Suite Release 12.2.10 Readme (Doc ID 2666934.1)
Document 1617461.1, Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2, and follow the instructions to apply the required codelevel of AD and TXK for your system.
No comments:
Post a Comment