Tuesday, January 23, 2018

Application Tier code level checker

Source you App environment

checkMTpatch.sh

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

Using context file from currently set applications environment:
/apps2/oracle/product/inst/fs1/inst/apps/VIS_suthakar/appl/admin/VIS_suthakar.xml

Starting Application Tier Technology Codelevel Checker 
Version: 120.0.12020000.32.
Tue Jan 23 11:30:13 EST 2018
Log file for this session: /scratch/r12patch/checkMTpatch_12087.log

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

Mapping XML file version: 120.0.12020000.18
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 codelevel does not support storing the results in the database.

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

Oracle Home = /apps2/oracle/product/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  ->  Patch 25768948
  Missing Bugfix: 20643256  ->  Patch 25768948
  Missing Bugfix: 16041055  ->  Patch 25768948
  Missing Bugfix: 16910762  ->  Patch 25768948
  Missing Bugfix: 20270659  ->  Patch 25768948
  Missing Bugfix: 17372642  ->  Patch 25768948
  Missing Bugfix: 17566694  ->  Patch 25768948
  Missing Bugfix: 20240480  ->  Patch 25768948
  Missing Bugfix: 19304738  ->  Patch 25768948
  Missing Bugfix: 20391574  ->  Patch 25768948
  Missing Bugfix: 22351071  ->  Patch 25768948
  Missing Bugfix: 21024122  ->  Patch 25768948
  Missing Bugfix: 19588847  ->  Patch 25768948
  Missing Bugfix: 19639173  ->  Patch 25768948
  Missing Bugfix: 20545718  ->  Patch 25768948
  Missing Bugfix: 22524329  ->  Patch 25768948
  Missing Bugfix: 23123655  ->  Patch 25768948
  Missing Bugfix: 23728755  ->  Patch 25768948
  Missing Bugfix: 24315226  ->  Patch 25768948
  Missing Bugfix: 24480018  ->  Patch 25768948
  Missing Bugfix: 24808044  ->  Patch 25768948
  Missing Bugfix: 24620875  ->  Patch 25768948
  Missing Bugfix: 25355211  ->  Patch 25768948
  Missing Bugfix: 23538157  ->  Patch 25768948
  Missing Bugfix: 23538170  ->  Patch 25768948
  Missing Bugfix: 13557392  ->  Patch 25768948
  Missing Bugfix: 25506193  ->  Patch 25768948
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 = /apps2/oracle/product/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: 21300463  ->  Patch 22288381
  Missing Bugfix: 21892015  ->  Patch 22288381
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 = /apps2/oracle/product/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: 9905685  ->  Patch 9905685
  Missing Bugfix: 17428617  ->  Patch 17428617
  Missing Bugfix: 21366277  ->  Patch 21366277
  Missing Bugfix: 21628307  ->  Patch 21628307
  Missing Bugfix: 24606362  ->  Patch 24606362
  Missing Bugfix: 24843064  ->  Patch 24843064
The above list shows missing bugfixes for FMW - oracle common.

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

Oracle Home = /apps2/oracle/product/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.
  Missing Patch ID: 23743997
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.

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

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 Forms and Reports 10.1.2.3.0
-------------------------------------------------------------------------------
  Patch 25768948
    - Filename: p25768948_101232_LINUX.zip


-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0
-------------------------------------------------------------------------------
  Patch 22288381
    - Filename: p22288381_111190_Generic.zip


-------------------------------------------------------------------------------
Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0
-------------------------------------------------------------------------------
  Patch 9905685
    - Filename: p9905685_111190_Generic.zip

  Patch 17428617
    - Filename: p17428617_111190_Generic.zip

  Patch 21366277
    - Filename: p21366277_111190_Generic.zip

  Patch 21628307
    - Filename: p21628307_111190_Generic.zip

  Patch 24606362
    - Filename: p24606362_111190_Generic.zip

  Patch 24843064
    - Filename: p24843064_111190_Generic.zip


-------------------------------------------------------------------------------
Oracle WebLogic Server (WLS) 10.3.6.0.7
-------------------------------------------------------------------------------
  Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018]
    - Filename: p23743997_1036_Generic.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 26821047
    - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR OCT 2017

+-----------------------------------------------------------------------------+
[WARNING]  Patch 23743997 [SU Patch [K25M]: WLS PSU 10.3.0.6.161018] is missing. 
This is the recommended minimum WLS patch set.
You should install it now, and then rerun this script to check for any
further fixes available.
+-----------------------------------------------------------------------------+

See Doc ID 1594274.1 for any special instructions regarding these patches.
Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Finished checking prerequisite patches for File Edition: run.
Tue Jan 23 11:30:35 EST 2018

Log file for this session: /scratch/r12patch/checkMTpatch_12087.log

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

oracle@suthakar$

1 comment:

Mike said...

Good informative blog!! Thanks for sharing this information with everyone. Here is another solution: https://www.ssogen.com/oracle-jde-sso/