5 Replies Latest reply on Oct 28, 2019 11:16 AM by Beauty_and_dBest

    EBS 12.2.8  - adop -status error

    Beauty_and_dBest

      EBS 12.2.8

      12c

      OL6

       

       

      Hi ALL,

       

      I have pending patch running on our EBS instance.

      I want to check what is the status of the pending patch, because I am not sure what phase I am in.

       

      So I run > adop -status     .....but I got error below:

       

      # su - appp1228

      Last login: Mon Oct 28 09:31:07 PST 2019 on pts/0

       

        E-Business Suite Environment Information

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

        RUN File System           : /u04/appp1228/P1228/fs1/EBSapps/appl

        PATCH File System         : /u04/appp1228/P1228/fs2/EBSapps/appl

        Non-Editioned File System : /u04/appp1228/P1228/fs_ne

       

        DB Host: trnsrvr.oraclecloud.com  Service/SID: P1228

       

        Sourcing the RUN File System ...

       

      [appp1228@trnsrvr ~]$ adop -status

       

      Enter the APPS password:

      *******FATAL ERROR*******

      PROGRAM : (/u04/appp1228/P1228/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)

      TIME    : Mon Oct 28 09:38:36 2019

      FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]

      MESSAGES:

      SQLPLUS error: buffer=

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Mon Oct 28 09:38:35 2019

       

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

       

      SQL> SQL> Connected.

      SQL>   select ad_zd_adop.validate_session_id('') from dual

                                                       *

      ERROR at line 1:

      ORA-04063: package body "APPS.AD_ZD_ADOP" has errors

       

      Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

      With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

       

      STACK TRACE

      at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168

              TXK::Error::abort('TXK::Error', 'HASH(0x27f80e0)') called at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299

              TXK::Common::doError('TXK::SQLPLUS=HASH(0x4745450)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...', undef) called at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314

              TXK::Common::setError('TXK::SQLPLUS=HASH(0x4745450)', 'SQLPLUS error: buffer=\x{a}\x{a}SQL*Plus: Release 10.1.0.5.0 - Produc...') called at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 832

              TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x4745450)', 0) called at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 234

              TXK::SQLPLUS::execute('TXK::SQLPLUS=HASH(0x4745450)', 'HASH(0x4aef4c0)') called at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 618

              TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x45e23d8)', '  select ad_zd_adop.validate_session_id(\'\') from dual\x{a}') called at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573

              TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x45e23d8)', '  select ad_zd_adop.validate_session_id(\'\') from dual\x{a}') called at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 504

              ADOP::GlobalVars::_getADOPStatus(undef, undef) called at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 2274

              ADOP::GlobalVars::_ValidateArgs() called at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 3120

              ADOP::GlobalVars::ValidateArgs('ADOP::GlobalVars') called at /u04/appp1228/P1228/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/AdopMain.pm line 1842

              ADOP::AdopMain::adopMain('ADOP::AdopMain') called at /u04/appp1228/P1228/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 148

       

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

      [appp1228@trnsrvr ~]$ adopscanlog -latest=yes

       

      Scanning /u04/appp1228/P1228/fs_ne/EBSapps/log/adop/46/ directory ...

      /u04/appp1228/P1228/fs_ne/EBSapps/log/adop/46/20191010_153602/prepare/trnsrvr/adconfig.log:

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

       

      Lines #(3062-3066):

      [ FND_VALIDATION_LEVEL ]

      Application Id : 0

      Profile Value  : ERROR

      Level Name: SITE

      INFO           : Updated/created profile option value.

       

      Lines #(3068-3072):

      [ FND_FUNCTION_VALIDATION_LEVEL ]

      Application Id : 0

      Profile Value  : ERROR

      Level Name: SITE

      INFO           : Updated/created profile option value.

       

      Lines #(3074-3078):

      [ FRAMEWORK_VALIDATION_LEVEL ]

      Application Id : 0

      Profile Value  : ERROR

      Level Name: SITE

      INFO           : Updated/created profile option value.

      [appp1228@trnsrvr ~]$

       

       

      I already recompile invalid objects, but the error still persist. 

       

      SQL> select owner||', '||object_name||', '||object_type from dba_objects where status != 'VALID';

       

      OWNER||','||OBJECT_NAME||','||OBJECT_TYPE

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

      APPS, AD_ZD_ADOP, PACKAGE BODY

      APPS, FND_DIAGNOSTICS, PACKAGE BODY

       

       

      SQL> alter package AD_ZD_ADOP compile;

       

      Warning: Package altered with compilation errors.

      SQL> show errors

      No errors.

       

       

      I also run adgrants.sql many times, I do not know which adgrants is the right one

      Or do I just run it over and over until the error is gone?

       

       

       

      Please help...

       

       

      Kind regards,

      jc

       

       

      Now

       

       

       

        • 1. Re: EBS 12.2.8  - adop -status error
          Beauty_and_dBest

          Hi ALL,

           

          I am running again adgrants.sql  but I got warning below:

           

          The following ERRORS and WARNINGS have been encountered during this adgrants session:

           

          TIME_STAMP           SESSION_ID LOG_MODULE                                 LOG_LEVEL

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

          LOG_MESSAGE

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

          2019/10/28 10:46:34         278 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

          ORA-04042: procedure, function, package, or package body does not exist, SQL: grant EXECUTE on "DBMS_SCHEMA_COPY" to "SYSTEM" with grant option

           

          2019/10/28 10:46:34         278 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

          ORA-04042: procedure, function, package, or package body does not exist, SQL: grant EXECUTE on "DBMS_SCHEMA_COPY" to "APPS"

           

          2019/10/28 10:46:35         278 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

          ORA-00942: table or view does not exist, SQL: grant WRITE on "DIRECTORY FND_DIAG_DIR" to "APPS"

           

          2019/10/28 10:46:35         278 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

          ORA-00942: table or view does not exist, SQL: grant READ on "DIRECTORY FND_DIAG_DIR" to "APPS"

           

          Grants given by this script have been written to the ad_zd_logs table.

          You can run $AD_TOP/sql/ADZDSHOWLOG.sql to produce a report showing these grants.

           

          Commit complete.

           

           

          Is the above warning can be ignored?

           

           

          Please help....

           

           

          Kind regards,

          • 2. Re: EBS 12.2.8  - adop -status error
            yoonas

            APPS, AD_ZD_ADOP, PACKAGE BODY

            APPS, FND_DIAGNOSTICS, PACKAGE BODY

             

            alter package AD_ZD_ADOP compile body;

             

            Please compile package body and share errors

             

            Regards,

            Yoonas

            • 3. Re: EBS 12.2.8  - adop -status error
              Beauty_and_dBest

              Thanks Yoonas,

               

              I run utlrp.sql  and the invalid objects are cleared.

              Are the above warning errors from adgrants ignorable?

               

              Kind regards,

              • 4. Re: EBS 12.2.8  - adop -status error
                yoonas

                see if this helps you

                 

                After 28426427 from ad/txk 10 patches getting grant warning on DBMS_UPG_ objects (Doc ID 2507343.1)