4 Replies Latest reply: Jun 1, 2013 12:56 PM by Hussein Sawwan-Oracle RSS

    R12 Upgrade (Patch 7303030) FAILED: file MSDODPCODE.sql on worker  2

    Kwame Polisya
      Hi all,

      Am in the process of upgrading our system from R12.0.4 64bit to 12.1.1 which is running on RHEL 5.3 single node with database version 11.2.0.3.
      During the upgrade i got an error:- FAILED: file MSDODPCODE.sql on worker 2

      On drilling down in adwork002.log it mentioned that "not connected to oracle".
      So checking in the alert log file i found an error which led me to the trace file which is listed below. I know for a fact its something to do with OLAP as it wasnt migrated when i did the migration from 32bit to 64bit.

      Trace file /data/db/tech_st/11.2.0/admin/bkp_erpbkp/diag/rdbms/bkp/bkp/trace/bkp_ora_18967.trc
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      ORACLE_HOME = /data/db/tech_st/11.2.0
      System name: Linux
      Node name: erpbkp.tcaa.go.tz
      Release: 2.6.18-128.el5
      Version: #1 SMP Wed Dec 17 11:41:38 EST 2008
      Machine: x86_64
      Instance name: bkp
      Redo thread mounted by this instance: 1
      Oracle process number: 42
      Unix process pid: 18967, image: oracle@erpbkp.tcaa.go.tz


      *** 2013-05-31 17:02:05.441
      *** SESSION ID:(886.6019) 2013-05-31 17:02:05.441
      *** CLIENT ID:() 2013-05-31 17:02:05.441
      *** SERVICE NAME:(bkp) 2013-05-31 17:02:05.441
      *** MODULE NAME:(SQL*Plus) 2013-05-31 17:02:05.441
      *** ACTION NAME:() 2013-05-31 17:02:05.441

      Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2B6348806ED7] [PC:0x47F8EB4, __intel_new_memcpy()+2164] [flags: 0x0, count: 1]
      Incident 20339 created, dump file: /data/db/tech_st/11.2.0/admin/bkp_erpbkp/diag/rdbms/bkp/bkp/incident/incdir_20339/bkp_ora_18967_i20339.trc
      ORA-07445: exception encountered: core dump [__intel_new_memcpy()+2164] [SIGSEGV] [ADDR:0x2B6348806ED7] [PC:0x47F8EB4] [Address not mapped to object] []

      ssexhd: crashing the process...
      Shadow_Core_Dump = PARTIAL
      ksdbgcra: writing core file to directory '/data/db/tech_st/11.2.0/admin/bkp_erpbkp/diag/rdbms/bkp/bkp/cdump'

      Kindly assist.
      Thanks.
        • 1. Re: R12 Upgrade (Patch 7303030) FAILED: file MSDODPCODE.sql on worker  2
          Hussein Sawwan-Oracle
          Ensure you have no invalid objects and if any exist, then compile them and restart the failed worker. Please also make sure the number of workers you are using to run this upgrade is not more than (1-1.5 * CPUs).

          ORA-600/ORA-7445/ORA-700 Error Look-up Tool [ID 153788.1]
          ORA-7445 [memcpy] [ID 310531.1]
          Full Database Export Fails With ORA-03113 and ORA-01041 After Migrated To 64bit [ID 1497414.1]

          Please confirm that you have the patches in the following docs applied.

          Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade [ID 761570.1]
          Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2 [ID 1058763.1]

          If you still have the same issue, then please log a SR and upload the database log/trace files generated to Oracle support.

          Thanks,
          Hussein
          • 2. Re: R12 Upgrade (Patch 7303030) FAILED: file MSDODPCODE.sql on worker  2
            Kwame Polisya
            Hi Hussein,

            Crosschecked through all documents you have stated and all seems fine.
            I have logged an SR and will update as soon as i get a solution.
            • 3. Re: R12 Upgrade (Patch 7303030) FAILED: file MSDODPCODE.sql on worker  2
              Kwame Polisya
              Hussein,
              As promised am here to update you on how we solved the issue through Oracle Support.
              EPB AW's Cannot Be Attached Or Do Not Exist [ID 795247.1].

              Now this applies only for the AW's belonging to EPB as for the rest i deleted them manually.
              Restarting the failed worker brought about this error:-
              sqlplus -s APPS/***** @/apps/apps/apps_st/appl/msd/12.0.0/patch/115/sql/MSDODPCODE.sql
              begin
              *
              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

              So i followed the below doc and all is well now. The actual problem is 32bit AW's in a 64bit Database.

              Thanks alot and good evening.
              ORA-33292 Insufficient permissions to access analytic workspace APPS.ODPCODE Error When Applying Patch 9058835 [ID 977196.1]
              • 4. Re: R12 Upgrade (Patch 7303030) FAILED: file MSDODPCODE.sql on worker  2
                Hussein Sawwan-Oracle
                Thanks for the update and for sharing the solution!

                Have a good weekend.

                Thanks,
                Hussein