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:
Useful post, we followed it and it got resolved
--
Narasimha Rao
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
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.
It helped us to resolve my issue. thank you.
Post a Comment