Listener Start Fails with TNS-01191 , TNS-12545 or TNS-12532 |ORA-12157 May Be Thrown On Connect Attempts (Doc ID 872763.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Net Services - Version 8.1.7.0 to 11.2.0.3 [Release 8.1.7 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 23-AUG-2013***

Symptoms

Listener start fails with the following errors:

On  Solaris:

LSNRCTL> start LISTDPRNRJ 
    Starting /oracle10g/product/10.2.0/bin/tnslsnr: please wait... 
     
    TNSLSNR for Solaris: Version 10.2.0.2.0 - Production 
    System parameter file is /oracle10g/product/10.2.0/network/admin/listener.ora 
    Log messages written to /oracle10g/product/10.2.0/network/log/listdprnrj.log 
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.9.102.10)(PORT=1523))) 
    Error listening on: (ADDRESS=(PROTOCOL=tcp)(IP=LOOPBACK)) 
    TNS-01191: Failed to initialize the local OS authentication subsystem 
     TNS-12545: Connect failed because target host or object does not exist 
      TNS-12560: TNS:protocol adapter error 
       TNS-00515: Connect failed because target host or object does not exist 
        Solaris Error: 126: Cannot assign requested address


 

On Linux :
----------

[oracle@testnet shashi]$ lsnrctl start listener_105 

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 12-AUG-2009 05:44:37 

Copyright (c) 1991, 2007, Oracle.  All rights reserved. 

Starting /home/oracle/oracle/product/10.2.0.4/db_1/bin/tnslsnr: please wait... 

TNSLSNR for Linux: Version 10.2.0.4.0 - Production 
System parameter file is /home/oracle/users/shashi/listener.ora 
Log messages written to /home/oracle/oracle/product/10.2.0.4/db_1/network/log/listener_105.log 
Trace information written to /tmp/list_105g.trc 
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=testnet.idc.oracle.com)(PORT=1523))) 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=testnet)(PORT=1523))) 
TNS-12532: TNS:invalid argument 
 TNS-12560: TNS:protocol adapter error 
  TNS-00502: Invalid argument 
   Linux Error: 22: Invalid argument 

 The listener trace shows the following :

[12-AUG-2009 05:44:38:309] nttbnd2addr: using host IP address: 127.0.0.1
[12-AUG-2009 05:44:38:309] snlinFreeAddrInfo: entry
[12-AUG-2009 05:44:38:309] snlinFreeAddrInfo: exit
[12-AUG-2009 05:44:38:309] nttbnd2addr: exit
[12-AUG-2009 05:44:38:309] nttcon: entry
[12-AUG-2009 05:44:38:309] nttcon: toc = 2
[12-AUG-2009 05:44:38:309] nttcnp: entry
[12-AUG-2009 05:44:38:309] nttcnp: creating a socket.
[12-AUG-2009 05:44:38:309] nttcnp: binding an address to a socket.
[12-AUG-2009 05:44:38:309] ntt2err: entry
[12-AUG-2009 05:44:38:309] ntt2err: soc 12 error - operation=1, ntresnt[0]=515, ntresnt[1]=99, ntresnt[2]=0
PS: The ntresnt[1]=126 on Solaris.  On linux ntresnt[1]=99

Though the netstat output shows the listener is listening ,

[oracle@testnet ~]$ netstat -an | grep 1523
tcp        0      0 0.0.0.0:1523                0.0.0.0:*                   LISTEN

Local connections and remote connections to the database fail with ORA-12157 as shown below:

Local connection:
----------------

Local connection: 
----------------
[oracle@testnet ~]$ sqlplus /nolog 

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 12 06:25:11 2009 

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved. 

SQL> conn sys as sysdba 
Enter password: 
ERROR: 
ORA-12157: TNS:internal network communication error

Remote Connection:
-------------------

[oracle@testnet shashi]$ sqlplus scott/tiger@testnet 

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Aug 12 06:30:56 2009 

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved. 

ERROR: 
ORA-12157: TNS:internal network communication error

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