Database link check

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’

Parameters
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

Feedback