Home » SQL & PL/SQL » Client Tools » TNS: Listener could not hand off client connection. error while connecting through toad 9.5 (oracle 10g r2)
TNS: Listener could not hand off client connection. error while connecting through toad 9.5 [message #517226] Mon, 25 July 2011 00:28 Go to next message
abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal
Member
the following is the log Toad generates while logging in

Fatal NI connect error 12518, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Dell-PC)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=pdb)(CID=(PROGRAM=C:\Prog ram Files\Quest Software\Toad for Oracle\toad.exe)(HOST=Dell-PC)(USER=admin))))

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: 25-JUL-2011 10:29:58
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0



please help
Re: TNS: Listener could not hand off client connection. error while connecting through toad 9.5 [message #517236 is a reply to message #517226] Mon, 25 July 2011 00:45 Go to previous messageGo to next message
BlackSwan
Messages: 22793
Registered: January 2009
Senior Member
post complete pathname for directory into which TOAD is installed.

Can TOAD connect OK to any Oracle DB?
Has this TOAD installation ever successfully worked OK?
Re: TNS: Listener could not hand off client connection. error while connecting through toad 9.5 [message #517249 is a reply to message #517236] Mon, 25 July 2011 01:35 Go to previous messageGo to next message
Littlefoot
Messages: 19630
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Which operating system do you use?
Re: TNS: Listener could not hand off client connection. error while connecting through toad 9.5 [message #517284 is a reply to message #517249] Mon, 25 July 2011 03:29 Go to previous message
abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal
Member
Toad Works with every other database but not this one PDB. I made a database link with access db. after that it stopped working...what should i do?
operating system is windows 7
Previous Topic: Third party tools
Next Topic: ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
Goto Forum:
  


Current Time: Sun Sep 21 13:36:28 CDT 2014

Total time taken to generate the page: 0.05458 seconds