My Oracle Support Banner

TNS-12545 Reported for Connections to Database from the Database Server (Doc ID 1213803.1)

Last updated on OCTOBER 22, 2020

Applies to:

Oracle Net Services - Version 10.1.0.5 to 19.5.0.0.0 [Release 10.1 to 19]
Linux x86
Linux x86-64

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data from the Oracle sample or bulit-in schema(s), Public Documentation delivered with an Oracle database product or other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

 

Connections to the database, via the TNS listener from the server, where the database is running, fail, reporting error code TNS-12545: Connect failed because target host or object does not

sqlplus scott/<PASSWORD>@<TNSALIAS>

SQL*Plus: Release 10.2.0.5.0 Production on Wed Sep 20 21:28:14 2010

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-12545: Connect failed because target host or object does not exist

Remote clients and bequeath connections work fine.
Server can resolve the host name or ipaddress using TCP/IP ping or nslookup command.
The servers SQL*Net.log shows :

Fatal NI connect error 12545, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME>)(PORT=<PORTNUM>))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=<SERVICENAAME>)(CID=(PROGRAM=sqlplus)(HOST=<HOSTNAME>)(USER=<USER>))))

VERSION INFORMATION:
TNS for Linux: Version 10.2.0.5.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.5.0 - Production
Time: 20-SEP-2010 21:28:14
Tracing not turned on.
Tns error struct:
ns main err code: 12545
TNS-12545: Connect failed because target host or object does not exist
ns secondary err code: 12560
nt main err code: 515
TNS-00515: Connect failed because target host or object does not exist
nt secondary err code: 99
nt OS err code: 0


Level 16 Oracle Net Client trace shows the issue is when socket is attempted to be used.

[21-SEP-2010 21:28:14:885] nttcnp: creating a socket.
[21-SEP-2010 21:28:14:885] nttcnp: exit
[21-SEP-2010 21:28:14:885] nttcni: entry
[21-SEP-2010 21:28:14:885] nttcni: trying to connect to socket 9.
[21-SEP-2010 21:28:14:885] ntt2err: entry
[21-SEP-2010 21:28:14:885] ntt2err: soc 9 error - operation=1, ntresnt[0]=515, ntresnt[1]=99, ntresnt[2]=0
[21-SEP-2010 21:28:14:885] ntt2err: exit
[21-SEP-2010 21:28:14:885] nttcni: exit
[21-SEP-2010 21:28:14:885] nttcon: exit
[21-SEP-2010 21:28:14:885] nserror: entry
[21-SEP-2010 21:28:14:885] nserror: nsres: id=0, op=65, ns=12545, ns2=12560; nt[0]=515, nt[1]=99, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[21-SEP-2010 21:28:14:885] nsopen: unable to open transport


Lowest error code in the stack is nt[1]=99. For this Linux machine that is the error :

define EADDRNOTAVAIL 99 /* Cannot assign requested address */






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
Cause
Solution


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