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
Last activity: Oct 28, 2019, 04:17 PM