DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Wednesday, January 7, 2015

Tns connection Closed in Toad ORA-12537 TNS:connection closed

      Error : ORA-12537 TNS:connection closed

          Cause:

* In the Sqlnet.ora file the parameter TCP.VALIDNODE_CHECKING is enabled and TCP.INVITEDNODES is set to some specific IP's of the Client Machine.

Solution:

Comment the following line in sqlnet.ora and  try again or restart the listener 

          tcp.validnode_checking = yes

1 comment:

dhanaappsdba said...

Thanks Mr.JayaChandran from Kandachipuram.

Regards,
Dhana