My Oracle Support Banner

Listener Fails to Start Using TCP.VALIDNODE_CHECKING: TNS-12532 TNS:Invalid Argument (Doc ID 287500.1)

Last updated on MARCH 31, 2022

Applies to:

Oracle Net Services - Version to [Release 9.2 to 12.1]
Oracle Database - Enterprise Edition - Version to [Release 19]
Information in this document applies to any platform.
This problem can occur on any platform.
This issue can occur in 9.2.0.x with Security patch #68 applied, or any later version of Oracle.


You have  TCP.VALIDNODE_CHECKING enabled in the sqlnet.ora file and the listener is failing to start with one of these error stacks:

    TNS-12532: TNS:invalid argument
    TNS-12560: TNS:protocol adapter error
    TNS-502: Invalid argument
    32-bit Windows Error: 515: Unknown error

    Error listening on: (ADDRESS=(PROTOCOL=TCP)(Host=<hostname>)(Port=1562))
    TNS-12560: TNS:protocol adapter error 
    TNS-00584: Valid node checking configuration error

   Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=hostname)(Port=1521))
   TNS-12537: TNS:connection closed
   TNS-12560: TNS:protocol adapter error
   TNS-00507: Connection closed


An inspection of the level 16 listener trace files reveals :

[15-OCT-2004 08:55:38:609] ntvllt: Problem in Loading tcp.invited_nodes
[15-OCT-2004 08:55:38:609] ntvllt: exit
[15-OCT-2004 08:55:38:609] ntvlin: exit
[15-OCT-2004 08:55:38:609] nttcnp: Validnode Table **NOT** used; err-0x1f6
[15-OCT-2004 08:55:38:609] nttcnp: exit
[15-OCT-2004 08:55:38:609] nttcon: exit
[15-OCT-2004 08:55:38:609] nserror: entry
[15-OCT-2004 08:55:38:609] nserror: nsres: id=0, op=65, ns=12532, ns2=12560;
nt[0]=502, nt[1]=515, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[15-OCT-2004 08:55:38:609] nsopen: unable to open transport


Applied the patch for security alert # 68 or  this is a new installation.  If some hostname changes have occurred on your network, this problem may also appear.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.