Steps To Run The EBS Technology Code Level Checker (ETCC)

Table of Contents

Introduction:-

The Technology Codelevel Checker (ETCC) utility provides two shell scripts (checkDBpatch.sh & checkMTpatch.sh) to ensure all the necessary database and application tier patches are installed on a 12.2 system.

Is it mandatory to Run The EBS Technology Code Level Checker?

Oracle strongly recommends the use of this utility to ensure that all required database and application tier bug fixes have been installed.

The scripts are usually updated on a quarterly basis, to include the latest defect patches released for the 12.2 database and apps tiers.

Follow the below steps to run the Technology Codelevel Checker (ETCC):

1) The EBS Technology Code Level Checker (ETCC):-

It provides two scripts which analyze the Database and the Middle tier Oracle Homes and warns of missing bug fixes required for Oracle E-Business Suite Release 12.2.

Oracle strongly recommends the use of this utility to ensure that all required database and middle tier bugfixes have been installed.

The two scripts are:

– checkDBpatch.sh (checkDBpatch.cmd on Windows)

This is the Database EBS Technology Codelevel Checker (DB-ETCC), which determines if all the needed bugfixes exist in the specified database ORACLE_HOME.

– checkMTpatch.sh (checkMTpatch.cmd on Windows)

This is the Middle Tier EBS Technology Codelevel Checker (MT-ETCC), which determines if all the needed bugfixes exist in the middle tier file system.

2) To run the DB Technology Codelevel Checker (DB-ETCC) :

1. Download Patch 17537119 from My Oracle Support

[oracle@***apps 17537119_R12]$ sh checkDBpatch.sh

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Database EBS Technology Codelevel Checker |

+===============================================================+

Validating context file: /data01/GSTUAT3/orahome1124/appsutil/PHASE1_apps.xml

Using context file from currently set database environment:

/data01/GSTUAT3/orahome1124/appsutil/PHASE1_apps.xml

Starting Database EBS Technology Codelevel Checker, Version 120.75

Fri Jun 26 11:53:29 IST 2020

Log file for this session : /home/oracle/17537119_R12/log/checkDBpatch_29642.log

Identifying database release.

Database release set to 11.2.0.4.

Connecting to database.

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

[WARNING] DB-ETCC: Could not connect to database, so unable to check:

– Whether database is in READ-WRITE mode.

– Existence of table needed to store DB-ETCC results.

Resolve the database connectivity issue, and then rerun DB-ETCC.

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

Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.54

This file will be used for identifying missing bugfixes.

Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.29

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.

Check if a newer version is available in patch 17537119.

Checking Bugfix XML file for 11.2.0.4_PSU

Obtained list of bugfixes to be applied and the list to be rolled back.

Now checking Database ORACLE_HOME.

The opatch utility is version 11.2.0.3.15.

DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 11.2.0.4.180417

Patch mapping not available.

Patch mapping data is not available for 11.2.0.4.180417

Refer to Doc ID 1147107.1 for the required overlay patches for PSUs and Oracle E-Business Suite

Some required one-off bugfixes are missing from the Database ORACLE_HOME.

The missing bugfixes are:

19791273

20245930

20936905

20949558

21091431

21813400

22024071

22666802

23632545

23645516

24326444

24589081

25136212

25971286

26654363

26658759

29125374

27929509

27997875

28542455

30670774

** Refer to MOS Doc ID “1147107.1:Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite” to find the corresponding overlay patch that delivers the bug fix. **

Apply the missing bugfixes and then rerun the script.

[WARNING] Database not available. DB-ETCC results cannot be stored.

Finished checking fixes for Oracle Database: Fri Jun 26 11:53:44 IST 2020

Log file for this session: /home/oracle/17537119_R12/log/checkDBpatch_29642.log

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

3) To run the MT Technology Codelevel Checker (MT-ETCC) :

1. Download Patch 17537119 from My Oracle Support

2. Read the Instructions to run the Middle Tier EBS checker utility from the patch’s readme.

3. Follow the steps below :

👉 Source the correct environment for the Middle Tier (install/upgrade, or online patching cycle).

👉 Unzip the patch

👉 Confirm the following files are present after unzipping.

checkMTpatch.sh

checkMTpatch.cmd

txk_R1220_MT_base_bugs.xml

👉 Run the script and Supply the values the script prompts for.

UNIX:

Interactive mode:

$ ./checkMTpatch.sh

Non-interactive mode:

$ (echo <appspass>) |./checkMTpatch.sh contextfile=<full path to middle tier context file>

Windows:

Interactive mode:

C:>checkMTpatch.cmd

Non-interactive mode:

C:>(echo <appspass>)| checkMTpatch.cmd contextfile=<full path to middle tier context file>

4. Apply all missing bugfix:-

To apply patches, you may check another useful post, click here.

Take the appropriate actions based on what the script reports about any missing bugfixes.

Note: In a multi-node Oracle E-Business Suite environment, you need to run MT-ETCC:

👉 On all non-shared application (middle) tier nodes.

👉 On any one of the shared application (middle) tier nodes.

References:-

12.2 E-Business Suite Applications DBA Steps To Run The EBS Technology Code Level Checker (ETCC) (Doc ID 2008451.1)