error while importing ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: error while importing ?

  1. #1
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339

    error while importing ?

    i am importing remotely to the database.
    The size of the dump is 9GB.After a long time.. the import is terminated with the below error.....please suggest.

    IMP-00058: ORACLE error 12571 encountered
    ORA-12571: TNSacket writer failure
    IMP-00058: ORACLE error 3114 encountered
    ORA-03114: not connected to ORACLE
    IMP-00000: Import terminated unsuccessfully
    Thanks/Gopu

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    What are errors ORA-12571 and ORA-03114 suggesting to you?
    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 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    Quote Originally Posted by PAVB
    What are errors ORA-12571 and ORA-03114 suggesting to you?

    but the database is up and running fine ??
    Thanks/Gopu

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by gopu_g
    but the database is up and running fine ??
    Lets do the math...

    + Remote import
    + 9 Gig dump file
    + Long time running
    + ORA-12571
    + ORA-03114
    = My educated guess is you lost connectivity.

    Try again.
    If it fails again FTP dump file to local host and try Import locally.
    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.

  5. #5
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    339
    that fine...
    Now i am moving the dump to the local server.
    Because it failed for two times.
    Thanks/Gopu

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