Listener Fails to Start Using TCP.VALIDNODE_CHECKING: TNS-12532 TNS:Invalid Argument

(Doc ID 287500.1)

Last updated on OCTOBER 18, 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 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

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