Month: December 2024

December 3, 2024 Oracle EBS ETCC OCT-2024 Update

APPS DBA

EBS Technology Codelevel Checker (ETCC) OCT-2024 Update

Introduction to ETCC

The EBS Technology Code Level Checker (ETCC) includes two scripts that examine the Oracle Homes of both the Database and the Middle tier. These scripts serve to identify any missing bug fixes that are necessary for Oracle E-Business Suite Release 12.2. It is highly recommended by Oracle to utilize this utility in order to ensure that all the required bug fixes for the database and middle tier have been successfully installed.

The E-Business Suite T

echnology Codelevel Checker (ETCC) is a critical tool for ensuring your Oracle E-Business Suite environment meets the required patch levels for database and technology stack components. It helps identify missing patches that are mandatory for compatibility and stability, especially during upgrades like migrating to Oracle Database 19c.

ETCC serves two primary purposes:

Mandatory Patch Validation:
It identifies missing database patches (e.g., Database Patch Set Updates (PSUs), Release Updates (RUs), and one-off patches) that are required for E-Business Suite to function optimally. This prevents potential performance or compatibility issues caused by missing patches.
Technology Stack Validation:
It checks for required patches across the technology stack components, such as Oracle WebLogic Server or Fusion Middleware, ensuring the overall environment is consistent with Oracle’s recommendations.

Key Features:

Ease of Use:
ETCC can be run on the database server, providing a report of missing patches without making any changes.
Pre-Upgrade Assistance:
It is particularly useful during upgrades (e.g., moving to Database 19c) to verify all required patches are applied in advance, reducing downtime and troubleshooting efforts.
Up-to-Date Compliance:
Oracle regularly updates ETCC to reflect the latest patch requirements, ensuring you always meet the latest standards.

How It Works:

ETCC consists of scripts that:

Compare your current environment with Oracle’s patch baseline.
Generate a detailed report listing the missing patches and instructions on how to apply them.

ETCC is an essential tool to streamline patching and upgrades while minimizing the risks of downtime or errors in Oracle E-Business Suite environments.

Download Latest ETCC

https://updates.oracle.com/download/17537119.html

Running ETCC on Database Tier

[oracle@ebs12214 DB_1925_patch]$ unzip -qo p17537119_R12_GENERIC.zip

[oracle@ebs12214 DB_1925_patch]$ source /home/oracle/env_PROD.env

[oracle@ebs12214 DB_1925_patch]$ ./checkDBpatch.sh

+===============================================================+
|    Copyright (c) 2005, 2024 Oracle and/or its affiliates.     |
|                     All rights reserved.                      |
|             Oracle E-Business Suite Release 12.2              |
|          Database EBS Technology Codelevel Checker            |
+===============================================================+

Validating context file: /u01/oracle/PROD/19.0.0/appsutil/PROD_ebs12214.xml
Using context file from currently set database environment:
/u01/oracle/PROD/19.0.0/appsutil/PROD_ebs12214.xml

Starting Database EBS Technology Codelevel Checker, Version 120.127
Mon Nov 25 18:34:02 PKT 2024
Log file for this session: /patches/DB_1925_patch/log/checkDBpatch_7783.log
Identifying database release.
Database release set to 19.25.0.0.
Multitenant identified.

– Container database (CDB) identified via s_cdb_name is prodcdb
– Pluggable database (PDB) identified via s_pdb_name is PROD

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 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.85
This file will be used for identifying missing bugfixes.

Mapping file ./db/onprem/txk_R1220_DB_mappings.xml: 120.0.12020000.61
This file will be used for mapping bugfixes to patches.
+—————————————————————————————+
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: 18
Checking Bugfix XML file for tag 19.25.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.44.
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.25.0.0.241015DBRU.
All the required one-off bugfixes are present in database ORACLE_HOME.

+—————————————————————————————+

Finished checking fixes for database PROD: Mon Nov 25 18:34:18 PKT 2024
Log file for this session: /patches/DB_1925_patch/log/checkDBpatch_7783.log
This file should be reviewed for errors after the ETCC run.

Applying Database Patches

We have already applied the latest Database PSU, which is why no required patches are appearing in the DB ETCC report.

If you need to apply the Database PSU kindly refer to the Document attached Below Link:

Oracle Database 19c OCT-2024 Patch Set Upate Apply

Running ETCC on Application Tier

[oracle@ebs12214 DB_1925_patch]$ source /u01/oracle/PROD/EBSapps.env run

E-Business Suite Environment Information
—————————————-
RUN File System           : /u01/oracle/PROD/fs1/EBSapps/appl
PATCH File System         : /u01/oracle/PROD/fs2/EBSapps/appl
Non-Editioned File System : /u01/oracle/PROD/fs_ne
DB Host: ebs12214.com Service/SID: PROD
   Sourcing the RUN File System …

[oracle@ebs12214 DB_1925_patch]$ ./checkMTpatch.sh
  +===============================================================+
|    Copyright (c) 2005, 2024 Oracle and/or its affiliates.     |
|                     All rights reserved.                      |
|             Oracle E-Business Suite Release 12.2              |
|        Application Tier EBS Technology Codelevel Checker      |
+===============================================================+

Using context file from currently set applications environment:
/u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.xml
Starting Application Tier EBS Technology Codelevel Checker, Version 120.0.12020000.68.
Mon Nov 25 18:37:18 PKT 2024

Log file for this session: /patches/DB_1925_patch/log/checkMTpatch_9157.log
Bugfix XML file version: 120.0.12020000.64
This file will be used for identifying missing bugfixes.
Mapping XML file version: 120.0.12020000.52
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.14 codelevel supports storing the results in the database.
Checking for existence of ETCC results table.
Table to store results already exists in database.

===============================================================================

Oracle Forms and Reports

===============================================================================

Now examining Oracle Forms and Reports.

Oracle Home: /u01/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.
These results have been stored in the database.
Identified DST version: 18
Checking required bugfixes for RSF 10.1.0.5.0 in Oracle Forms.
All required bugfixes are present for RSF 10.1.0.5.0 in Oracle Forms.

These results have been stored in the database.

===============================================================================

Oracle Fusion Middleware (FMW) – Web Tier

===============================================================================

Now examining Oracle Fusion Middleware (FMW) – Web Tier.
Oracle Home: /u01/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.
Missing Bugfix: 29220393 -> Patch 35540062
Missing Bugfix: 34287094 -> Patch 35540062
Missing Bugfix: 34287122 -> Patch 35540062
Missing Bugfix: 34637603 -> Patch 35540062
Missing Bugfix: 34642403 -> Patch 35540062
Missing Bugfix: 35243151 -> Patch 35540062
The above list shows missing bugfixes for FMW – Web Tier.
These results have been stored in the database.
Identified DST version: 18

Checking required bugfixes for RSF 11.1.0.7.0 in FMW Web tier.
All required bugfixes are present for RSF 11.1.0.7.0 in FMW Web tier.
These results have been stored in the database.

===============================================================================
Oracle Fusion Middleware (FMW) – Oracle Common
===============================================================================

Now examining Oracle Fusion Middleware (FMW) – Oracle Common.
Oracle Home: /u01/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.

Missing Bugfix: 14354533 -> Patch 33974106
Missing Bugfix: 14282782 -> Patch 33974106
Missing Bugfix: 33960746 -> Patch 33960746
Missing Bugfix: 34714760 -> Patch 34714760
The above list shows missing bugfixes for FMW – Oracle Common.
These results have been stored in the database.
===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================

Now examining WLS.
Oracle Home: /u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3.
Product version: 10.3.6.0.220719.
Note: For WLS, patches rather than bugfixes are verified.
Checking required patches for WLS 10.3.6.0.220719.
Missing Patch ID: 34856303
Missing Patch ID: 35476084

The above list shows missing patches for Oracle WebLogic Server.
If you have applied other Oracle WebLogic Server patches, they may have included
the bugfixes needed.Contact Oracle Support if you require assistance in
determining whether this is the case.
These results have been stored in the database.
===============================================================================
Generating Patch Recommendation Summary.
===============================================================================
PATCH RECOMMENDATION SUMMARY
===============================================================================

One or more products have bugfixes missing.
The default patch recommendations to install these missing bugfixes are:
——————————————————————————-
Oracle Fusion Middleware (FMW) – Web Tier 11.1.1.9.0
——————————————————————————-

Patch 35540062
– Filename: p35540062_111190_Linux-x86-64.zip
——————————————————————————-
Oracle Fusion Middleware (FMW) – Oracle Common 11.1.1.9.0
——————————————————————————-

Patch 33974106
    – Filename: p33974106_111190_Generic.zip
   Patch 33960746
    – Filename: p33960746_111190_Generic.zip
   Patch 34714760
    – Filename: p34714760_111190_Generic.zip
——————————————————————————-
WLS 10.3.6.0.220719
——————————————————————————-

Patch 34856303 [SU Patch [ENUU]]
    – Filename: p34856303_1036_Generic.zip
   Patch 35476084 [SU Patch [KMHV]]
    – Filename: p35476084_1036_Linux-x86-64.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 36616672
– EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2024
+—————————————————————————–+
See Doc ID 2877607.1 for any special instructions regarding these patches.
Footnotes in Doc ID 2877607.1 also apply to corresponding overlay patches.
Finished checking prerequisite patches for file edition: run.

Mon Nov 25 18:37:35 PKT 2024

Log file for this session: /patches/DB_1925_patch/log/checkMTpatch_9157.log
===============================================================================

ETCC Report Fusion Middleware Patches to be applied

Oracle Fusion Middleware (FMW) – Web Tier 11.1.1.9.0

——————————————————————————-

Patch 35540062

– Filename: p35540062_111190_Linux-x86-64.zip

——————————————————————————-

Oracle Fusion Middleware (FMW) – Oracle Common 11.1.1.9.0

——————————————————————————-

Patch 33974106

– Filename: p33974106_111190_Generic.zip

Patch 33960746

– Filename: p33960746_111190_Generic.zip

Patch 34714760

– Filename: p34714760_111190_Generic.zip

——————————————————————————-

WLS 10.3.6.0.220719

——————————————————————————-

Patch 34856303 [SU Patch [ENUU]]

– Filename: p34856303_1036_Generic.zip

Patch 35476084 [SU Patch [KMHV]]

– Filename: p35476084_1036_Linux-x86-64.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 36616672

– EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2024

+—————————————————————————–+

Download FMW Consolidated Patch

We are going to download the latest EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2024 from which we can extract the patches we want to Apply on the FMW shown in the ETCC report.

Download the Patch 36616672: EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2024

Extract the above Patches from Patch 36616672: EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2024 and copied it on the Linux Directory /patches/FMW_patches

Checking Version of Http Server

Source Application Environment

[oracle@ebs12214 ~]$ . ./EBSapps.env run

E-Business Suite Environment Information
—————————————-
RUN File System : /u01/oracle/PROD/fs1/EBSapps/appl
PATCH File System : /u01/oracle/PROD/fs2/EBSapps/appl
Non-Editioned File System : /u01/oracle/PROD/fs_ne

DB Host: ebs12214.com Service/SID: PROD

Sourcing the RUN File System …

Setting Oracle Home for HTTP Version verification

[oracle@ebs12214 ~]$ export ORACLE_HOME=/u01/oracle/PROD/fs1/FMW_Home/webtier
[oracle@ebs12214 ~]$ cd $FMW_HOME
[oracle@ebs12214 FMW_Home]$ . ./SetWebtier.env
[oracle@ebs12214 FMW_Home]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/ohs/lib:$FMW_HOME/oracle_common/lib

[oracle@ebs12214 FMW_Home]$ cd $ORACLE_HOME/ohs/bin
[oracle@ebs12214 bin]$ ./httpd -version =========(Command to Verify Http Version)
Server version: Oracle-HTTP-Server/2.2.22 (Unix)
Server built: Jun 8 2022 00:25:48
Server label: APACHE_11.1.1.9.0_LINUX.X64_RELEASE

Applying Webtier Patches

Unzip the Webtier Patch and Set Environment

[oracle@ebs12214 ~]$ cd /patches/FMW_patches
[oracle@ebs12214 FMW_patches]$ unzip -qo p35540062_111190_Linux-x86-64.zip
[oracle@ebs12214 FMW_patches]$ cd 35540062/

[oracle@ebs12214 35540062]$ export ORACLE_HOME=/u01/oracle/PROD/fs1/FMW_Home/webtier
[oracle@ebs12214 35540062]$ export PATH=$ORACLE_HOME/OPatch:$PATH

Apply Webtier Patch

[oracle@ebs12214 35540062]$ opatch apply

Oracle Home       : /u01/oracle/PROD/fs1/FMW_Home/webtier
Central Inventory : /u01/oracle/oraInventory
from           : /u01/oracle/PROD/fs1/FMW_Home/webtier/oraInst.loc
OPatch version    : 11.1.0.12.9
OUI version       : 11.1.0.11.0
Log file location : /u01/oracle/PROD/fs1/FMW_Home/webtier/cfgtoollogs/opatch/35540062_Nov_26_2024_01_04_06/apply2024-11-26_01-04-06AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/PROD/fs1/FMW_Home”
Applying interim patch ‘35540062’ to OH ‘/u01/oracle/PROD/fs1/FMW_Home/webtier’
Verifying environment and performing prerequisite checks…
Conflicts/Supersets for each patch are:

Patch : 35540062
Bug Superset of 34251646
Super set bugs are:
24567879, 24681614, 20913582, 22218211, 20580842, 26752325, 33231206, 23107407, 33634304, 25191174, 30146419, 21520649, 27577851, 33890540, 32294066, 30876572, 20900385, 26837992, 32593782, 21305938, 31586302, 29857440, 19571821, 26929226, 30887923, 26101975

Interim patch 35540062 is a superset of the patch(es) [ 34251646 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/oracle/PROD/fs1/FMW_Home/webtier’)

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…
Rolling back interim patch ‘34251646’ from OH ‘/u01/oracle/PROD/fs1/FMW_Home/webtier’

Patching component oracle.ohs2, 11.1.1.9.0…
RollbackSession removing interim patch ‘34251646’ from inventory

OPatch back to application of the patch ‘35540062’ after auto-rollback.

Patching component oracle.ohs2, 11.1.1.9.0…
Verifying the update…
Patch 35540062 successfully applied
Log file location: /u01/oracle/PROD/fs1/FMW_Home/webtier/cfgtoollogs/opatch/35540062_Nov_26_2024_01_04_06/apply2024-11-26_01-04-06AM_1.log

OPatch succeeded.

Applying Common Patches

Unzip the Oracle_Common Patch and Set Environment

[oracle@ebs12214 ~]$ cd /patches/FMW_patches
[oracle@ebs12214 FMW_patches]$ unzip -qo p33974106_111190_Generic.zip
[oracle@ebs12214 FMW_patches]$ unzip -qo p33960746_111190_Generic.zip
[oracle@ebs12214 FMW_patches]$ unzip -qo p34714760_111190_Generic.zip

[oracle@ebs12214 FMW_patches]$ cd 33974106
[oracle@ebs12214 33974106]$ export ORACLE_HOME=/u01/oracle/PROD/fs1/FMW_Home/oracle_common
[oracle@ebs12214 33974106]$ export PATH=$ORACLE_HOME/OPatch:$PATH

Apply Oracle_Common Patches

Apply Patch 33974106

[oracle@ebs12214 33974106]$ opatch apply
Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2024, Oracle Corporation. All rights reserved.

Oracle Home : /u01/oracle/PROD/fs1/FMW_Home/oracle_common
Central Inventory : /u01/oracle/oraInventory
from : /u01/oracle/PROD/fs1/FMW_Home/oracle_common/oraInst.loc
OPatch version : 11.1.0.12.9
OUI version : 11.1.0.11.0
Log file location : /u01/oracle/PROD/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/33974106_Nov_26_2024_01_10_02/apply2024-11-26_01-10-02AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/PROD/fs1/FMW_Home”

Applying interim patch ‘33974106’ to OH ‘/u01/oracle/PROD/fs1/FMW_Home/oracle_common’
Verifying environment and performing prerequisite checks…
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/u01/oracle/PROD/fs1/FMW_Home/oracle_common’)

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…

Patching component oracle.jrf.thirdparty.jee, 11.1.1.9.0…

Verifying the update…
Patch 33974106 successfully applied
Log file location: /u01/oracle/PROD/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/33974106_Nov_26_2024_01_10_02/apply2024-11-26_01-10-02AM_1.log

OPatch succeeded.

Apply Patch 33960746

[oracle@ebs12214 FMW_patches]$ cd 33960746
[oracle@ebs12214 33960746]$ opatch apply
Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2024, Oracle Corporation. All rights reserved.

Oracle Home : /u01/oracle/PROD/fs1/FMW_Home/oracle_common
Central Inventory : /u01/oracle/oraInventory
from : /u01/oracle/PROD/fs1/FMW_Home/oracle_common/oraInst.loc
OPatch version : 11.1.0.12.9
OUI version : 11.1.0.11.0
Log file location : /u01/oracle/PROD/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/33960746_Nov_26_2024_01_12_01/apply2024-11-26_01-12-01AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/PROD/fs1/FMW_Home”

Applying interim patch ‘33960746’ to OH ‘/u01/oracle/PROD/fs1/FMW_Home/oracle_common’
Verifying environment and performing prerequisite checks…
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y

Backing up files…

Patching component oracle.sysman.common, 10.2.0.5.6…

Patching component oracle.sysman.oms.core, 11.1.1.9.0…

Patching component oracle.sysman.plugin.ai.main.oms, 11.1.1.9.0…

Verifying the update…
Patch 33960746 successfully applied
Log file location: /u01/oracle/PROD/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/33960746_Nov_26_2024_01_12_01/apply2024-11-26_01-12-01AM_1.log

OPatch succeeded

Apply Patch 34714760

[oracle@ebs12214 FMW_patches]$ cd 34714760
[oracle@ebs12214 34714760]$ opatch apply
Oracle Interim Patch Installer version 11.1.0.12.9
Copyright (c) 2024, Oracle Corporation. All rights reserved.

Oracle Home : /u01/oracle/PROD/fs1/FMW_Home/oracle_common
Central Inventory : /u01/oracle/oraInventory
from : /u01/oracle/PROD/fs1/FMW_Home/oracle_common/oraInst.loc
OPatch version : 11.1.0.12.9
OUI version : 11.1.0.11.0
Log file location : /u01/oracle/PROD/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/34714760_Nov_26_2024_01_14_41/apply2024-11-26_01-14-41AM_1.log

OPatch detects the Middleware Home as “/u01/oracle/PROD/fs1/FMW_Home”

Applying interim patch ‘34714760’ to OH ‘/u01/oracle/PROD/fs1/FMW_Home/oracle_common’
Verifying environment and performing prerequisite checks…
Patch 34714760: Optional component(s) missing : [ oracle.opss.client, 11.1.1.9.0 ]
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y

Backing up files…

Patching component oracle.jrf.opss, 11.1.1.9.0…

Verifying the update…
Patch 34714760 successfully applied
Log file location: /u01/oracle/PROD/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/34714760_Nov_26_2024_01_14_41/apply2024-11-26_01-14-41AM_1.log

OPatch succeeded.

Applying Weblogic Patches

Unzip Weblogic Patch and Set Environment

[oracle@ebs12214 FMW_patches]$ unzip -qo p34856303_1036_Generic.zip

Note: Copy the extracted Patch Jar and Catalog xml file on cache_dir in bsu

[oracle@ebs12214 FMW_patches]$ cp ENUU.jar /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir
[oracle@ebs12214 FMW_patches]$ cp patch-catalog_27986.xml /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir

[oracle@ebs12214 FMW_patches]$ unzip -qo p35476084_1036_Linux-x86-64.zip
[oracle@ebs12214 FMW_patches]$ cp KMHV.jar /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir
[oracle@ebs12214 FMW_patches]$ cp patch-catalog_27940.xml /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir

[oracle@ebs12214 FMW_patches]$ source /u01/oracle/PROD/EBSapps.env run

E-Business Suite Environment Information
—————————————-
RUN File System : /u01/oracle/PROD/fs1/EBSapps/appl
PATCH File System : /u01/oracle/PROD/fs2/EBSapps/appl
Non-Editioned File System : /u01/oracle/PROD/fs_ne

DB Host: ebs12214.com Service/SID: PROD

Sourcing the RUN File System …

Apply Patch ENUU

[oracle@ebs12214 FMW_patches]$ cd $FMW_HOME/utils/bsu

[oracle@ebs12214 FMW_patches]$. /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/bsu.sh -prod_dir=/u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3/ -patch_download_dir=/u01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir/ -patchlist=ENUU -verbose -install >> Apply_WLS_ENUU.log =========è(Command to Install WLS Patch with BSU)

[oracle@ebs12214 bsu]$ cat Apply_WLS_ENUU.log

Checking for conflicts..

Conflict(s) detected – resolve conflict condition and execute patch installation again

Conflict condition details follow:

Patch ENUU is mutually exclusive and cannot coexist with patch(es): 9UNH

Note: Now as the Patch is conflicting with 9UNH, we have to remove 9UNH to Install ENUU Successfully

[oracle@ebs12214 bsu]$ . /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/bsuremove -prod_dir=/u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3/ -patchlist=9UNH -verbose > Remove_1.txt

Now Once 9UNH removed we will install ENUU

Apply Patch KMHV

[oracle@ebs12214 bsu]$ . /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/bsu.sh -prod_dir=/u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3/ -patch_download_dir=/u01/oracle/PROD/fs1/FMW_Home/utils/bsu/cache_dir/ -patchlist=KMHV -verbose -install >> Apply_WLS_KMHV.log

[oracle@ebs12214 bsu]$ cat Apply_WLS_KMHV.log

Checking for conflicts..

Conflict(s) detected – resolve conflict condition and execute patch installation again

Conflict condition details follow:

Patch KMHV is mutually exclusive and cannot coexist with patch(es): CW7X

Note: Now as the Patch is conflicting with CW7X, we have to remove CW7X to Install KMHV Successfully

[oracle@ebs12214 bsu]$ . /u01/oracle/PROD/fs1/FMW_Home/utils/bsu/bsu.sh -remove -prod_dir=/u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3/ -patchlist=CW7X -verbose > Remove_2.txt

Now Once CW7X removed we will install KMHV

Running ETCC on Application Tier Again

[oracle@ebs12214 ~]$ cd /patches/DB_1925_patch
[oracle@ebs12214 DB_1925_patch]$ source /u01/oracle/PROD/EBSapps.env run

E-Business Suite Environment Information
—————————————-
RUN File System : /u01/oracle/PROD/fs1/EBSapps/appl
PATCH File System : /u01/oracle/PROD/fs2/EBSapps/appl
Non-Editioned File System : /u01/oracle/PROD/fs_ne

DB Host: ebs12214.com Service/SID: PROD

Sourcing the RUN File System …

[oracle@ebs12214 DB_1925_patch]$ ./checkMTpatch.sh

+===============================================================+
| Copyright (c) 2005, 2024 Oracle and/or its affiliates. |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Application Tier EBS Technology Codelevel Checker |
+===============================================================+

Using context file from currently set applications environment:
/u01/oracle/PROD/fs1/inst/apps/PROD_ebs12214/appl/admin/PROD_ebs12214.xml

Starting Application Tier EBS Technology Codelevel Checker, Version 120.0.12020000.68.
Tue Nov 26 03:00:01 PKT 2024
Log file for this session: /patches/DB_1925_patch/log/checkMTpatch_19817.log

Bugfix XML file version: 120.0.12020000.64
This file will be used for identifying missing bugfixes.

Mapping XML file version: 120.0.12020000.52
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.14 codelevel supports storing the results in the database.
Checking for existence of ETCC results table.
Table to store results already exists in database.

===============================================================================
Oracle Forms and Reports
===============================================================================
Now examining Oracle Forms and Reports.

Oracle Home: /u01/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.
These results have been stored in the database.

Identified DST version: 18

Checking required bugfixes for RSF 10.1.0.5.0 in Oracle Forms.
All required bugfixes are present for RSF 10.1.0.5.0 in Oracle Forms.
These results have been stored in the database.

===============================================================================
Oracle Fusion Middleware (FMW) – Web Tier
===============================================================================
Now examining Oracle Fusion Middleware (FMW) – Web Tier.

Oracle Home: /u01/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.
These results have been stored in the database.

Identified DST version: 18

Checking required bugfixes for RSF 11.1.0.7.0 in FMW Web tier.
All required bugfixes are present for RSF 11.1.0.7.0 in FMW Web tier.
These results have been stored in the database.

Oracle Home: /u01/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.
These results have been stored in the database.

===============================================================================
Oracle WebLogic Server (WLS)
===============================================================================
Now examining WLS.

Oracle Home: /u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3.
Product version: 10.3.6.0.220719.
Note: For WLS, patches rather than bugfixes are verified.
Checking required patches for WLS 10.3.6.0.220719.
All required patches are present for WLS.
These results have been stored in the database.

===============================================================================

All required one-offs are confirmed as present.
Finished checking prerequisite patches for file edition: run.
Tue Nov 26 03:02:00 PKT 2024

Log file for this session: /patches/DB_1925_patch/log/checkMTpatch_19817.log

===============================================================================
[oracle@ebs12214 DB_1925_patch]$

ETCC Report Fusion Middleware After Patches applied

===============================================================================

Oracle Fusion Middleware (FMW) – Web Tier

===============================================================================

Now examining Oracle Fusion Middleware (FMW) – Web Tier.

Oracle Home: /u01/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.

These results have been stored in the database.

Identified DST version: 18

Checking required bugfixes for RSF 11.1.0.7.0 in FMW Web tier.

All required bugfixes are present for RSF 11.1.0.7.0 in FMW Web tier.

These results have been stored in the database.

===============================================================================

Oracle Fusion Middleware (FMW) – Oracle Common

===============================================================================

Now examining Oracle Fusion Middleware (FMW) – Oracle Common.

Oracle Home: /u01/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.

These results have been stored in the database.

===============================================================================

Oracle WebLogic Server (WLS)

===============================================================================

Now examining WLS.

Oracle Home: /u01/oracle/PROD/fs1/FMW_Home/wlserver_10.3.

Product version: 10.3.6.0.220719.

Note: For WLS, patches rather than bugfixes are verified.

Checking required patches for WLS 10.3.6.0.220719.

All required patches are present for WLS.

These results have been stored in the database.

===============================================================================

All required one-offs are confirmed as present.

Finished checking prerequisite patches for file edition: run.

Hope you found this document informative and gained valuable insights.

Month: December 2024

EBS Technology Codelevel Checker (ETCC) OCT-2024 Update

Introduction to ETCC

The E-Business Suite T

ETCC serves two primary purposes:

Key Features:

How It Works:

ETCC is an essential tool to streamline patching and upgrades while minimizing the risks of downtime or errors in Oracle E-Business Suite environments.

Download Latest ETCC

Running ETCC on Database Tier

Applying Database Patches

Oracle Database 19c OCT-2024 Patch Set Upate Apply

Running ETCC on Application Tier

ETCC Report Fusion Middleware Patches to be applied

Download FMW Consolidated Patch

Checking Version of Http Server

Source Application Environment

Setting Oracle Home for HTTP Version verification

Applying Webtier Patches

Unzip the Webtier Patch and Set Environment

Apply Webtier Patch

Applying Common Patches

Unzip the Oracle_Common Patch and Set Environment

Apply Oracle_Common Patches

Apply Patch 33974106

Apply Patch 33960746

Apply Patch 34714760

Applying Weblogic Patches

Unzip Weblogic Patch and Set Environment

Apply Patch ENUU

Apply Patch KMHV

Running ETCC on Application Tier Again

ETCC Report Fusion Middleware After Patches applied

Hope you found this document informative and gained valuable insights.