Imp 0058 Oracle Error 12560 Encountered
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About
Imp-00058 Imp-00000 Import Terminated Unsuccessfully
Us Learn more about Stack Overflow the company Business Learn more about hiring impdp from 10g to 11g developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange
Oracle 10g Export 11g Import
is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's import 10g dump to 11g how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Oracle 10g dump file into Oracle 11g database up vote 2 down vote favorite I went through this link for my answer to the same question. I was not sure if i could continue in the same link, so created a new question. Oracle 10g imp-00058: oracle error 12154 encountered dump file push into Oracle 11g database Sorry if I am wrong. When I used imp with the following parameters: file=my.dmp log=my.log fromuser=myuser touser=myuser statistics=none, ignore=y, full=y I got the following errors: IMP-00058: ORACLE error 12560 encountered ORA-12560: TNS:protocol adapter error IMP-00000: Import terminated unsuccessfully Also this error message was there the procedure entry point longjmp could not be located in the dynamic link library ORAUTS.DLL The database and devsuite home are installed on Windows in two different drives. I found some references saying I should run the datapump import commands from the 11g home, with this: set ORACLE_HOME=C:\app\Administrator\product\11.1.0\db_1 set ORACLE_SID=ORCL11R1 I am new to this Oracle database. Should this command be run in command prompt, since the installation is done on Windows, is it "set ORACLE_HOME"? Any suggestion on this would be welcomed. oracle import export datapump share|improve this question edited Aug 12 '14 at 13:03 Colin 't Hart 5,02082131 asked Feb 9 '13 at 11:14 lakshminarayan 1112 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote That error is most likely due to incorrect environment settings indeed, probably your PATH is mixed up too. In a command prompt, assuming that you
23:16 oracle@learner Messages: 71Registered: October 2011 Member I am not able to exp/imp .dmp file. Thanks you in advance. Microsoft Windows
How To Import Dump File In Oracle 11g
[Version 6.1.7600] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Administrator>d: impdp version D:\>imp Import: Release 10.2.0.1.0 - Production on Mon Oct 24 08:45:48 2011 Copyright (c) 1982, 2005,
Import Dump File In Oracle 11g Command
Oracle. All rights reserved. Username: tiger Password: IMP-00058: ORACLE error 12560 encountered ORA-12560: TNS:protocol adapter error IMP-00000: Import terminated unsuccessfully D:\>imp tiger/tiger@orclimpl full=y ignore=y file=tiger.d mp log=tiger.log http://dba.stackexchange.com/questions/34468/oracle-10g-dump-file-into-oracle-11g-database fromuser=tiger touser=abc Import: Release 10.2.0.1.0 - Production on Mon Oct 24 09:25:30 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. IMP-00058: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve the connect identifier specified IMP-00000: Import terminated unsuccessfully D:\> Please help me. Report message to a moderator Re: EXP/IMP Fail [message http://www.orafaq.com/forum/t/175836/ #528259 is a reply to message #528257] Sun, 23 October 2011 23:23 BlackSwan Messages: 24947Registered: January 2009 Location: SoCal Senior Member >IMP-00058: ORACLE error 12560 encountered >ORA-12560: TNS:protocol adapter error >IMP-00000: Import terminated unsuccessfully throwing these errors when attempting to connect to local DB indicates OS/Networking/environment is mis-configured. root cause of problem & fix are external to Oracle when did this last work without error? What changed? Report message to a moderator Re: EXP/IMP Fail [message #528260 is a reply to message #528259] Sun, 23 October 2011 23:39 oracle@learner Messages: 71Registered: October 2011 Member Last time , I have changed the workgroup to domain again then Domain to workgroup again. After tha I was not not able to connect database, but with the help from ORAFAQ,Problem was solved. Now this is the new problem for exp and imp. Report message to a moderator Re: EXP/IMP Fail [message #528261 is a reply to message
to check out the FAQ by clicking the link above. You may have to register before http://www.dbforums.com/showthread.php?1006925-import-data-to-oracle-server you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: import data to oracle server Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search oracle error Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-08-04,23:01 #1 srinivasraos36 View Profile View Forum Posts Registered User Join Date Aug 2004 Posts 1 Unanswered: import data to oracle server Hi , I am trying to import to oracle 9i database on windows 2000 advanced server setup at home.i am getting import dump file following error when i try to run below command in command prompt imp findba/findba file= D:\treasury\aeat1u_dump_29Jul.dmp log=D:\treasury\findba.log fromuser=ops$utcaebg1 touser=findba full=Y buffer=10000 grants=N ignore=Y IMP-00058: ORACLE error 12560 encountered ORA-12560: TNSrotocol adapter error IMP-00000: Import terminated unsuccessfully Reply With Quote 08-09-04,01:21 #2 osy45 View Profile View Forum Posts Registered User Join Date Nov 2002 Posts 833 imp findba/findba@SID file= D:\treasury\aeat1u_dump_29Jul.dmp log=D:\treasury\findba.log fromuser=ops$utcaebg1 touser=findba full=Y buffer=10000 grants=N ignore=Y and I would go for a larger buffer size 4000000 Reply With Quote 08-09-04,09:51 #3 The_Duck View Profile View Forum Posts Registered User Join Date Jul 2003 Posts 2,296 this is a sql-net error. Either the database is not up and running or you do not have the listener.ora and tnsnames.ora files configured properly - The_Duck you can lead someone to something but they will never learn anything ... Reply With Quote 08-09-04,10:02 #4 mobotek View Profile View Forum Posts Visit Homepage Registered User Join Date Aug 2004 Posts 9 Are you connecting t