Sample Header Ad - 728x90

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