This discussion is archived
6 Replies Latest reply: Dec 26, 2012 3:08 PM by Hussein Sawwan-Oracle RSS

OATM Migration Error Report

kkrm333 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    > 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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points