3 Replies Latest reply on May 11, 2017 10:47 AM by Delphix It ..

    adop exiting with status = 1 (Fail) - ORA-06512: at "APPS.AD_ZD_ADOP

    Delphix It ..

      Hi Experts,

       

      I'm facing following error while trying to run adop phase=cleanup on EBS 12.2.4 instance with DB 12.1.0.2.0 version.

      OS: rhel 6.4 64 bit

       

      [applvis@at12c2-app patch]$ adop phase=cleanup cleanup_mode=full workers=8

       

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

       

      Validating credentials.

       

      Initializing.

          Run Edition context  : /u01/oracle/VIS/fs2/inst/apps/VIS_at12c2-app/appl/admin/VIS_at12c2-app.xml

          Patch edition context: /u01/oracle/VIS/fs1/inst/apps/VIS_at12c2-app/appl/admin/VIS_at12c2-app.xml

          Patch file system free space: 174.15 GB

       

      Validating system setup.

          Node registry is valid.

          [ERROR]     Failed to execute SQL statement:

         declare

          l_msg varchar2(4000);

        begin

          ad_zd_adop.adop_database_validations(l_msg);

          dbms_output.put_line(l_msg);

        end;

       

          [ERROR]     Error Message:

          [ERROR]     ORA-00942: table or view does not exist

          [ERROR]     ORA-06512: at "APPS.AD_ZD_ADOP", line 2829

          [ERROR]     ORA-06512: at line 4 (DBD ERROR: OCIStmtExecute)

          [UNEXPECTED]Error occurred performing database sanity checks

       

       

      [STATEMENT] Please run adopscanlog utility, using the command

       

      "adopscanlog -latest=yes"

       

      to get the list of the log files along with snippet of the error message corresponding to each log file.

       

       

      adop exiting with status = 1 (Fail)

       

       

      Below adop phase completed successfully without any issues.

      adop phase=prepare

      adop phase=apply

      adop phase=finalize

      adop phase=cutover

      After cutover, all application and services are working fine.

       

      Status of AD_ZD_ADOP is valid.

      OWNER   OBJECT_NAME     OBJECT_TYPE        STATUS

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

      APPS    AD_ZD_ADOP      PACKAGE            VALID
      APPS    AD_ZD_ADOP      PACKAGE BODY       VALID

       

      Thanks,

      Ankur