Exp 0056 Oracle Error 12560 Encountered

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 exp-00056 oracle error 12560 encountered start viewing messages, select the forum that you want to visit from the selection exp 00056 oracle error 12154 encountered below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 12 Thread: Export Error-ORA-12560 Tweet Thread Tools

Exp 00056 Oracle Error 1017 Encountered

Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-11-2004,11:49 AM #1 bonny View Profile View Forum Posts Junior Member Join Date Aug

Exp 00056 Oracle Error 1034 Encountered

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 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 like- C:\>exp userid=bonny/testb@testb file=c:\temp\ sttb.dmp log=c:\temp\sttb.log buffer=1000000 compress=N consistent=Y rows=Y tables= 'bonny.stats_tb' Export: Release 9.2.0.1.0 - Production on Thu Aug 12 08:24:07 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.0.1.4.0 - Production JServer Release 9.0.1.4.0 - Production EXP-00056: ORACLE error 942 encountered ORA-00942: table or view does not exis

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 http://www.dbasupport.com/forums/showthread.php?44166-Export-Error-ORA-12560 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: http://www.orafaq.com/forum/t/62867/ 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.or

error 12560 encountered ORA-12560: TNS:protocol adapter error EXP-00000: Export terminated unsuccessfully Riley K replied to Nishikant on 16-Aug-11 http://www.nullskull.com/q/10346656/oracle-error-12560-encountered.aspx 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 0056 oracle at the error stack and check for lower level transport errors. For further details, turn on tracing 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 0056 oracle error 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 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-