I used these two articles to create my DBLink.
1 of 1 people found this helpful
This could be done with a view. Below is the example. 'test' is the owner of the db_link and user 'dpa_m' is the DPA monitor user.
Login to your user that owns the db_link:
(example link) create database link test_dbl connect to remote_test identified by remote_test using
create a view:
create view test_vw as select * from dual@test_dbl;
Grant to monitor user:
grant select on test_vw to dpa_m;
Within DPA, create a 'Custom SQL Alert - Single Boolean Return'.
For the SQL Statement, enter the following:
select 'TRUE' from test.test_vw;
Execute it against the monitored DB.
For the Alerts & Notifications set to alert on 'BROKEN'.