ETCC提供了两个脚本，用来帮助用户检测 E-Business Suite Release 12.2数据库和中间层是否安装了必须的补丁。官方强烈推荐使用。
1.checkDBpatch.sh
这个脚本是Database EBS Technology Codelevel Checker (DB-ETCC)。检测数据库是否安装的所需的补丁。在RAC环境需要在每个节点的ORACLE_HOME都执行一次。
2.checkMTpatch.sh
这是 Middle Tier EBS Technology Codelevel Checker (MT-ETCC)。检测中间层文件系统是否安装了所需的补丁。
通过Patch 17537119下载ETCC，解压示例：
For DB-ETCC:
- checkDBpatch.sh
- checkDBpatch.cmd
- txk_R1220_DB_base_bugs.xml
For MT-ETCC:
- checkMTpatch.sh
- checkMTpatch.cmd
- txk_R1220_MT_base_bugs.xml
- README.txt
存在的限制：
对于AD-TXK codelevel Delta 6或者更早的版本，MT-ETCC不支持将结果存在数据库中
使用场景：
·如果使用已经存在的数据库(11.2.0.3、11.2.0.4、12.1.0.1)升级到R12.2，在运行rapid install创建升级文件系统之前，必须运行DB-ETCC来确保所有one-off补丁都被打上。
·如果要应用最新的AD-TXK更新包，必须先运行DB-ETCC，再运行MT-ETCC，确保数据库和中间层所需的one-off补丁都被打上。
使用方法：
1.交互模式
$ ./checkDBpatch.sh
2.非交互模式
$ ./checkDBpatch.sh contextfile=<full path to database context file>
checkDBpatch.sh示例：
$ ./checkDBpatch.sh contextfile=/app/oracle/db/VIS/11.2.0/appsutil/VIS_ebstest.xml +===============================================================+ | Copyright (c) 2005, 2015 Oracle and/or its affiliates. | | All rights reserved. | | Database EBS Technology Codelevel Checker (DB-ETCC) | +===============================================================+ Starting Database EBS Technology Codelevel Checker, Version 120.28 Using database context file: /app/oracle/db/VIS/11.2.0/appsutil/VIS_ebstest.xml Bugfix XML file version: 120.0.12020000.27 This file will be used as the reference for identifying missing bugfixes. [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. Setting database release to 11.2.0.3. =================================================================================== [WARNING] Oracle Database 11.2.0.3 is no longer recommended for use with Oracle E-Business Suite Release 12.2. Details of bugfixes and patches are no longer maintained for this version, so ETCC output may be out of date and inapplicable. For recommended database versions, refer to My Oracle Support Knowledge Document 1594274.1, "Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes". =================================================================================== Database connection successful. Created the table to store DB-ETCC results. Started prerequisite patch testing : Tue Dec 1 21:14:44 CST 2015 Log file for this session : ./checkDBpatch_4988.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: 14046443 14255128 14367567 15955538 16075609 16288550 16299727 16359751 16989137 17250794 17401353 17654622 17901041 17912217 18244962 18260550 18282562 18331812 18331850 18419770 18436307 18440047 18607546 18614015 18674024 18685209 18689530 18730542 18828868 18893947 18964939 18966843 19393542 19472320 19487147 19791273 19835133 19896336 19879144 19949371 20245930 20294666 20476776 20825533 20949558 ** 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 Dec 1 21:14:48 CST 2015 =========================================================
checkMTpatch.sh示例：
$ ./checkMTpatch.sh contextfile=/app/oracle/apps/VIS/fs1/inst/apps/VIS_ebstest/appl/admin/VIS_ebstest.xml +===============================================================+ | Copyright (c) 2005, 2015 Oracle and/or its affiliates. | | All rights reserved. | | Oracle E-Business Suite Release 12.2 | | Middle Tier Technology Codelevel Checker | +===============================================================+ Using context file from command line argument: /app/oracle/apps/VIS/fs1/inst/apps/VIS_ebstest/appl/admin/VIS_ebstest.xml Starting Middle Tier Technology Codelevel Checker, Version: 120.0.12020000.21. Tue Dec 1 21:15:31 CST 2015 Log file for this session: /software/ETCC/checkMTpatch_5767.log Bugfix XML file version: 120.0.12020000.20 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 codelevel does not support storing the results in the database. ================================================================== Oracle Forms and Reports ================================================================== Now examining product Oracle Forms and Reports. Oracle Home = /app/oracle/apps/VIS/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. Missing Bugfix: 17353142 Missing Bugfix: 20643256 Missing Bugfix: 16041055 Missing Bugfix: 16910762 Missing Bugfix: 20270659 Missing Bugfix: 17372642 Missing Bugfix: 17566694 Missing Bugfix: 20240480 Missing Bugfix: 19304738 The above list shows missing bugfixes 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 = /app/oracle/apps/VIS/fs1/FMW_Home/webtier. Product Version = 11.1.1.7.0 Checking required bugfixes for FMW - Web Tier 11.1.1.7.0. Missing Bugfix: 17526668 Missing Bugfix: 17988318 Missing Bugfix: 18025250 The above list shows missing bugfixes 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 = /app/oracle/apps/VIS/fs1/FMW_Home/oracle_common. Product Version = 11.1.1.7.0 Checking required bugfixes for FMW - oracle common 11.1.1.7.0. Missing Bugfix: 9905685 Missing Bugfix: 14754223 The above list shows missing bugfixes for FMW - oracle common. ================================================================== Oracle WebLogic Server (WLS) ================================================================== Now examining product Oracle WebLogic Server. Oracle Home = /app/oracle/apps/VIS/fs1/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. All required patches are present for Oracle WebLogic Server (WLS). ================================================================== 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. Tue Dec 1 21:15:56 CST 2015 ==================================================================