6 Replies Latest reply: Dec 26, 2012 5:08 PM by Hussein Sawwan-Oracle RSS

    OATM Migration Error Report

    kkrm333
      Hi,

      I am trying to migrate to OATM on my 11.5.9.2 apps before upgrading to R12.

      OATM migration progress report is showing

      Total No. Commands Commands % completion
      of commands in error in success of migration
      ------------ -------- ---------- -----------------------------------------
      80,180 5 80,037 99.82%

      When i checked for the errors, it is showing below error report.

      Migration Error
      ------------------------------------------------------------------------------------------------------------------------------------
      AMR AMR_GMD_SAMPLES_N2 INDEX X
      ORA-01950: no privileges on tablespace 'APPS_TS_TX_IDX'


      AMR AMR_GMF_LOT_COST_DETAILS_N1 INDEX X
      ORA-01950: no privileges on tablespace 'APPS_TS_TX_IDX'

      APPLSYS WF_LOCAL_USER_ROLES TABLE HZ_PARTY
      ORA-12801: error signaled in parallel query server P001
      ORA-01578: ORACLE data block corrupted (file # 445, block # 195035)
      ORA-01110: data file 445: '/u01/orauat/uatdata/uat/applsysd14.dbf'
      ORA-26040: Data block was loaded using the NOLOGGING option


      Please help.

      Thanks,
        • 1. Re: OATM Migration Error Report
          Hussein Sawwan-Oracle
          > Migration Error                                                                > ------------------------------------------------------------------------------------------------------------------------------------ > AMR     AMR_GMD_SAMPLES_N2             INDEX      X                            > ORA-01950: no privileges on tablespace 'APPS_TS_TX_IDX'                        Please run this command and see if it helps. SQL> alter user AMR quota unlimited on APPS_TS_TX_IDX; ORA-01950 Error While Executing Initial Build of Opportunities and Leads Bins [ID 309664.1] ORA-01950 AND ORA-06512 TRYING TO OPEN PERIOD [ID 1058205.6 > APPLSYS WF_LOCAL_USER_ROLES            TABLE      HZ_PARTY                     > ORA-12801: error signaled in parallel query server P001                        > ORA-01578: ORACLE data block corrupted (file # 445, block # 195035)            > ORA-01110: data file 445: '/u01/orauat/uatdata/uat/applsysd14.dbf'             > ORA-26040: Data block was loaded using the NOLOGGING option Workflow Tables: ORA-01578: ORACLE data block corrupted ORA-26040: Data block was loaded using the NOLOGGING option [ID 416476.1] How Block Corruption of Workflow Tables Can Cause Self Service Login Not to Work [ID 435523.1] During a Backup, WF_LOCAL_ROLES Is Showing Corrupt Block [ID 369535.1] Partitions in Workflow Local Tables are Automatically Switched to NOLOGGING [ID 433280.1] Thanks, Hussein                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
          • 2. Re: OATM Migration Error Report
            kkrm333
            Thank you for the quick update Hussein.

            After assigning quota unlimited, do i need to generate the migration commands for AMR tables and execute them again?

            Thanks,
            • 3. Re: OATM Migration Error Report
              Hussein Sawwan-Oracle
              kkrm333 wrote:
              Thank you for the quick update Hussein.

              After assigning quota unlimited, do i need to generate the migration commands for AMR tables and execute them again?

              Thanks,
              Yes, please.

              Thanks,
              Hussein
              • 4. Re: OATM Migration Error Report
                kkrm333
                Hi Hussein,

                As per m note OATM is failing with ORA-01652: unable to extend temp segment by 16 in tablespace APPS_TS_MEDIA [ID 341285.1],

                do i need to tun this and generate scripts?

                Delete from FND_TS_MIG_CMDS where migration_status != "SUCCESS" and owner ='AMR';
                commit;

                Thanks,
                • 5. Re: OATM Migration Error Report
                  kkrm333
                  Hi Hussein,

                  I have followed below notes and was able to solve the issue.

                  How to move objects left in the old tablespace after OATM migration? [ID 463271.1]
                  and the note you specified above Partitions in Workflow Local Tables are Automatically Switched to NOLOGGING [ID 433280.1].

                  Thanks,
                  • 6. Re: OATM Migration Error Report
                    Hussein Sawwan-Oracle
                    kkrm333 wrote:
                    Hi Hussein,

                    I have followed below notes and was able to solve the issue.

                    How to move objects left in the old tablespace after OATM migration? [ID 463271.1]
                    and the note you specified above Partitions in Workflow Local Tables are Automatically Switched to NOLOGGING [ID 433280.1].

                    Thanks,
                    Thanks for the update and for sharing the solution.

                    Thanks,
                    Hussein