3 Replies Latest reply: Dec 7, 2012 2:49 PM by Hussein Sawwan-Oracle RSS

    How to skip the job during 12.1.1 upgrade automatically

    User426388
      Hi All,

      We have completed our upgrade to R12.1.3 from 11.5.10.2 and during the upgrade process we have come across a worker failure for MSDOPDCODE.sql as below

      ERROR at line 1:
      ORA-33292: Insufficient permissions to access analytic workspace APPS.ODPCODE
      using the specified access mode.
      ORA-06512: at "SYS.DBMS_AW", line 67
      ORA-06512: at "SYS.DBMS_AW", line 131
      ORA-06512: at "SYS.DBMS_AW", line 977
      ORA-06512: at "SYS.DBMS_AW", line 930
      ORA-33262: Analytic workspace APPS.ODPCODE does not exist.
      ORA-06512: at "SYS.DBMS_AW", line 901
      ORA-06512: at "APPS.MSD_AW_LOADER", line 10
      ORA-06512: at line 3

      and we had skipped the worker. We are thinking of a way to automate this process for the next round of upgrade by updating the upgrade driver, but we when we checked the driver, we see these lines only

      $>grep MSDODPCODE.sql u_merged.drv
      copy msd patch/115/sql MSDODPCODE.sql 120.14
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDABOUT.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDABOUTINFO.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACCESSRWLIB.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACCMSDIMS.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACCMSGRP.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVEFOLDER.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYCATAL.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYENTRY.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYERROR.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYFORMU.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYRETCO.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYRETVA.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYTEXT.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDADDASGENTRY.sql
      .
      .
      .
      .
      .
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSD__OBCAT.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSD__OBENTRY.sql
      sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSD__OBPROP.sql
      # file-version-parsed msd patch/115/sql MSDODPCODE.sql 120.14
      # noexec msd patch/115/sql MSDODPCODE.sql
      $>

      So, I didn't see any specific line which is executing the sql. Can you guys suggest a better aproach to automate this process?

      Thanks
        • 1. Re: How to skip the job during 12.1.1 upgrade automatically
          Hussein Sawwan-Oracle
          965417 wrote:
          Hi All,

          We have completed our upgrade to R12.1.3 from 11.5.10.2 and during the upgrade process we have come across a worker failure for MSDOPDCODE.sql as below

          ERROR at line 1:
          ORA-33292: Insufficient permissions to access analytic workspace APPS.ODPCODE
          using the specified access mode.
          ORA-06512: at "SYS.DBMS_AW", line 67
          ORA-06512: at "SYS.DBMS_AW", line 131
          ORA-06512: at "SYS.DBMS_AW", line 977
          ORA-06512: at "SYS.DBMS_AW", line 930
          ORA-33262: Analytic workspace APPS.ODPCODE does not exist.
          ORA-06512: at "SYS.DBMS_AW", line 901
          ORA-06512: at "APPS.MSD_AW_LOADER", line 10
          ORA-06512: at line 3

          and we had skipped the worker. We are thinking of a way to automate this process for the next round of upgrade by updating the upgrade driver, but we when we checked the driver, we see these lines only

          $>grep MSDODPCODE.sql u_merged.drv
          copy msd patch/115/sql MSDODPCODE.sql 120.14
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDABOUT.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDABOUTINFO.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACCESSRWLIB.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACCMSDIMS.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACCMSGRP.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVEFOLDER.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYCATAL.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYENTRY.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYERROR.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYFORMU.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYRETCO.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYRETVA.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDACTIVITYTEXT.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSDADDASGENTRY.sql
          .
          .
          .
          .
          .
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSD__OBCAT.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSD__OBENTRY.sql
          sql msd patch/115/sql MSDODPCODE.sql none none none sqlplus &phase=dat checkfile:msd:patch/115/sql:MSD__OBPROP.sql
          # file-version-parsed msd patch/115/sql MSDODPCODE.sql 120.14
          # noexec msd patch/115/sql MSDODPCODE.sql
          $>

          So, I didn't see any specific line which is executing the sql. Can you guys suggest a better aproach to automate this process?

          Thanks
          Please see (Patch 6678700 Worker Fails On Applying MSDODPCODE.sql With ORA-33292 Insufficient Permissions To Access Analytic Workspace APPS.ODPCODE; ORA-33262: Analytic workspace ODPCODE does not exist. [ID 1054417.1]).

          You should not skip the worker unless you are instructed to do so by Oracle Support. Please run "sqlplus -s APPS/***** @<Path to $MSD_TOP>/patch/115/sql/MSDODPCODE.sql" manually after fixing the issue as per the doc and check then.

          Thanks,
          Hussein
          • 2. Re: How to skip the job during 12.1.1 upgrade automatically
            User426388
            Thanks Hussein, we followed the note MSDODPCODE.SQL Fails Applying U6678700.Drv [ID 1151274.1] as we are not using ODP and skipped the worker, so we are looking out to skip this automatically next time.
            • 3. Re: How to skip the job during 12.1.1 upgrade automatically
              Hussein Sawwan-Oracle
              965417 wrote:
              Thanks Hussein, we followed the note MSDODPCODE.SQL Fails Applying U6678700.Drv [ID 1151274.1] as we are not using ODP and skipped the worker, so we are looking out to skip this automatically next time.
              You can either skip it manually or edit the patch driver file and comment this line. Please note that the latter is not supported (but it would work), so make sure you log a SR and get a confirmation from Oracle support before you do so. Also, please try this in your next upgrade before your production upgrade.

              Thanks,
              Hussein