Fatal Ni Connect Error 12560 Connecting Local
Contents |
be sure to check out the FAQ by clicking the link above. You may have fatal ni connect error 12560 connecting to description address protocol beq to register before you can post: click the register link tns-00530 above to proceed. To start viewing messages, select the forum that you want to visit tns error struct from the selection below. Results 1 to 9 of 9 Thread: TNS-12560: TNS:protocol adapter error Tweet Thread Tools Show Printable Version Subscribe to this
Fatal Ni Connect Error 12537
Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 02-11-04,16:43 #1 ramdatts View Profile View Forum Posts Registered User Join Date Aug 2003 Location Saint Lucia Posts 14 Unanswered: TNS-12560: TNS:protocol adapter error Hi All, I am trying to use oracle from tns-12560: tns:protocol adapter error a windows 2000 pc and I get the belows error. SQL Plus works fine but I still get this error. ************************************************** ********************* Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.1 71.25)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=main )(CID=(PROGRAM=c:\bcg\bin\AdminVC6ORA816_31137.exe )(HOST=SLUL125)(USER=kenty.ramdatt)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 11-FEB-2004 16:54:56 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNSrotocol adapter error ns secondary err code: 0 nt main err code: 530 TNS-00530: Protocol adapter error nt secondary err code: 38 nt OS err code: 0 Can anyone help? Cheers Reply With Quote 02-11-04,17:06 #2 gbrabham View Profile View Forum Posts Registered User Join Date Apr 2003 Location Greenville, SC (USA) Posts 1,155 ensure that you can tnsping the instance from command line. check your SQLNET.ORA file and ensure that SQLNET.AUTHENTICATIO
Joined: 7-September 09 fatal ni connect error 12170. Member No.: 41,733 Hello,I created a VB.NET application that connects to
Ora-12560
a Oracle database using DbProviderFactory and ODP.NET for .Net Framework 2.0. This application runs on XP, I need it to run as Windows Service, but every time it try to connect to the database throw the Oracle exception TNS-12560: TNS:protocol adapter error, the http://www.dbforums.com/showthread.php?982838-TNS-12560-TNS-protocol-adapter-error weird thing is the same application running as a Console Application it works (Same code, same connection string, same query). It was using ODP.NET 10 I updated the provider to 11 still got the same error. The service is running user Local System account, and it has the same problem running under other adm account.Following http://dbaforums.org/oracle/index.php?showtopic=18650 is error in the sqlnet.log (PS: The file was under the system32 folder, probably because was running as a service):QUOTE Fatal NI connect error 12560, connecting to:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XXX)(CID=(PROGRAM=C:\Program Files\MyApp\MyApp.exe)(HOST=MYCOMPUTER)(USER=MYUSER))))VERSION INFORMATION:+ TNS for 32-bit Windows: Version 10.2.0.1.0 - Production++ Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - Production+Time: 28-AUG-2009 02:20:19Tracing not turned on.Tns error struct:ns main err code: 12560TNS-12560: TNS:protocol adapter errorns secondary err code: 0nt main err code: 530TNS-00530: Protocol adapter errornt secondary err code: 56nt OS err code: 0Does anyone have any thoughts as to why I'm getting this error ??Thanks burleson View Member Profile Sep 7 2009, 07:06 AM Post #2 Advanced Member Group: Members Posts: 13,227 Joined: 26-January 04 Member No.: 13 Hi,>> Fatal NI connect error 12560See here:http://www.dba-oracle.com/bk_fatal_ni_conn..._12560_tips.htm********************************************************************>> Does anyone have any thoughts as to why I'm getting this error ??See here:http://www.dba-oracle.com/t_ora_12560_tns_...apter_error.htmQUOTE ORA-12560: TNS: protocol adapter error Cause: A generic protocol adapter error occurred. Action: Check addresses used for proper protocol specification. Befor
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you http://dba.stackexchange.com/questions/74803/oraclesid-local-no might have Meta Discuss the workings and policies of this http://www.orafaq.com/forum/t/42943/ site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals fatal ni who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top oracle
on troubleshooting connection problem [message #113254] Thu, 31 March 2005 19:11 psteve Messages: 9Registered: March 2005 Location: New England Junior Member HI, any help is greatly appreciated. I have a development environment with 9i forms and reports on one machine and a 9.1 database on another. (both Windows) I installed 10g alongside the 9i on the database machine for evaluation several months ago. Recently, I wanted to create a new 9i db, but the 10g was interfering, and the 9i configuration assistant died without ever opening a window. So I decided to just go with 10g. I had no trouble making several 10G databases. But I cannot get forms to connect to any of them. 9i is on 1521 only and 10G is on 1526 only. Windows services shows that both listeners are running. I configured TNSNAMES.ora on the development machine and tnsping sees all the 9i and 10g databases just fine. I even get 0 msec and 10 msec response times. Tnsping prints the names of the files it is using for configuration, and they are the right ones ( the ones in the 9iDS hierarchy---the development machine has an old 8.1.7 db on it, but I don't think that is an issue.) All the 9i and 10g databases are up and accessible from SQL plus running on the database machine. But on the client machine, neither forms, reports, SQL Plus, nor a development tool I use can connect to the 10g databases. They can all connect to the 9i databases. Attempts to connect to the 10G databases always timeout. Since tnsping is working, I am stumped. What should I be trying to troubleshoot this problem? Report message to a moderator Re: need ideas on troubleshooting connection problem [message #113329 is a reply to message #113254] Fri, 01 April 2005 08:22 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator Tnsping check the availability of listener. Thats it. check the sqlnet.ora in the concerned machine and comment out all the entries. try again Report message to a moderator Re: need ideas on troubleshooting connection problem [message #113346 is a reply to message #113329] Fri, 01 April 2005 09:37 psteve Messages: 9Registered: March 2