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:

Symptoms

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

   (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521)))
    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

Changes

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.

Cause

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