This discussion is archived
3 Replies Latest reply: Oct 8, 2012 6:37 AM by 860213 RSS

OATM migration

user9174441 Newbie
Currently Being Moderated
Dear ,

i try to migrate my tablespaces using OATM utility , my application version 11.5.10.2 and DB 11.2.0.1

now i run migrate all schemas and i run from Wednesday and till now not finish .

when i check status report it seems 98.18% and there are three processes running on OS .

there are some old tablespaces having used data , and tablespace APPLSYSX contain some objects such INDEX PARTITION and INDEX .

how can i solve it .

Regards ,,,
  • 1. Re: OATM migration
    860213 Pro
    Currently Being Moderated
    how can i solve it .
    OATM migration speed depends on various factor including db size, CPU, memory etc...

    I believe you should wait for some time and see if it is moving.


    Please see below metalink note, it suggests some of the ways to improve speed of OATM migration:-
    Oatm Migration Is Running Very Long On Fnd_lobs_ctx Index For More Than 35hrs, How to speed Up This OATM Migration Step? [ID 1362261.1]
    FAQ - OATM - Oracle Applications Tablespace Migration [ID 418225.1]


    Thanks,
    JD
  • 2. Re: OATM migration
    user9174441 Newbie
    Currently Being Moderated
    Dear ,

    i found in alert log :

    ORA-01575: timeout waiting for space management resource

    and migration still on 98.18% and not finish yet .

    Regards ,,,
  • 3. Re: OATM migration
    860213 Pro
    Currently Being Moderated
    Are you seeing any locks or space contention on newly build tablespaces?

    Thanks,
    JD

Legend

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