5 Replies Latest reply on May 28, 2018 7:58 PM by VishnuVinnakota

    ETCC error on database 12c?

    Beauty_and_dBest

      EBS 12.2.7

      12c

      OL6

       

       

      Hi ALL,

       

      I run ETCC in our appstier and I got cleared up:

       

      $ ./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:

      /u01/appcrp/CRP/fs2/inst/apps/CRP_lehebsr12/appl/admin/CRP_lehebsr12.xml

       

      Starting Application Tier Technology Codelevel Checker

      Version: 120.0.12020000.33.

      Wed May 23 13:03:23 PHT 2018

      Log file for this session: /home/appcrp/etcc/checkMTpatch_151412.log

       

      Bugfix XML file version: 120.0.12020000.34

      This file will be used for identifying missing bugfixes.

       

      Mapping XML file version: 120.0.12020000.19

      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.10 codelevel supports storing the results in the database.

       

      Checking for ETCC results table.

      Table to store results already exists in database.

       

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

      Oracle Forms and Reports

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

      Now examining product Oracle Forms and Reports.

       

      Oracle Home = /u01/appcrp/CRP/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.

      These results have been stored in the database.

       

      Checking required bugfixes for RSF within Forms 10.1.0.5.0.

      All required bugfixes are present for RSF within Forms.

      These results have been stored in the database.

       

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

      Oracle Fusion Middleware (FMW) - Web Tier

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

      Now examining product Oracle Fusion Middleware (FMW) - Web Tier.

       

      Oracle Home = /u01/appcrp/CRP/fs2/FMW_Home/webtier.

      Product Version = 11.1.1.9.0

      Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.

      All required bugfixes are present for FMW - Web Tier.

      These results have been stored in the database.

       

      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.

      These results have been stored in the database.

       

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

      Oracle Fusion Middleware (FMW) - oracle_common

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

      Now examining product Oracle Fusion Middleware (FMW) - oracle_common.

       

      Oracle Home = /u01/appcrp/CRP/fs2/FMW_Home/oracle_common.

      Product Version = 11.1.1.9.0

      Checking required bugfixes for FMW - oracle common 11.1.1.9.0.

      All required bugfixes are present for FMW - oracle common.

      These results have been stored in the database.

       

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

      Oracle WebLogic Server (WLS)

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

      Now examining product Oracle WebLogic Server (WLS).

       

      Oracle Home = /u01/appcrp/CRP/fs2/FMW_Home/wlserver_10.3.

      Product Version = 10.3.6.0.171017

       

      Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.

       

      Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.171017.

      All required patches are present for Oracle WebLogic Server (WLS).

      These results have been stored in the database.

       

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

       

      All required one-offs are confirmed as present.

       

      Finished checking prerequisite patches for File Edition: run.

      Wed May 23 13:03:54 PHT 2018

       

      Log file for this session: /home/appcrp/etcc/checkMTpatch_151412.log

       

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

       

       

      The I copied the ETCC folder from apps-server to database-server and run : 

       

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

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

       

      Oracle Bare Metal Cloud Service utilities found.

       

      Running on Oracle Bare Metal Cloud Service.

       

      Using context file from currently set database environment:

      /u02/app/oracle/oradata/CRP/12.1.0/appsutil/CRP_lehoda01.xml

       

      Running on Oracle Bare Metal Cloud Services.

       

      Starting Database EBS Technology Codelevel Checker, Version 120.57

      Wed May 23 13:11:36 +08 2018

      Log file for this session : ./checkDBpatch_6594.log

       

      Bugfix XML file ./txk_R1220_BMC_base_bugs.xml version: 120.0.12020000.33

      This file will be used for identifying missing bugfixes.

       

      Mapping XML file ./txk_R1220_BMC_mappings.xml version: 120.0.12020000.9

      This file will be used for mapping bugfixes to patches.

       

       

      [WARNING] DB-ETCC: Bugfix XML file (./txk_R1220_BMC_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.

       

      Multitenant identified.

      - Container database (CDB) identified via s_cdb_name is       <cdb_name oa_var="s_cdb_name"/>

      - Pluggable database (PDB) identified via s_pdb_name is       <pdb_name oa_var="s_pdb_name"/>

       

      Connecting to database.

      Database connection successful.

       

      Database     alter session set container = "     <pdb_name oa_var="s_pdb_name"/>"

                                      *

      ERROR at line 1:

      ORA-65090: operation only allowed in a container database

       

       

      CRP is in  mode.

       

      Identifying APPS and APPLSYS schema names.

      Failed to identify APPS schema.

      Enter the Applications 'APPS' user : apps

       

      - APPS schema :

      Failed to identify APPLSYS schema.

      Enter the Applications 'APPLSYS' user : apps

       

      - APPLSYS schema : apps

       

      Checking for DB-ETCC results table.

      [WARNING] DB-ETCC:

        The database is not open in READ-WRITE mode.

        Could not create table to store DB-ETCC results.

      alter session set container = "      <pdb_name oa_var="s_pdb_name"/>"

                                  *

      ERROR at line 1:

      ORA-65090: operation only allowed in a container database

       

       

      CREATE OR REPLACE SYNONYM .TXK_TCC_RESULTS FOR apps.TXK_TCC_RESULTS

                                *

      ERROR at line 1:

      ORA-00995: missing or invalid synonym identifier

       

       

       

      Checking if InMemory option is enabled.

      InMemory option is enabled in the database.

      ./checkDBpatch.sh: line 753: [: too many arguments

       

      ASM storage identified.

       

      Checking Bugfix XML file for 12.1.0.2_BMCS_ASM

       

      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_BMCS_ASM

       

      Patch mapping not available.

      Patch mapping data is not available for 12.1.0.2 - InMemory (No Bundle Patch applied)

       

      Some required one-off bugfixes are missing from the Database ORACLE_HOME.

      The missing bugfixes are:

      24007737

      20839705

      26911000

      25305405

      20382309

      22518784

      22828827

      26196152

      25963024

      22743059

      26844281

      19370504

      23321125

      22747454

      22828765

       

       

      [WARNING] Database mode is 0:

      Open the database in READ-WRITE mode and then rerun DB-ETCC. Otherwise the results will not be stored in the database.

       

      Finished checking fixes for Oracle Database: Wed May 23 13:18:14 +08 2018

       

      Log file for this session: ./checkDBpatch_6594.log

       

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

       

       

       

      Please help how to correct my etcc database run? 

       

       

       

      Kind regards,

      jc

        • 1. Re: ETCC error on database 12c?
          Beauty_and_dBest

          Hi ALL,

           

          I found this solution. But why is that  this one works?

           

          ./checkDBpatch.sh  cloud=n baremetal=n

           

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

          |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 command line argument:

          /u02/app/oracle/oradata/CRP/12.1.0/appsutil/CRP_lehoda01.xml

           

          Starting Database EBS Technology Codelevel Checker, Version 120.57

          Wed May 23 13:23:17 +08 2018

          Log file for this session : ./checkDBpatch_17468.log

           

          Bugfix XML file ./txk_R1220_DB_base_bugs.xml version: 120.0.12020000.41

          This file will be used for identifying missing bugfixes.

           

          Mapping XML file ./txk_R1220_DB_mappings.xml version: 120.0.12020000.15

          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 CRP 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: 25305405  ->  Patch 25305405

            Missing Bugfix: 26911000  ->  Patch 27062381

           

          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 25305405

          - Filename: p25305405_121020_Linux-x86-64.zip

           

            Patch 27062381

          - Filename: p27062381_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 27117154 [12.1.0.2.0 version]

          - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JAN 2018

           

          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 CRP successfully.

           

          Finished checking fixes for Oracle Database: Wed May 23 13:23:27 +08 2018

           

          Log file for this session: ./checkDBpatch_17468.log

           

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

           

           

          Thanks,

          • 2. Re: ETCC error on database 12c?
            Beauty_and_dBest

            Hi ALL,

             

            Can I edit adcfgclone.pl to  edit this command? >> ./checkDBpatch.sh  cloud=n baremetal=n

             

             

            Thanks,

            • 3. Re: ETCC error on database 12c?
              VishnuVinnakota

              Hi,

               

                 Not sure how the wrapper scripts work but you can give a try. Make sure you have dbhome backup before you do this.

               

              Thanks,

              Vishnu

              • 4. Re: ETCC error on database 12c?
                Beauty_and_dBest

                Thanks Vishnu,

                 

                Why need to backup when it is a read only reporting program etcc?

                 

                 

                Kind regards,

                • 5. Re: ETCC error on database 12c?
                  VishnuVinnakota

                  Hi,

                   

                    adcfgclone can be tricky since configures your home, runs Autoconfig etc. So recommended it.. However, You can try it since its only about checkdbpatch. Good luck. Update me the results.

                   

                  Thanks,

                  Vishnu