Exp-00056 Oracle Error 12560 Encountered
Contents |
Error-ORA-12560 If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can ora 12560 tns protocol adapter error post: click the register link above to proceed. To start viewing messages, exp 00056 oracle error 6550 encountered select the forum that you want to visit from the selection below. Page 1 of 2 12 Last exp 00056 oracle error 12154 encountered Jump to page: Results 1 to 10 of 12 Thread: Export Error-ORA-12560 Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid oracle export command Mode Switch to Threaded Mode 08-11-2004,11:49 AM #1 bonny View Profile View Forum Posts Junior Member Join Date Aug 2002 Posts 40 Export Error-ORA-12560 I have remote server and access through oracle client and dbartisan.I do have resource and connect privileges.When I am exporting tables from my schema this problem is encountered(ora-12560: TNSrotocol adapter error).I did look into TNSnames.ora file on my
Exp 00056 Oracle Error 1017 Encountered
computer , which already contains the name of the database I am trying to export from. Could not understand why ?? I would appreciate if someone could answer to this.where further I should look into. Thanks Reply With Quote 08-11-2004,01:31 PM #2 sambavan View Profile View Forum Posts Senior Advisor Join Date Oct 2000 Location Saskatoon, SK, Canada Posts 3,925 Hi, On your export string that you used to execute the export, how did you define the connectivity to the database i.e exp user_name/password or exp username/password@remote_db If it was the fist, then you either have to define the TWO_TASK=remotedb.domain in your environment or you have to resolute that of using the second option. Before you proceed, try doing a tnsping, and ensure that you can reach that database. tnsping remote_db.domain Hope this would help you. Thanx. Sam Thanx Sam Life is a journey, not a destination! Reply With Quote 08-12-2004,08:52 AM #3 bonny View Profile View Forum Posts Junior Member Join Date Aug 2002 Posts 40 Thanks Sam, I did tnsping dbname- it shows the connection which is correct. I am exporting
error 12560 encountered ORA-12560: TNS:protocol adapter error EXP-00000: Export terminated unsuccessfully Riley K replied to Nishikant on 16-Aug-11 01:44 AM Is there a listener running? Have you
Exp 00056 Oracle Error 1034 Encountered
run thenetcaprogram to configure and start the listener? The Oracle docs note that you should troubleshoot the ORA-12560 by tracing the connection: ORA-12560: TNS: protocol adapter error Cause: A generic protocol adapter error occurred. Solution: Check addresses used for proper protocol specification. Before reporting this error, look at the error stack and check for lower level transport errors. For further details, turn on tracing and http://www.dbasupport.com/forums/showthread.php?44166-Export-Error-ORA-12560 re-execute the operation. Turn off tracing when the operation is complete. check these links http://www.dba-oracle.com/t_ora_12560_tns_protocol_adapter_error.htm http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::p11_question_id:431775600346873836 Nishikant replied to Riley K on 16-Aug-11 01:51 AM The listener does not starts even if i try to start it manually.. What should i do? Riley K replied to Nishikant on 16-Aug-11 02:08 AM First, ensure that your listener service is running. C:\Documents and Settings\ME>lsnrctl stat This should show http://www.nullskull.com/q/10346656/oracle-error-12560-encountered.aspx the status of the listener and the services it is listening for. Remember that when you run SQL*Plus on the database server, it does not need the listener to connect unless you specify the database tnsnames.ora entry. Try to start the listener service usinglsnrctlfrom DOS prompt. set ORACLE_HOME=cd %ORACLE_HOME%/bin lsnrctl start LISTENER If the listener service is not running, re-start the listener service using the Windows task manager or use the DOS command line utility to re-start the Windows service with the "net start" command: C:\Documents and Settings\ME>net start OracleOraDb10g_home1TNSListener You can use thelsnrctl statuscommand to verify that the listener is down, andlsnrctl startto start your listener. If you are on Windows, also verify that the listener service is running. Here are more notes onlsnrctl: http://www.dba-oracle.com/t_ora_12541_tns_no_listener.htm Nishikant replied to Riley K on 16-Aug-11 02:27 AM Now i am getting this error.. ORA-12560: TNS:protocol adapter error Riley K replied to Nishikant on 16-Aug-11 03:56 AM There might be some problem with referencing the .Ora cile Uninstall Oracle and Install again 1. Uninstall ORACLE Clientremoving folder C:\Oracle 2. Remove all Oracle entries found in the registry under Hkey_Local_Machine. 3. Enter registry and navigate to HKeyLM\system\CurrentControlSet\Services\Winsock. Delete the Wi
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time https://www.experts-exchange.com/questions/21847163/Getting-an-error-while-using-exp-utility.html Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Getting an error http://forums.devshed.com/oracle-development-96/imp-ora-12560-tns-protocol-adapter-error-170785.html while using exp utility Want to Advertise Here? Solved Getting an error while using exp utility Posted on 2006-05-11 Oracle Database 1 Verified Solution 9 Comments 1,285 Views Last Modified: 2008-02-01 Hi I am oracle error trying to use export utility, but getting this error---> EXP-00056: ORACLE error 12560 encountered ORA- 12560- TNS:protocol adapter error EXP-00000:EXPORT terminated unsuccessfully Can somebody help me to resolve this. Thanks in advance 0 Question by:Smruti1 Facebook Twitter LinkedIn Google LVL 34 Active today Best Solution bymarkgeer Running exp from a client is usually *NOT a good idea! That will usually be *MUCH* slower than running it directly 00056 oracle error on the server because of the network traffic involved. Also, this will only work if Go to Solution 8 Comments LVL 142 Overall: Level 142 Oracle Database 38 Message Active 1 day ago Expert Comment by:Guy Hengel [angelIII / a3]2006-05-11 can you connect with sql plus using the same connection parameters? what settings? 0 Message Author Comment by:Smruti12006-05-11 Hi Thanks for quick response. Yes, I can connect with sql plus using the same connection parameters. 0 LVL 34 Overall: Level 34 Oracle Database 34 Message Active today Expert Comment by:markgeer2006-05-11 Please give us some more information: 1. Are you running exp on the server, or from a client? (Running it on the server will generally work best.) 2. Which version of Oracle is the database? 3. What is your server's operating system? 4. Does the server have just one Oracle_home (installation of Oracle software) or multiple? 0 LVL 10 Overall: Level 10 Oracle Database 9 Message Expert Comment by:ravindran_eee2006-05-12 Can u post the exact command you are using to export??? Some parameter has been provided wrongly.. That could be the reason.. The actual command would be a lot helpful.. 0 Message Author Comment by:Smruti12006-05
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 Thread: IMP: ORA-12560 TNS:protocol adapter error Share This Thread Tweet This + 1 this Post To Linkedin Subscribe to this Thread Subscribe to This Thread August 2nd, 2004,09:00 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 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 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)