Thursday, July 1, 2010

Oracle 11GR2 SCAN, ORA-12502: TNS:listener received no CONNECT_DATA from client

While local_listener parameter of RAC database was something like this:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node-vip)(PORT=1521))))

connecting to database using SCAN listener gave following error (after a short period of hang time)

ORA-12502: TNS:listener received no CONNECT_DATA from client

After setting local_listener as:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node-vip.mycompany.com)(PORT=1521))))

problem resolved...

5 comments:

Anonymous said...

Useful post, we followed it and it got resolved

--
Narasimha Rao

Saleem Sheik said...

Hi Erkan,
I'm getting below error intermittently while accessing DB from Application.
Could you please advice me, how to move forward to resolve this issue?

error:-2147467259ORA-12502: TNS:listener received no CONNECT_DATA from client

Saleem Sheik said...
This comment has been removed by the author.
Erkan SAKA said...

Hi Saleem,
If this method did not help you then you should look further at support.oracle.com. Most probably problem occurs because of a sqlnet.ora/ tnsnames.ora/ local-remote listener configuration/ scan configuration parameter. Or maybe because of network connectivity problems. 

Srinivasa Reddy said...

It helped us to resolve my issue. thank you.