Forum Stats

  • 3,838,710 Users
  • 2,262,394 Discussions
  • 7,900,739 Comments

Discussions

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

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

Best Answer

Answers