4 Replies Latest reply on Apr 17, 2019 8:07 AM by VishnuVinnakota

    adgrants.sql has error

    Beauty_and_dBest

      Upgrading EBS 12.0.6 to EBS 12.2.7

      Db is already 12.1.0.2

       

      Hi ALL,

       

      I am already in step: Upgrade AD to latest code level

       

      1. Execute adgrants by following the instructions in the readme of Patch 28426427:R12.AD.C
      2. Apply Patch 25820806 (R12.AD.C.Delta.10) and Patch 27254132:R12.AD.C in hotpatch mode using ADOP
      $ adop phase=apply patches=25820806,27254132 merge=yes hotpatch=yes
      3. Apply critical AD patches as merge patch
      Patch 28394214:R12.AD.C
      Patch 27638770:R12.AD.C
      Patch 28714940:R12.AD.C
      Patch 28986462:R12.AD.C
      Patch 28882245:R12.AD.C
      Patch 28426427:R12.AD.C
      $ adop phase=apply patches=<Your first critical AD patch>,<Your second critical AD patch> hotpatch=yes merge=yes

       

       

      I am on step 1. above,

      I run adgrants.sql on the dbTier, but I got error below

       

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

       

       

      TIME_STAMP           SESSION_ID LOG_MODULE                                 LOG_LEVEL

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

      LOG_MESSAGE

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

      2019/04/11 20:00:16         287 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/04/11 20:00:16         287 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/04/11 20:00:17         287 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/04/11 20:00:17         287 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"

       

      2019/04/11 20:00:17         287 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

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

       

      2019/04/11 20:00:17         287 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

      ORA-00942: table or view does not exist, SQL: grant SELECT on "XDB$MOVESCHEMATAB" to "APPS"

       

      2019/04/11 20:00:17         287 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

      ORA-00942: table or view does not exist, SQL: grant INSERT on "XDB$MOVESCHEMATAB" to "APPS"

       

      2019/04/11 20:00:17         287 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

      ORA-00942: table or view does not exist, SQL: grant UPDATE on "XDB$MOVESCHEMATAB" to "APPS"

       

      2019/04/11 20:00:17         287 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

      ORA-00942: table or view does not exist, SQL: grant DELETE on "XDB$MOVESCHEMATAB" to "APPS"

       

      2019/04/11 20:00:17         287 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

      ORA-00942: table or view does not exist, SQL: grant SELECT on "XDB$MOVESCHEMATAB" to "SYSTEM" with grant option

       

      2019/04/11 20:00:17         287 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

      ORA-00942: table or view does not exist, SQL: grant INSERT on "XDB$MOVESCHEMATAB" to "SYSTEM" with grant option

       

      2019/04/11 20:00:17         287 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

      ORA-00942: table or view does not exist, SQL: grant UPDATE on "XDB$MOVESCHEMATAB" to "SYSTEM" with grant option

       

      2019/04/11 20:00:17         287 ad.plsql.ad_zd_sys.GIVE_PRIVILEGE          WARNING

      ORA-00942: table or view does not exist, SQL: grant DELETE on "XDB$MOVESCHEMATAB" to "SYSTEM" with grant option

       

       

      13 rows selected.

       

       

      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.

       

      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

       

       

      Please help.....

       

       

      Kind regards,

      jc

        • 1. Re: adgrants.sql has error
          Aldrich

          What account are you running adgrants as?

          • 2. Re: adgrants.sql has error
            VishnuVinnakota

            Hi,

             

            You need to run adgrants.sql as below:

             

            cd $ORACLE_HOME/appsutil/admin

            sqlplus '/as sysdba'

            @adgrants.sql APPS

             

            Remember if you applying all latest AD, TXK patches. Once check the adgrants.sql Header version and run the latest one.

             

            grep -i header adgrants.sql

             

            Thanks,

            Vishnu

            • 3. Re: adgrants.sql has error
              Beauty_and_dBest

              Thanks ALL,

               

              The most "dreaded" and longest patch to apply is

               

              The has like 80,000+ jobs to run?

               

              Apply merged patch with adpatch

               

              Apply the newly merged Release 12.2.0 upgrade driver (For example, $AU_TOP/patch/115/driver/u_merged.drv) to the Run File System with the following command:

               

              $ adpatch options=nocopyportion,nogenerateportion

               

               

              This is where I got lots of failed workers.

               

               

              Is there a way to speed it up?

               

              Kind regards,

              • 4. Re: adgrants.sql has error
                VishnuVinnakota

                Hi,

                 

                   Make sure you have more CPUs, in case its a VM, ask your System Admin to add more CPUs so that you can increase the workers to 32. If your Server supports, you can go upto 64 but ideally 32 is good enough.

                 

                  80000 jobs are common during upgrades and increasing the workers is the only option you can speed up. It usually should complete ins 6-7 hours maximum time if you can use 32-48 workers.

                 

                Thanks,

                Vishnu