Home » RDBMS Server » Networking and Gateways » Listener starts and then stops itself all the time (10.2.0.3)
Listener starts and then stops itself all the time [message #286432] Fri, 07 December 2007 06:15 Go to next message
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
Member
Getting the following errors in the listener.log when trying to connect with sqlplus from the client or on the server using the listener.
---

TNS-12502: TNS:listener received no CONNECT_DATA from client
07-AUG-2007 09:10:25 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
07-AUG-2007 09:20:25 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client

---

The connects in sqlplus just hangs.

Any help will be appreciated
Re: Listener starts and then stops itself all the time [message #286436 is a reply to message #286432] Fri, 07 December 2007 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-12502: TNS:listener received no CONNECT_DATA from client
 *Cause:  No CONNECT_DATA was passed to the listener.
 *Action: Check that the service name resolved from TNSNAMES.ORA has
 the CONNECT_DATA component of the connect descriptor.

Regards
Michel
Re: Listener starts and then stops itself all the time [message #286464 is a reply to message #286432] Fri, 07 December 2007 09:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
what is Oracle's version to 4 decimal places?
I am surprised Michel did NOT ask for this.
Re: Listener starts and then stops itself all the time [message #286469 is a reply to message #286464] Fri, 07 December 2007 09:39 Go to previous messageGo to next message
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
Member
The version is 10.2.0.3
Re: Listener starts and then stops itself all the time [message #286470 is a reply to message #286432] Fri, 07 December 2007 09:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
12502, 00000, "TNS:listener received no CONNECT_DATA from client"
// *Cause: No CONNECT_DATA was passed to the listener.
// *Action: Check that the service name resolved from TNSNAMES.ORA has
// the CONNECT_DATA component of the connect descriptor.
Re: Listener starts and then stops itself all the time [message #286471 is a reply to message #286470] Fri, 07 December 2007 09:51 Go to previous messageGo to next message
mwansalovewell
Messages: 71
Registered: October 2007
Location: uk
Member
I have checked that and its in place. I have seen this solution mention as the action but this is not the case, everything in tnsname is ok

The connections with sqlplus is hanging when you use @<tnsname> to connect.
Re: Listener starts and then stops itself all the time [message #286481 is a reply to message #286432] Fri, 07 December 2007 10:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Does the listener.log file show anything of interest?
What Operating System name & version.
Post contents of sqlnet.ora
Re: Listener starts and then stops itself all the time [message #286483 is a reply to message #286481] Fri, 07 December 2007 10:15 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Any entry in alert log?
Re: Listener starts and then stops itself all the time [message #286499 is a reply to message #286432] Fri, 07 December 2007 11:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
can any other client connect to the target database?
Can this client connect to any other database?
Re: Listener starts and then stops itself all the time [message #286536 is a reply to message #286481] Fri, 07 December 2007 22:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Check Metalink NOTE: 453505.1

https://metalink.oracle.com/metalink/plsql/f?p=130:14:7778368169989602992::::p14_database_id,p14_docid,p14_show_header,p14_show_help, p14_black_frame,p14_font:NOT,453505.1,1,1,1,helvetica
Re: Listener starts and then stops itself all the time [message #286607 is a reply to message #286432] Sat, 08 December 2007 22:23 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Ana, he specified his version in the right column while he posting, So it appeared in his subject line.
Previous Topic: Client Server Communication in Oracle 9i
Next Topic: Ldap replication error
Goto Forum:
  


Current Time: Fri Dec 06 15:20:44 CST 2024