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 dual@DBL_WBC.DOMAIN.NET;
select sysdate from dual@DBL_WBC.DOMAIN.NET
*
ERROR at line 1:
ORA-02019: connection description for remote database not found
SQL> select sysdate from HRTB_MASTER.dual@DBL_WBC.DOMAIN.NET;
select sysdate from HRTB_MASTER.dual@DBL_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