i have a dblink that i want to test to make its functional during working hours. Can someone give me step-by-step to do this?
Thanks.
i have a dblink that i want to test to make its functional during working hours. Can someone give me step-by-step to do this?
Thanks.
I used these two articles to create my DBLink.
http://www.itprotoday.com/microsoft-sql-server/connecting-sql-server-and-oracle-using-linked-servers
How to get up and running with Oracle and Linked Servers – CSS SQL Server Engineers
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:
conn test
(example link) create database link test_dbl connect to remote_test identified by remote_test using
'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=123.123.123.123)(PORT=1521))(CONNECT_DATA=(service_name=testdb)))';
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'.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.