3 Replies Latest reply: Oct 8, 2012 8:37 AM by 860213 RSS

    OATM migration

    user9174441
      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
          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
            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
              Are you seeing any locks or space contention on newly build tablespaces?

              Thanks,
              JD