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: 25046
Registered: January 2009
Location: SoCal
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: 20901
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: Fri Dec 09 04:20:22 CST 2016

Total time taken to generate the page: 0.16030 seconds