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
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
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 :
(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: 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 :
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 |