APPLIES TO:
Oracle Applications DBA - Version 12.2 to 12.2 [Release 12.2Cloud]Information in this document applies to any platform.
GOAL
E-Business Suite 12.2 Applications DBA, Upgrade And Patching related issues
Provide steps to run the E-Business Suite (EBS) Technology Codelevel Checker (ETCC).
The Technology Codelevel Checker (ETCC) utility provides two scripts to ensure all the necessary database and application tier patches are installed on a 12.2 system.
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.
SOLUTION
Follow the below steps to run the Technology Codelevel Checker (ETCC):
1) The EBS Technology Code Level Checker (ETCC) 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.
The results of the execution are stored in the database (APPLSYS.TXK_TCC_RESULTS table) and verified during Upgrade Filesystem creation using Rapid Install, and during every adop execution.
Note:
For AD-TXK codelevel Delta 6 and earlier, MT-ETCC does not support storing the results in the database.
2) To run the DB Technology Codelevel Checker (DB-ETCC) :
2. Read the Instructions to run the Database EBS checker utility from the patch's readme.
3. Follow the steps below :
- Login as the RDBMS ORACLE_HOME owner on the DB tier and Source the <DB_ORACLE_HOME>/<SID>.env
- Unzip the patch
- Confirm the following files are present after unzipping.
checkDBpatch.sh
checkDBpatch.cmd
txk_R1220_DB_base_bugs.xml
- Run the script and Supply the values the script prompts for, if using the interactive mode.
UNIX:
Interactive mode:
$ ./checkDBpatch.sh
Non-interactive mode:
$ ./checkDBpatch.sh contextfile=<full path to database context file>
Windows:
Interactive mode:
C:\>checkDBpatch.cmd
Non-interactive mode:
C:\>checkDBpatch.cmd contextfile=<full path to database context file>
4. The script provides a list of one-offs that are either missing, or need to be rolled back.
Take the appropriate actions based on the results provided by the script.
Notes:
- Patch 17537119 is updated regularly, so always upload this patch from My Oracle Support to get the latest version of the base bugs (txk_R1220_DB_base_bugs.xml) used by the Code Level Checker tool.
- Make sure to have appropriate version of opatch utility for the RDBMS ORACLE_HOME being validated. For example, for an RDBMS at release 11.2.0.3, the opatch utility should be of the version 11.2.0.3 and above. For an RDBMS release 11.2.0.4, the opatch utility should be of version 11.2.0.4 and above.
- For a multi-node RAC environment:
run this tool on all non-shared ORACLE_HOMEs.
run this tool on one of the shared ORACLE_HOMEs.
3) To run the MT Technology Codelevel Checker (MT-ETCC) :
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. 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.
4) If the EBS Technology Code Level Checker reports a missing bug fix, you can identify the patch that includes the missing fix by referring to the following note
Note 1594274.1 - Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes
If some RDBMS patches are in conflict when applying a missing bug fix, the following Notes may help or a dedicated Service Request can be raised to E-Business Installation Support team for further investigation:
- Note 1147107.1 - Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite
- Note 1321267.1 - Database Patch Conflict Resolution
- Note 1091294.1 - How to Use the My Oracle Support Conflict Checker Tool for Patches Installed with OPatch [Video]
5) Four examples of the script execution are shown below. The bugfixes shown here are example bugfix numbers only.
Example N°1 : DB Technology Codelevel Checker (DB-ETCC) - Missing bugfixes have been identified.
/u01/oracle/temp
$ ./checkDBpatch.sh
contextfile=/u01/oracle/ORCL/11.2.0/appsutil/ORCL_dbserver1.xml
+===============================================================+
|
| All rights reserved. |
| Database EBS Technology Codelevel Checker (DB-ETCC) |
+===============================================================+
Starting Database EBS Technology Codelevel Checker, Version 120.26
Using database context file:
/u01/oracle/VIS/12.1.0/appsutil/VIS_myhost.xml
Bugfix XML file version: 120.0.12020000.24
This file will be used as the reference for identifying missing bugfixes.
Identifying database release ...
Setting database release to 12.1.0.2
Database connection successful.
Table to store DB-ETCC results already exists in the database.
Started prerequisite patch testing : Tue Aug 4 14:10:30 BST 2015
Log file for this session : ./checkDBpatch_15363.log
Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is at the required version.
Found patch records in the inventory.
Some required one-off bugfixes are missing from the Database ORACLE_HOME.
The missing bugfixes are:
11111111
22222222
33333333
44444444
** Please refer to MOS Doc ID "1594274.1:Oracle E-Business Suite Release 12.2:Consolidated
List of Patches and Technology Bug Fixes" to find the corresponding patch that delivers the bug fix.
If an overlay patch is needed for any particular patch listed, the footnote for that
patch also applies to the overlay patch.**
Stored Technology Codelevel Checker results in the database successfully.
Apply the missing bugfixes and then rerun the script.
Finished prerequisite patch testing : Tue Aug 4 14:10:34 BST 2015
=========================================================
Example N°2 : DB Technology Codelevel Checker (DB-ETCC) - All required bugfixes have been applied.
/u01/oracle/temp
$ ./checkDBpatch.sh
contextfile=/u01/oracle/ORCL/11.2.0/appsutil/ORCL_dbserver.xml
+===============================================================+
| Database EBS Technology Codelevel Checker (DB-ETCC) |
+===============================================================+
Starting Database EBS Technology Codelevel Checker, Version 120.26
Using database context file:
/u01/oracle/VIS/12.1.0/appsutil/VIS_myhost.xml
Bugfix XML file version: 120.0.12020000.24
This file will be used as the reference for identifying missing bugfixes.
Identifying database release ...
Setting database release to 12.1.0.2
Database connection successful.
Table to store DB-ETCC results already exists in the database.
Started prerequisite patch testing : Tue Aug 4 14:10:30 BST 2015
Log file for this session : ./checkDBpatch_15363.log
Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.
The opatch utility is at the required version.
Found patch records in the inventory.
All the required one-off bugfixes are present in Database ORACLE_HOME.
Stored Technology Codelevel Checker results in the database successfully.
Finished prerequisite patch testing : Tue Aug 4 14:13:29 BST 2015
=========================================================
Example 3: MT Technology Codelevel Checker (MT-ETCC) - Missing bugfixes have been identified.
This example shows AD.C.5 where this codelevel does not support storing results in the database.
+===============================================================+
| |
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Middle Tier Technology Codelevel Checker |
+===============================================================+
Using context file from currently set applications environment:
/u01/oracle/VIS/fs2/inst/apps/VIS_myhost/appl/admin/VIS_myhost.xml
Starting Middle Tier Technology Codelevel Checker, Version: 120.0.12020000.12.
Thu Jul 23 11:52:06 BST 2015
Log file for this session: ./checkMTpatch_24876.log
Bugfix XML file version: 120.0.12020000.6
This file will be used as the reference for identifying missing bugfixes.
Checking for prerequisite bugfixes in File Edition: run
Enter the password for the APPS user:
Database connection successful.
The installed AD.C.5 codelevel does not support storing the results in the database.
==================================================================
Oracle Forms and Reports
==================================================================
Now examining product Oracle Forms and Reports.
Oracle Home = /u01/oracle/VIS/fs2/EBSapps/10.1.2.
Product version = 10.1.2.3.0.
Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.
Missing Bugfix: 1234567
The above list shows missing bugfixes for Oracle Forms and Reports.
Checking required bugfixes for RSF within Forms 10.1.0.5.0.
Missing Bugfix: 6644112
The above list shows missing bugfixes for RSF within Forms.
==================================================================
Oracle Fusion Middleware (FMW) - Web Tier
==================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.
Oracle Home = /u01/oracle/VIS/fs2/FMW_Home/webtier.
Product Version = 11.1.1.6.0
Checking required bugfixes for FMW - Web Tier 11.1.1.6.0.
Missing Bugfix: 11223344
Missing Bugfix: 22334455
Missing Bugfix: 33445566
The above list shows missing bugfixes for FMW - Web Tier.
Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.
Missing Bugfix: 22446688
The above list shows missing bugfixes for RSF within FMW Web tier.
==================================================================
Oracle Fusion Middleware (FMW) - oracle_common
==================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.
Oracle Home = /u01/oracle/VIS/fs2/FMW_Home/oracle_common.
Product Version = 11.1.1.6.0
Checking required bugfixes for FMW - oracle common 11.1.1.6.0.
Missing Bugfix: 99887766
Missing Bugfix: 55443322
The above list shows missing bugfixes for FMW - oracle common.
==================================================================
Oracle WebLogic Server (WLS)
==================================================================
Now examining product Oracle WebLogic Server.
Oracle Home = /u01/oracle/VIS/fs2/FMW_Home/wlserver_10.3.
Product Version = 10.3.6.0.7
Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.
Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.7.
Missing Patch ID: 33445566
Missing Patch ID: 44556677
Missing Patch ID: 55667788
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.
==================================================================
One or more products have bugfixes missing.
Apply the missing bugfixes and rerun this script.
See Doc ID 1594274.1 for the patches that provide the bugfixes.
The footnotes for patches also apply to corresponding overlay patches.
Finished checking prerequisite patches for File Edition: run.
Thu Jul 23 11:52:29 BST 2015
==================================================================
Example 4: MT Technology Codelevel Checker (MT-ETCC) - All required bugfixes have been applied.
This example shows AD.C.5 where this codelevel does not support storing results in the database
+===============================================================+
| All rights reserved. |
| Oracle E-Business Suite Release 12.2 |
| Middle Tier Technology Codelevel Checker |
+===============================================================+
Using context file from currently set applications environment:
/u01/oracle/VIS/fs2/inst/apps/VIS_myhost/appl/admin/VIS_myhost.xml
Starting Middle Tier Technology Codelevel Checker, Version: 120.0.12020000.14.
Thu Jul 23 12:53:06 BST 2015
Log file for this session: ./checkMTpatch_16160.log
Bugfix XML file version: 120.0.12020000.14
This file will be used as the reference for identifying missing bugfixes.
Checking for prerequisite bugfixes in File Edition: run
Enter the password for the APPS user:
Database connection successful.
The installed AD.C.5 codelevel does not support storing the results in the database.
==================================================================
Oracle Forms and Reports
==================================================================
Now examining product Oracle Forms and Reports.
Oracle Home = /u01/oracle/VIS/fs2/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 = /u01/oracle/VIS/fs2/FMW_Home/webtier.
Product Version = 11.1.1.6.0
Checking required bugfixes for FMW - Web Tier 11.1.1.6.0.
All required bugfixes are present for FMW - Web Tier.
Checking required bugfixes for RSF within FMW Web tier 11.1.0.6.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 = /u01/oracle/VIS/fs2/FMW_Home/oracle_common.
Product Version = 11.1.1.6.0
Checking required bugfixes for FMW - oracle common 11.1.1.6.0.
All required bugfixes are present for FMW - oracle common.
==================================================================
Oracle WebLogic Server (WLS)
==================================================================
Now examining product Oracle WebLogic Server.
Oracle Home = /u01/oracle/VIS/fs2/FMW_Home/wlserver_10.3.
Product Version = 10.3.6.0.4
Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.
Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.4.
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.
Thu Jul 23 12:53:29 BST 2015
==================================================================
REFERENCES
PATCH:21967332NOTE:1321267.1 - Database Patch Conflict Resolution
NOTE:1091294.1 - How to Use the My Oracle Support Conflict Checker Tool for Patches Installed with OPatch [Video]
NOTE:1147107.1 - Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite
NOTE:1594274.1 - Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes
PATCH:18893947
No comments:
Post a Comment