How can I troubleshoot TNS connection issues? Do I need TRCROUTE executable?
0
votes
3
answers
1464
views
I am trying to connect to a particular TNS name; in my
tnsnames.ora
file I can see that it is defined as being a TCP connection to foo-scan
on port 39000. I can tnsping
this name OK.
I can successfully telnet foo-scan 39000
but when I try to connect in e.g. sqldeveloper I get the error ora-12545: connect failed because target host or object does not exist
According to google it is likely that the listener on foo-scan
is actually trying to forward my client to bar-vip
, which no doubt I cannot connect to. Also according to google there is a utility called trcroute
that will debug this issue and show me exactly where my client is trying to connect and what step is actually failing. But I cannot find this utility anywhere.
Asked by Coxy
(111 rep)
Apr 22, 2020, 06:33 AM
Last activity: Apr 24, 2020, 03:27 AM
Last activity: Apr 24, 2020, 03:27 AM