My Oracle Support Banner

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

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
Symptoms
Changes
Cause
Solution
References

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