Server Hung Doing Full Import
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Server Hung Doing Full Import

  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Smile Server Hung Doing Full Import

    Hi All

    I'm doing import from Oracle 9i 32 bit to Oracle 10g 64 bits itanium. I starts import then server it seem hung mouse and keyboard are blocked it just only respond by ping.

    I just only can do force suhtdown and restart server, any idea? It is supportted? Does anybody know?.

    Thanks In Advance.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by jbasilio
    It is supportted?
    Check the Compatibility Matrix for Export and Import on Metalink
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Is it creating indexes? That often looks like a hang from the user point of view.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Jun 2007
    Location
    Utah
    Posts
    4

    Thumbs up may be too late but

    If you get pong from server this means that the kernel did not hang.
    First thing I should do it to check the disk activity using the leds on the system. if the server is installed on a remote site then using ssh or rdp you can check the activity since depending on the server hardare config and imported data, you can get slow response from the server.

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