Oracle Error 12560 Export
TNS:protocol adapter error [message #170882] Fri, 05 May 2006 13:13 quantass Messages: 20Registered: April 2006 Junior Member My client PC is using Windows 2000 Pro and Oracle 10g v10.2.0. Using the Enterprise Manager Console GUI I've connected to the database successfully. Its connection information when selected reads: --- (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 \KEY_OraClient10g_home1 key there are several entries including: ORACLE_HOME=C:\oracle\product\10.2.0\client_1 WRT to tnsnames.ora, sqlnet.ora, and listener.ora, they are all located under folder: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN TNSNAMES.ora contains the following info: --- COOLER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = summer)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME =
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 post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Page 1 of 2 12 Last 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 http://www.orafaq.com/forum/t/62867/ 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 http://www.dbasupport.com/forums/showthread.php?44166-Export-Error-ORA-12560 my 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
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the http://stackoverflow.com/questions/35223645/ora-12560-tns-error-protocol-adapter workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions http://dbaforums.org/oracle/index.php?showtopic=2966 Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. oracle error Join them; it only takes a minute: Sign up ORA-12560: TNS: Error protocol Adapter up vote 1 down vote favorite I would like to export database schema with expdp/impdp. For that reason I am trying to do the same steps like in this tutorial. when I enter sqlplus / as sysdba in the command line, I will be ased oracle error 12560 to enter user name and pasword. When I do this and click Enter, the following errors is comming: ORA-12560: TNS: Error protocol Adapter I am using windows 7 and have installed oracle 12c. All oracle services are started. I login from cmd.exe as adminstrator oracle oracle12c share|improve this question asked Feb 5 at 11:56 Ronald 568413 open de cmd and do this lsnrctl status and tell me what's the result –download dowload Feb 5 at 12:05 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted I think i khnow the problem you said that you did the same steps in the tuto. In the tutoriel he did this step C:>set oracle_sid=db my question did you have the same name of the Oracle SID ? if you did a default installation by the default the Oracle SID is orcl in your case do this C:>set oracle_sid=ORCLto verify the Oracle SID go to this path C:\oracle\app\oracle\product\11.2.0\server\network\ADMIN and open the listener.ora and check the host name LISTENER = (DESCRI