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

Last updated on MARCH 05, 2017

Applies to:

Oracle Net Services - Version 9.2.0.4.0 to 12.1.0.2 [Release 9.2 to 12.1]
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.

Symptoms

You have  TCP.VALIDNODE_CHECKING enabled in the sqlnet.ora file and the listener is failing to start with the  following error stack:

Error listening on:


   (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

This issue can also yield the following error stack:                                                                                     
          Error listening on: (ADDRESS=(PROTOCOL=TCP)(Host=<hostname>)(Port=1562))
          TNS-12560: TNS:protocol adapter error 
          TNS-00584: Valid node checking configuration error

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 if this is a new installation.  If some hostname changes have occurred on your network, this problem may also appear.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms