checkDBpatch.sh will tell you Database EBS Technology Codelevel

checkDBpatch.sh

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

 |    Copyright (c) 2005, 2017 Oracle and/or its affiliates.     | 

 |                     All rights reserved.                      | 

 |             Oracle E-Business Suite Release 12.2              | 

 |          Database EBS Technology Codelevel Checker            | 

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

Using context file from currently set database environment:

/apps2/oracle/product/12.1.0/appsutil/VIS_suthakar.xml

Starting Database EBS Technology Codelevel Checker, Version 120.55 

Mon Jan 22 12:01:40 EST 2018

Log file for this session : ./checkDBpatch_15647.log

Bugfix XML file version: 120.0.12020000.39

This file will be used for identifying missing bugfixes. 

Mapping XML file version: 120.0.12020000.12

This file will be used for mapping bugfixes to patches.

[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. 

Database release set to 12.1.0.2.

Connecting to database. 

Database connection successful. 

Database VIS is in READ WRITE mode.

Identifying APPS and APPLSYS schema names. 

 - APPS schema : APPS

 - APPLSYS schema : APPLSYS

Checking for DB-ETCC results table. 

Table to store DB-ETCC results already exists in the database.

Checking if InMemory option is enabled. 

InMemory option is not enabled in the database.

Checking Bugfix XML file for 12.1.0.2

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

Now checking Database ORACLE_HOME.

The opatch utility is version 12.1.0.1.10.

DB-ETCC is compatible with this opatch version.

Found patch records in the inventory.

Checking Mapping XML file for 12.1.0.2

  Missing Bugfix: 14666816  ->  Patch 26635276

  Missing Bugfix: 18793246  ->  Patch 18793246

  Missing Bugfix: 19239846  ->  Patch 26794113

  Missing Bugfix: 19591608  ->  Patch 19591608

  Missing Bugfix: 20627866  ->  Patch 26794113

  Missing Bugfix: 20766180  ->  Patch 20766180

  Missing Bugfix: 20868862  ->  Patch 26635276

  Missing Bugfix: 21099502  ->  Patch 25967939

  Missing Bugfix: 21028698  ->  Patch 22098146

  Missing Bugfix: 21106027  ->  Patch 26794113

  Missing Bugfix: 21321429  ->  Patch 21321429

  Missing Bugfix: 21387964  ->  Patch 26794113

  Missing Bugfix: 21614112  ->  Patch 25967939

  Missing Bugfix: 21751519  ->  Patch 26635276

  Missing Bugfix: 21813400  ->  Patch 26794113

  Missing Bugfix: 21864513  ->  Patch 21864513

  Missing Bugfix: 21904072  ->  Patch 21904072

  Missing Bugfix: 21967332  ->  Patch 21967332

  Missing Bugfix: 22024071  ->  Patch 26794113

  Missing Bugfix: 22229581  ->  Patch 26635276

  Missing Bugfix: 22452653  ->  Patch 26635276

  Missing Bugfix: 22496904  ->  Patch 22496904

  Missing Bugfix: 22568797  ->  Patch 26794113

  Missing Bugfix: 22660003  ->  Patch 25967939

  Missing Bugfix: 22666802  ->  Patch 26794113

  Missing Bugfix: 22731026  ->  Patch 22731026

  Missing Bugfix: 22737974  ->  Patch 26635276

  Missing Bugfix: 23089357  ->  Patch 23089357

  Missing Bugfix: 23220453  ->  Patch 26794113

  Missing Bugfix: 23604553  ->  Patch 26635276

  Missing Bugfix: 23632545  ->  Patch 26794113

  Missing Bugfix: 23645516  ->  Patch 26794113

  Missing Bugfix: 24326444  ->  Patch 26794113

  Missing Bugfix: 24385983  ->  Patch 26794113

  Missing Bugfix: 24560906  ->  Patch 24560906

  Missing Bugfix: 24589081  ->  Patch 26794113

  Missing Bugfix: 25099339  ->  Patch 26794113

  Missing Bugfix: 25139545  ->  Patch 26635276

  Missing Bugfix: 25643931  ->  Patch 25643931

  Missing Bugfix: 25906117  ->  Patch 25906117

  Missing Bugfix: 25971286  ->  Patch 26794113

  Missing Bugfix: 25919622  ->  Patch 26794113

  Missing Bugfix: 25995938  ->  Patch 25995938

  Missing Bugfix: 26658759  ->  Patch 26794113

Generating Patch Recommendation Summary.

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

PATCH RECOMMENDATION SUMMARY

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

The default patch recommendations to install these missing bugfixes are:

-------------------------------------------------------------------------------

Oracle Database Release 12.1.0.2  (No PSU applied)

-------------------------------------------------------------------------------

  Patch 26635276

    - Filename: p26635276_121020_Linux-x86-64.zip

  Patch 18793246

    - Filename: p18793246_121020_Generic.zip

  Patch 26794113

    - Filename: p26794113_121020_Linux-x86-64.zip

  Patch 19591608

    - Filename: p19591608_121020_Linux-x86-64.zip

  Patch 20766180

    - Filename: p20766180_121020_Generic.zip

  Patch 25967939

    - Filename: p25967939_121020_Linux-x86-64.zip

  Patch 22098146

    - Filename: p22098146_121020_Linux-x86-64.zip

  Patch 21321429

    - Filename: p21321429_121020_Generic.zip

  Patch 21864513

    - Filename: p21864513_121020_Linux-x86-64.zip

  Patch 21904072

    - Filename: p21904072_121020_Linux-x86-64.zip

  Patch 21967332

    - Filename: p21967332_121020_Linux-x86-64.zip

  Patch 22496904

    - Filename: p22496904_121020_Linux-x86-64.zip

  Patch 22731026

    - Filename: p22731026_121020_Generic.zip

  Patch 23089357

    - Filename: p23089357_121020_Linux-x86-64.zip

  Patch 24560906

    - Filename: p24560906_121020_Linux-x86-64.zip

  Patch 25643931

    - Filename: p25643931_121020_Linux-x86-64.zip

  Patch 25906117

    - Filename: p25906117_121020_Linux-x86-64.zip

  Patch 25995938

    - Filename: p25995938_121020_Linux-x86-64.zip

Apply the required patches and rerun this script

You should check the patch READMEs for minimum opatch version requirements.

The latest opatch is available from My Oracle Support via Patch 6880880.

+-----------------------------------------------------------------------------+

A consolidated zip file with the required patches for Database release

12.1.0.2.0 is available on My Oracle Support via:

  Patch 26821046 [12.1.0.2.0 version]

    - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR OCT 2017

Note: This zip does not include any database bundle patches or PSUs.

+-----------------------------------------------------------------------------+

See Doc ID 1594274.1 for any special instructions for these patches.

Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Stored Technology Codelevel Checker results in the database VIS successfully.

Finished checking fixes for Oracle Database: Mon Jan 22 12:01:53 EST 2018

Log file for this session: ./checkDBpatch_15647.log

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

oracle@suthakar$