Sample Header Ad - 728x90

How to get TNS connect strings (like tnsping) to check a dblink via a session?

0 votes
1 answer
1816 views
I would like to know, if there is any chance to get the currently used TNS connect string, that will be used for a DB-Link from a db-server. I'm connected to a schema on a database located on any server. Now, I have some database links, using tnsnames and which are currently not working properly. I would like to check, which target database is behind this identifier to verify easily, if this can be correct. If I would have OS access to the db-server, I would be able to read the ./tnsnames.ora or using tnsping. But the DDL of the dblink just uses the TNSNAME (RDBX in this example): > CREATE DATABASE LINK "ABC" CONNECT TO "RUSER" IDENTIFIED BY VALUES ':1' USING 'RDBX'; Of course, I could ask a DBA, but this is not always as easy in our environment and I would like to be able to double-check it myself without having OS-access.
Asked by D. Lohrsträter (180 rep)
Oct 28, 2019, 02:02 PM
Last activity: Oct 28, 2019, 04:17 PM