Hanging Import Sessions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Hanging Import Sessions

  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Hanging Import Sessions

    Hi:

    I've two databases version 9.2.0.8, and we copy changes from branch to HO by Export/Import. It was working fine until I applied 9208 patch set on OCS recommendation. After applying the patchset, when importing from a user who has a DBA Role, the import hangs forever. When the DBA role is revoked the import is completed successfully. However, I need to import it with a user with DBA Role because the export file is exported from a user who has DBA Role.

    Any suggestions?

    Best Regards.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    have your checked on Metalink if there are 9208 bugs related to the situation you have stated?

    also when it's hanging what wait event are you seeing?

    thanks

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    1) Try with revoking DBA and granting IMPORT_FULL_DATABASE
    2) Support pando. Look at the wait events.
    To do so, start the imp using interactive mode, enter the username and password. Then the imp will start asking more questions.. stop here, start SQL PLus and issue
    select sid, serial# from v$session where upper(program) like '%IMP%';
    then issue select on v$session_wait where sid= the sid u found from the first quesry - the event name should be probably SQL Net Message from client
    Now get back to the IMP window and continue the import.
    When it hang, get back to the SQL window and repeat the query from v$Session_wait. Issue the query several times. See if the event there changes or stays the same.
    If it stays the same, post it here and also metalink for it

    Good Luck
    Boris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width