TNS Protocol Adapter Error (Oracle 9i)

From: <saurabhgarg2k_at_gmail.com>
Date: 29 Jun 2005 01:27:28 -0700
Message-ID: <1120033648.009640.284930@g43g2000cwa.googlegroups.com>

Hi there,

We are facing a very strange problem, we have an Oracle 9i Server running , the problem came into picture when we tried to connect to the database through ASP.NET application using ODP.NET, it throws an error "ORA-12560 TNS Protocol Adapter Error", then we tried a console Application again using ODP.NET, still same error, finally we tried connecting the database using TOAD and still same error, so it is confirmed that its not ODP.NET.

All the database services are running and another client machine is able to connect to the server fine without any problems, and yes from the client machine we r facing problems from tnsping is working fine but nothing else.

Following is the log message we got while TOAD fails to connect

Fatal NI connect error 12560, connecting to:

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.37)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=INTSYS1)(CID=(PROGRAM=C:\gav_toadfree\Toad.exe)(HOST=INTWEB1)(USER=administrator))))

VERSION INFORMATION:

	TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
	Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version

9.2.0.1.0 - Production
  Time: 28-JUN-2005 19:06:31
  Tracing not turned on.
  Tns error struct:
    nr err code: 0
    ns main err code: 12560
    TNS-12560: TNS:protocol adapter error     ns secondary err code: 0
    nt main err code: 538
    TNS-00538: Message 538 not found; product=NETWORK; facility=TNS

nt secondary err code: 65
nt OS err code: 0

Any one has any ideas about that,its kind of urgent.

Thanks in advance

Thanks and Regards
Saurabh Garg Received on Wed Jun 29 2005 - 03:27:28 CDT

TNS Protocol Adapter Error (Oracle 9i) - Urgent