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 AUGUST 24, 2017

Applies to:

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


Listener start fails with the following errors:

On  Solaris:

    Starting /oracle10g/product/10.2.0/bin/tnslsnr: please wait... 
    TNSLSNR for Solaris: Version - 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=XX.X.XXX.XX)(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 - Production on 12-AUG-2009 05:44:37 

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

Starting /home/oracle/oracle/product/ please wait... 

TNSLSNR for Linux: Version - Production 
System parameter file is /home/oracle/users/shashi/listener.ora 
Log messages written to /home/oracle/oracle/product/ 
Trace information written to /tmp/list_105g.trc 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhostname)(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:
[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      *                   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 - Production on Wed Aug 12 06:25:11 2009 

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

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

Remote Connection:

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

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

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

ORA-12157: TNS:internal network communication error


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