Name: Database link check
Platform: Oracle
Category: Availability
Description: Checks database links.
Long description: In order to check private database links you have to create a following view ‘create view dbw_link_check as select username from user_users@DB_LINK’ in the database link owner schema, and then grant select privilege to dbwatch user on that view (‘grant select on dbw_link_check to dbwatch’).
Version: 2.5
Default schedule: 15,45 * * *
Requires engine install: Yes
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & _priv_read_dba_db_links = ‘1’
Name Default value Description
ignore database links Database links names excluded from being checked (comma separated).
return status when database link is down 1 Return status value (ALARM – 2, WARNING – 1, or OK – 0) when database link is down.
check private db links NO

← Data Guard Archive Status Check (10g & 9i) / Instance alert log →


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment