-
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
-
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.
-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|