Imp-00058 Oracle Error 12560 Encountered
Contents |
Search Username Password Remember Me? Register Lost Password? facebook google twitter rss Free Web Developer Tools Advanced Search Forum Databases Oracle Development IMP: ORA-12560 TNS:protocol adapter error imp-00058 imp-00000 import terminated unsuccessfully Thread: IMP: ORA-12560 TNS:protocol adapter error Share This Thread Tweet This
Impdp From 10g To 11g
+ 1 this Post To Linkedin Subscribe to this Thread Subscribe to This Thread August 2nd, 2004,09:00 oracle 10g export 11g import AM #1 No Profile Picture Zveroa View Profile View Forum Posts Registered User Devshed Newbie (0 - 499 posts) Join Date Jan 2004 Posts 6 Rep Power imp-00058: oracle error 12154 encountered 0 IMP: ORA-12560 TNS:protocol adapter error Hi, I have installed a Oracle 8.1.7 database and trying to import an existing dump, but I'm getting the error message "ORA-12560 TNSrotocol adapter error" when running the IMP command (see below). The instance already exist, but I want to overwrite existing data. I can connect to the database from the database server itself and
Import 10g Dump To 11g
another client machine. Can I overwrite thethis, or do I have to create an empty database instance? I getting this "ORA-12560" when I'm trying to run other Oracle tools as well. Any clues what I'm missing? IMP-command -------------- C:\oracle\ora81\bin>set ORACLE_SID=prosty C:\oracle\ora81\bin>imp userid=system/manager full=y ignore=y file=T18820040729.dmp log=T18820040729 .log Import: Release 8.1.7.0.0 - Production on Mon Aug 2 15:49:58 2004 (c) Copyright 2000 Oracle Corporation. All rights reserved. IMP-00058: ORACLE error 12560 encountered ORA-12560: TNSrotocol adapter error IMP-00000: Import terminated unsuccessfully Faq Reply With Quote August 2nd, 2004,12:53 PM #2 No Profile Picture jim mcnamara View Profile View Forum Posts ......@......... Devshed Beginner (1000 - 1499 posts) Join Date Jun 2004 Posts 1,345 Rep Power 58 If the Oracle instance is on another physical box then you need to define TWO_TASK something like this: Code: export TWO_TASK=prosty OTherwise you have a network or SQLNet problem.... Faq Reply With Quote August 11th, 2004,04:29 AM #3 No Profile Picture Hans Brenkman View Profile View Forum Posts Registered User Devshed Newbie (0 - 499 posts)
23:16 oracle@learner Messages: 71Registered: October 2011 Member I am not able to exp/imp .dmp file. Thanks you in advance. Microsoft Windows [Version 6.1.7600] Copyright (c) 2009 ora-12560 tns protocol adapter error 11g Microsoft Corporation. All rights reserved. C:\Users\Administrator>d: D:\>imp Import: Release 10.2.0.1.0 - Production how to import dump file in oracle 11g on Mon Oct 24 08:45:48 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: tiger Password: IMP-00058:
Ora-12154
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 fromuser=tiger touser=abc Import: Release 10.2.0.1.0 - Production on Mon Oct 24 http://forums.devshed.com/oracle-development-96/imp-ora-12560-tns-protocol-adapter-error-170785.html 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 #528259 is a reply to message #528257] Sun, 23 October 2011 23:23 BlackSwan Messages: 24947Registered: January http://www.orafaq.com/forum/t/175836/ 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 #528260] Sun, 23 October 2011 23:41 BlackSwan Messages: 24947Registered: January 2009 Location: SoCal Senior Member so why do you keep changing & breaking thing? Report message to a moderator Re: EX
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus � Version: 9.2.0 Latest Followup You Asked i'm running oracle on standalone computer at home.it used to https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 work properly but from couple of days i'm getting error stating http://www.dbforums.com/showthread.php?1006925-import-data-to-oracle-server "ORA-12560: TNS:protocol adapter error " what should i do? please help.. (scott/tiger) and we said... sounds like the database is not up. you probably restarted your machine and the instance is not set to autostart C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu oracle error Sep 6 15:43:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options C:\Documents and Settings\tkyte>net stop oracleserviceora10gr1 The imp-00058 oracle error OracleServiceORA10GR1 service is stopping......... The OracleServiceORA10GR1 service was stopped successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus C:\Documents and Settings\tkyte>net start oracleserviceora10gr1 The OracleServiceORA10GR1 service is starting.......... The OracleServiceORA10GR1 service was started successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> in the above ora10gr1 is my oracle sid, you can use control panel instead - control panel -> services -> look for the services starting with Oracle. Reviews Write a Review Another method September 10, 2007 - 3:15 am UTC Reviewer: Arangaperumal G from
to check out the FAQ by clicking the link above. You may have to register before 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 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 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 Register