TNS-12532 TNS-12560 TNS-00502 Errors Starting The 9i R2 TNS Listener

(Doc ID 380506.1)

Last updated on AUGUST 23, 2007

Applies to:

Oracle Net Services - Version:
This problem can occur on any platform.


Suddenly the Oracle9i R2 (  TNS Listener fails to start with the following errors:


Starting /u01/app/oracle/product/9.2.0/bin/tnslsnr: please wait...

TNSLSNR for HPUX: Version - Production
System parameter file is
Log messages written to /u01/app/oracle/product/9.2.0/network/log/listener.log
Error listening on: (ADDRESS=(PROTO =tcp)(PORT=1521))
TNS-12532: TNS:invalid argument
TNS-12560: TNS:protocol adapter error
TNS-00502: Invalid argument

Also the Listener trace shows problem reading the sqlnet.ora file:

[29-JUL-2006 13:43:44:664] ntvllt: Not successful in reading
[29-JUL-2006 13:43:44:664] ntvllt: exit
[29-JUL-2006 13:43:44:664] ntvlin: exit
[29-JUL-2006 13:43:44:664] nttcnp: Validnode Table **NOT** used; err 0x1f6
[29-JUL-2006 13:43:44:664] nttcnp: exit
[29-JUL-2006 13:43:44:664] nttcon: exit
[29-JUL-2006 13:43:44:664] nserror: entry
[29-JUL-2006 13:43:44:664] nserror: nsres: id=0, op=65, ns=12532, ns2=12560; nt[0]=502, nt[1]=0,
nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[29-JUL-2006 13:43:44:664 ] nsopen: unable to open transport


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