Is there a way to test a DB Link without logging as the owner of the DB Link ?

Peasant81

DB version: 19c 

OS : Oracle Linux/RHEL 8.x 

Is there a way to test a DB Links without loggin as the owner of the DB ?

In the below Pluggable DB, HRTB_MASTER schema has a database link named DBL_WBC.DOMAIN.NET

I logged in as SYS. Even as SYS, I cannot run a query using HRTB_MASTER.DBL_WBC.DOMAIN.NET

SQL> alter session set container = SALES_PROD;

Session altered.

SQL> show user
USER is "SYS"
SQL>
SQL>

SQL> alter session set current_schema = HRTB_MASTER;

Session altered.

SQL> select sysdate from [email protected]_WBC.DOMAIN.NET;
select sysdate from [email protected]_WBC.DOMAIN.NET
             *
ERROR at line 1:
ORA-02019: connection description for remote database not found

SQL> select sysdate from [email protected]_WBC.DOMAIN.NET;
select sysdate from [email protected]_WBC.DOMAIN.NET
                       *
ERROR at line 1:
ORA-02019: connection description for remote database not found

In 19c, DBA_DB_LINKS view has a VALID column (Not there in 12.1)

But, DBA_DB_LINKS.VALID column value is not reliable. Today, for a DB link which was actually broken, DBA_DB_LINKS.VALID wrongly displayed YES.

So, I am wondering if there is any other way to test if a DB Link is working without actually logging in as the owner of the DB Link. There are occasions where DBAs and application guys have lost passwords of application schemas. In such a scenario, I, as a DBA should be able to check if a DB Link is working or not

User_3ABCE

SYS> create view HRTB_MASTER.test_dblink as select * from [email protected]_WBC.DOMAIN.NET;
SYS> select * from HRTB_MASTER.test_dblink;
SYS> rem drop view HRTB_MASTER.test_dblink;

User_3ABCE

SYS> create view HRTB_MASTER.test_dblink as select * from [email protected]_WBC.DOMAIN.NET;
SYS> select * from HRTB_MASTER.test_dblink;
SYS> rem drop view HRTB_MASTER.test_dblink;