Exp-00056 Oracle Error 12560
Contents |
TNS:protocol adapter error [message #170882] Fri, 05 May 2006 13:13 quantass Messages: 20Registered: April 2006 Junior Member My client PC is
Exp 00056 Oracle Error 12154 Encountered
using Windows 2000 Pro and Oracle 10g v10.2.0. Using the Enterprise exp 00056 oracle error 1017 encountered Manager Console GUI I've connected to the database successfully. Its connection information when selected reads:
Exp 00056 Oracle Error 1034 Encountered
--- (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=summer)(PORT=1521)))(CONNECT_DATA=(SID=cooler)(SERVICE_NAME=coolman.ca))) --- When creating the Net Config Assistant and the Local Net Service Name Config, I was successful at Testing the connection. The problem I'm having is to do with backing up the database. When i try "exp" from the DOS console window I get the error message: --- EXP-00056: ORACLE error 12560 encountered ORA-12560: TNS:protocol adapter error EXP-00000: Export terminated unsuccessfully --- I've tried doing: "tnsping" and got back the following response: --- C:\Documents and Settings\jrain>tnsping cool TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-MAY-2 006 13:39:45 Copyright (c) 1997, 2005, Oracle. All rights reserved. Used parameter files: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS=(PROTOCOL = TCP) (HOST = summer)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = coolman.ca) (SID = cooler))) OK (2390 msec) --- It seems to be fine. What also confuses me is "exp" asks for a username/pass. I have no idea what this is so I've tried my Windows user account login/pass, the login/pass for the "cooler" dbase, "scott/tiger", and "sys/manager". It always returns with the same error message. I am able to succussfuilly login into SQL Plus with the login/pass of the "cooler" dbase and the host: summer. Under the registry there is the entry: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE There is a subkey "KEY_OraClient10g_home1". Under the \Oracle key there is a data=value entry: VOBHOME2.0=C:\oracle\product\10.2.0\client_1 inst_loc=C:\Program Files\Oracle\Inventory Under the
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 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 http://www.orafaq.com/forum/t/62867/ and 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 http://www.nullskull.com/q/10346656/oracle-error-12560-encountered.aspx should show 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\CurrentControlS
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank https://community.oracle.com/thread/221161 message. Please type your message and try again. More discussions in General Database https://community.oracle.com/community/developer/search.jspa?q=EXP-00058 Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 7 Replies Latest reply on Dec 14, 2003 2:10 AM by orafad ORA 12560 What to do ?? 62896 Dec 8, 2003 9:46 PM I want to make a dump file for that reason I went on the command prompt and entered EXP username/password I get oracle error EXP 0056 : Oracle error 12560 encountered ORA-12560: TNS:Protocol adapter error EXP-0000 :Export terminated unsuccessfully Please advise what to do?? How do I get rid of this Thanks Nick.... 3377Views Tags: none (add) This content has been marked as final. Show 7 replies 1. Re: ORA 12560 What to do ?? JustinCave Dec 8, 2003 9:54 PM (in response to 62896) Can you connect to the database with SQL*Plus 00056 oracle error without specifying a TNS name? In other words, does sqlplus username/passwordwork, or do you need to specify @TNSName? Justin Distributed Database Consulting, Inc. www.ddbcinc.com/askDDBC Like Show 0 Likes(0) Actions 2. Re: ORA 12560 What to do ?? 62896 Dec 8, 2003 9:57 PM (in response to JustinCave) Justin, Yes I can logon to SqlPlus using username and password What do I do next?? I have to get this database working asap because all the development is stopped because of that. Thank you. Nicl... Like Show 0 Likes(0) Actions 3. Re: ORA 12560 What to do ?? 4174 Dec 8, 2003 10:20 PM (in response to 62896) Make sure to set your ORACLE_SID environment variable before doing the export. If you're on Windows: set ORACLE_SID=databasename or exp username/password@database If you're on UNIX: export ORACLE_SID=databasename Like Show 0 Likes(0) Actions 4. Re: ORA 12560 What to do ?? JustinCave Dec 8, 2003 10:27 PM (in response to 4174) If you can sqlplus to the machine without the @TNSName, doesn't that imply that the ORACLE_SID has been set correctly? Justin Distributed Database Consulting, Inc. www.ddbcinc.com/askDDBC Like Show 0 Likes(0) Actions 5. Re: ORA 12560 What to do ?? 62896 Dec 8, 2003 10:32 PM (in response to JustinC
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Softwa