0 Replies Latest reply on Aug 5, 2016 10:34 AM by 882514

    Issues while running ETCC

    882514

      Hi ,

       

      I tried applying patch "Patch 17537119: EBS Technology Codelevel Checker".

      as mentioned in readme file of the patch , i didnt get a patch recommendation summary.Can someone please help me out how to proceed?

       

      I am attaching the complete output of the checkdbpatch.sh command below

      [oracle@ebs etcc]$ ./checkDBpatch.sh contextfile=/u01/install/VISION/11.2.0/appsutil/EBSDB_ebs.xml

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

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

      |                     All rights reserved.                      |

      |             Oracle E-Business Suite Release 12.2              |

      |          Database EBS Technology Codelevel Checker            |

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

      Using context file from command line argument:

      /u01/install/VISION/11.2.0/appsutil/EBSDB_ebs.xml

      Starting Database EBS Technology Codelevel Checker, Version 120.38

      Fri Aug  5 02:41:03 EDT 2016

      Log file for this session : ./checkDBpatch_22048.log

      Bugfix XML file version: 120.0.12020000.32

      This file will be used for identifying missing bugfixes.

      Mapping XML file version: 120.0.12020000.5

      This file will be used for mapping bugfixes to patches.

      Identifying database release.

      Database release set to 11.2.0.4.

      Connecting to database.

      Database connection successful.

      Database EBSDB 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 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.6.

      DB-ETCC is compatible with this opatch version.

      Found patch records in the inventory.

      Checking Mapping XML file for 11.2.0.4.3

       

       

      Patch mapping not available.

      Patch mapping data is not available for 11.2.0.4 (PATCHSET UPDATE 11.2.0.4.3)

      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:

      12608451

      13417321

      14046443

      14255128

      16075609

      16299727

      16359751

      17250794

      17401353

      17901041

      18284763

      18485835

      18604144

      18689530

      18708921

      18730542

      18966843

      19291380

      19472320

      19487147

      19791273

      19835133

      19879144

      19896336

      19949371

      20245930

      20294666

      20476776

      20627866

      20825533

      20887355

      20936905

      20949558

      21028698

      21091431

      21614112

      21813400

      21321429

      21864513

      21904072

      21967332

      22024071

      22496904

      22731026

      22737974

      23054359

      ** Please 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.

      Stored Technology Codelevel Checker results in the database EBSDB successfully.

      Finished prerequisite patch testing : Fri Aug  5 02:41:15 EDT 2016

      Log file for this session: ./checkDBpatch_22048.log

       

      BR

      Dhiva