Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

Peasant81Jun 30 2022

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

This post has been answered by User_3ABCE on Jul 1 2022
Jump to Answer

Comments

Post Details

Added on Jun 30 2022
1 comment
3,320 views