3 Replies Latest reply on Nov 4, 2015 2:11 PM by Srini Chavali-Oracle

    Errors during OATM migration

    2934752

      Dear All,

       

      I am in middle of OATM migration and faced error during executing migration commands. when I run "Run migration progress report" it hung at 98.49% since last 48 hours and the report "Run migration error report" shows the following errors:

      Note: we are on R12.1.3 version

       

      ORA-00060: deadlock detected while waiting for resource

      INV     MTL_ABC_COMPILES               TABLE      X
      ORA-00060: deadlock detected while waiting for resource

      JTF     JTF_NOTES_TL_C1                INDEX      INTERMEDIA
      ORA-29874: warning in the execution of ODCIINDEXALTER routine
      ORA-29960: line 1,
      DRG-10595: ALTER INDEX JTF_NOTES_TL_C1 failed
      DRG-11422: linguistic initialization failed
      DRG-11446: supplied knowledge base file /erp/db/oracle/NEWDEV/db/tech_st/11.2.0/ctx/data/enlx/droldUS.dat not installed

       

      ORA-00060: deadlock detected while waiting for resource

      PV      PV_ENTY_ATTR_TEXTS_U2          INDEX      INTERMEDIA
      ORA-29874: warning in the execution of ODCIINDEXALTER routine
      ORA-29960: line 1,
      DRG-10595: ALTER INDEX PV_ENTY_ATTR_TEXTS_U2 failed
      DRG-11422: linguistic initialization failed
      DRG-11446: supplied knowledge base file /erp/db/oracle/NEWDEV/db/tech_st/11.2.0/ctx/data/enlx/droldUS.dat not installed

      ORA-00942: table or view does not exist

      APPS    spSparesSource838_TAB$xd_sp    DISABLE_PO spSparesSourc
                                             LICY       e838_TAB
      ORA-00942: table or view does not exist

      APPS    spSparesSource838_TAB$xd_up    DISABLE_PO spSparesSourc
                                             LICY       e838_TAB
      ORA-00942: table or view does not exist

      APPS    spTravelTimeExtra857_TAB$xd_dp DISABLE_PO spTravelTimeE
                                             LICY       xtra857_TAB

       

      Please advise me accordingly !

       

      Regards,

      Anas