简单测试监控几个指标。
监控指标测试可用。
1、日志监控
比较常见的2个触发器条件如下
8080字符串匹配成功：{192.168.1.239:log[/usr/local/tomcat/apache-tomcat-8.5.37/logs/catalina.out,8080,].str(8080)}=1
60秒内有数据：{192.168.1.239:log[/usr/local/tomcat/apache-tomcat-8.5.37/logs/catalina.out,8080,].nodata(60)}=0
WITH diag_alert_ext AS
(SELECT /*+ materialize */
originating_timestamp,
message_text
FROM v$diag_alert_ext
WHERE originating_timestamp > systimestamp - INTERVAL '1' DAY)
SELECT originating_timestamp,
message_text
FROM diag_alert_ext
WHERE message_text LIKE '%Error%'
OR message_text LIKE '%Fail%'
OR message_text LIKE '%WARNING%'
OR message_text LIKE '%Invalid%'
OR message_text LIKE '%ORA-%'
OR message_text LIKE '%Global Enqueue Services%'
OR message_text LIKE '%dead%'
OR message_text LIKE '%Starting ORACLE instance%'
ORDER BY originating_timestamp DESC;
2、常用的清单点检：dblink，用户信息，job信息、分区表信息等等。
3、性能指标
表空间部分修改为：
<params>select tablespace_name, case when contents in ('PERMANENT', 'UNDO') then (select round(sum(bytes)/1024/1024/1024,4) from dba_data_files where tablespace_name=t.tablespace_name) when contents='TEMPORARY' then (select round(sum(bytes)/1024/1024/1024,4) from dba_temp_files where tablespace_name=t.tablespace_name) end as "SIZE", case when contents in ('PERMANENT', 'UNDO') then (select round(sum(bytes)/1024/1024/1024,4) from dba_free_space where tablespace_name=t.tablespace_name) when contents='TEMPORARY' then (select round(sum(free_space)/1024/1024/1024,4) from dba_temp_free_space where tablespace_name=t.tablespace_name) end as "FREE_SIZE",case when contents in ('PERMANENT', 'UNDO') then (select round(sum( case when autoextensible = 'YES' then maxbytes else bytes end)/1024/1024/1024,4) from dba_data_files where tablespace_name=t.tablespace_name) when contents='TEMPORARY' then (select round(sum( case when autoextensible = 'YES' then maxbytes else bytes end)/1024/1024/1024,4) from dba_temp_files where tablespace_name=t.tablespace_name) end as "MAX_SIZE", case bigfile when 'YES' then 1 when 'NO' then 0 end "BIGFILE", case contents when 'PERMANENT' then 1 when 'TEMPORARY' then 2 when 'UNDO' then 3 end "CONTENTS" from dba_tablespaces t group by tablespace_name, bigfile, contents</params>
ASM磁盘组使用率预处理：<name>ASM disk: {#DISK_NAME}: pct free</name> 调整为1
<preprocessing>
<step>
<type>1</type>
<params>1</params>
<error_handler>0</error_handler>
<error_handler_params/>
</step>
</preprocessing>
---------------------------- ---------------------------- ---------------------------- ---------------------------- ----------------
<?xml version="1.0" encoding="UTF-8"?>
<zabbix_export>
<version>4.2</version>
<date>2019-08-15T21:16:40Z</date>
<groups>
<group>
<name>Templates</name>
</group>
<group>
<name>Templates/Databases</name>
</group>
</groups>
<templates>
<template>
<template>Winn Template Oracle DB</template>
<name>Winn Template Oracle DB</name>
<description/>
<groups>
<group>
<name>Templates</name>
</group>
<group>
<name>Templates/Databases</name>
</group>
</groups>
<applications>
<application>
<name>Winn Database</name>
</application>
<application>
<name>Winn Tests</name>
</application>
</applications>
<items>
<item>
<name>Instance name</name>
<type>11</type>
<snmp_community/>
<snmp_oid/>
<key>db.odbc.select[instance_name,{$DSN}]</key>
<delay>1d</delay>
<history>30d</history>
<trends>0</trends>
<status>0</status>
<value_type>4</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>select instance_name from v$instance;</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username>{$DB_USERNAME}</username>
<password>{$DB_PASSWORD}</password>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Database</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing>
<step>
<type>19</type>
<params/>
<error_handler>0</error_handler>
<error_handler_params/>
</step>
</preprocessing>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>1</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<master_item/>
</item>
<item>
<name>Instance status</name>
<type>11</type>
<snmp_community/>
<snmp_oid/>
<key>db.odbc.select[Instance Status,{$DSN}]</key>
<delay>60</delay>
<history>7d</history>
<trends>0</trends>
<status>0</status>
<value_type>4</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>select status from v$instance</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username>{$DB_USERNAME}</username>
<password>{$DB_PASSWORD}</password>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Database</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>1</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<master_item/>
</item>
<item>
<name>Instance startup time</name>
<type>11</type>
<snmp_community/>
<snmp_oid/>
<key>db.odbc.select[Instance startup time,{$DSN}]</key>
<delay>10m</delay>
<history>7d</history>
<trends>0</trends>
<status>0</status>
<value_type>4</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>select startup_time from v$instance</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username>{$DB_USERNAME}</username>
<password>{$DB_PASSWORD}</password>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Database</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>1</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<master_item/>
</item>
<item>
<name>Archived log Primary-Standby gap</name>
<type>11</type>
<snmp_community/>
<snmp_oid/>
<key>db.odbc.select[archive log gap,{$DSN}]</key>
<delay>10m</delay>
<history>7d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>select (select max(sequence#) from v$archived_log) - (select max(sequence#) from v$archived_log where applied = 'YES') from dual;</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username>{$DB_USERNAME}</username>
<password>{$DB_PASSWORD}</password>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Database</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>1</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<master_item/>
</item>
<item>
<name>Last 24h backup details</name>
<type>11</type>
<snmp_community/>
<snmp_oid/>
<key>db.odbc.select[backup status,{$BACKUP_DSN}]</key>
<delay>1h</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>select * from (select case when status = 'COMPLETED' then 1 when status = 'FAILED' then -1 when status like 'WITH WARNINGS' then 2 when status like 'WITH ERRORS' then 3 else 0 end from v$rman_status where trunc(start_time) = trunc(sysdate-{$ORACLE_BACKUP_HOUR}/24) and operation = 'BACKUP' and (object_type='DB INCR' or object_type='DB FULL') order by start_time asc) where rownum=1</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username>{$DB_USERNAME}</username>
<password>{$DB_PASSWORD}</password>
<publickey/>
<privatekey/>
<port/>
<description>when status = 'COMPLETED' then 1
when status = 'FAILED' then -1
when status like 'WITH WARNINGS' then 2
when status like 'WITH ERRORS' then 3
else 0</description>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Database</name>
</application>
</applications>
<valuemap>
<name>Oracle backup status</name>
</valuemap>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>1</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<master_item/>
</item>
</items>
<discovery_rules>
<discovery_rule>
<name>Tablespace discovery</name>
<type>11</type>
<snmp_community/>
<snmp_oid/>
<key>db.odbc.discovery[Tablespace Discovery,{$DSN}]</key>
<delay>1h</delay>
<status>0</status>
<allowed_hosts/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>select tablespace_name, case when contents in ('PERMANENT', 'UNDO') then (select round(sum(bytes)/1024/1024/1024,4) from dba_data_files where tablespace_name=t.tablespace_name) when contents='TEMPORARY' then (select round(sum(bytes)/1024/1024/1024,4) from dba_temp_files where tablespace_name=t.tablespace_name) end as "SIZE", case when contents in ('PERMANENT', 'UNDO') then (select round(sum(bytes)/1024/1024/1024,4) from dba_free_space where tablespace_name=t.tablespace_name) when contents='TEMPORARY' then (select round(sum(bytes)/1024/1024/1024,4) from dba_free_space where tablespace_name=t.tablespace_name) end as "FREE_SIZE",case when contents in ('PERMANENT', 'UNDO') then (select round(sum( case when autoextensible = 'YES' then maxbytes else bytes end)/1024/1024/1024,4) from dba_data_files where tablespace_name=t.tablespace_name) when contents='TEMPORARY' then (select round(sum( case when autoextensible = 'YES' then maxbytes else bytes end)/1024/1024/1024,4) from dba_temp_files where tablespace_name=t.tablespace_name) end as "MAX_SIZE", case bigfile when 'YES' then 1 when 'NO' then 0 end "BIGFILE", case contents when 'PERMANENT' then 1 when 'TEMPORARY' then 2 when 'UNDO' then 3 end "CONTENTS" from dba_tablespaces t group by tablespace_name, bigfile, contents</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username>{$DB_USERNAME}</username>
<password>{$DB_PASSWORD}</password>
<publickey/>
<privatekey/>
<port/>
<filter>
<evaltype>0</evaltype>
<formula/>
<conditions/>
</filter>
<lifetime>30d</lifetime>
<description/>
<item_prototypes>
<item_prototype>
<name>Tablespace: {#TABLESPACE_NAME}: bigfile</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.tablespace.bigfile[{#TABLESPACE_NAME}]</key>
<delay>1h</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#BIGFILE}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap>
<name>TruthValue</name>
</valuemap>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>Tablespaces</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>Tablespace: {#TABLESPACE_NAME}: contents</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.tablespace.contents[{#TABLESPACE_NAME}]</key>
<delay>4m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#CONTENTS}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap>
<name>Oracle tablespace contents</name>
</valuemap>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>Tablespaces</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>Tablespace: {#TABLESPACE_NAME}: free_size</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.tablespace.free_size[{#TABLESPACE_NAME}]</key>
<delay>4m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>GB</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#FREE_SIZE}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>Tablespaces</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>Tablespace: {#TABLESPACE_NAME}: max_free_size</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.tablespace.max_free_size[{#TABLESPACE_NAME}]</key>
<delay>4m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>GB</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#MAX_SIZE}-{#SIZE}+{#FREE_SIZE}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>Tablespaces</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>Tablespace: {#TABLESPACE_NAME}: max_size</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.tablespace.max_size[{#TABLESPACE_NAME}]</key>
<delay>4m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>GB</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#MAX_SIZE}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>Tablespaces</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>Tablespace: {#TABLESPACE_NAME}: pct_used</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}]</key>
<delay>4m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>%</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>({#SIZE}-{#FREE_SIZE})/{#MAX_SIZE}*100</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>Tablespaces</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>Tablespace: {#TABLESPACE_NAME}: size</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.tablespace.size[{#TABLESPACE_NAME}]</key>
<delay>4m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>GB</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#SIZE}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>Tablespaces</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>Tablespace: {#TABLESPACE_NAME}: used_size</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.tablespace.used_size[{#TABLESPACE_NAME}]</key>
<delay>4m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>GB</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#SIZE}-{#FREE_SIZE}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>Tablespaces</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
</item_prototypes>
<trigger_prototypes>
<trigger_prototype>
<expression>{Winn Template Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()} >= 80 * {$TB_USAGE_THRESHOLD} and {Winn Template Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1 and {Winn Template Oracle DB:db.oracle.tablespace.max_free_size[{#TABLESPACE_NAME}].last()}<250</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>Tablespace {#TABLESPACE_NAME} almost full => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>4</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies>
<dependency>
<name>Tablespace {#TABLESPACE_NAME} full => {ITEM.VALUE1}</name>
<expression>{Winn Template Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()}=100 and {Winn Template Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1</expression>
<recovery_expression/>
</dependency>
</dependencies>
<tags/>
</trigger_prototype>
<trigger_prototype>
<expression>{Winn Template Oracle DB:db.oracle.tablespace.pct_used[{#TABLESPACE_NAME}].last()}=100 and {Winn Template Oracle DB:db.oracle.tablespace.contents[{#TABLESPACE_NAME}].last()}=1</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>Tablespace {#TABLESPACE_NAME} full => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>5</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags/>
</trigger_prototype>
</trigger_prototypes>
<graph_prototypes/>
<host_prototypes/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<lld_macro_paths/>
<preprocessing/>
<master_item/>
</discovery_rule>
<discovery_rule>
<name>ASM disk discovery</name>
<type>11</type>
<snmp_community/>
<snmp_oid/>
<key>db.odbc.discovery[ASM Disk Discovery,{$DSN}]</key>
<delay>1m</delay>
<status>0</status>
<allowed_hosts/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>select name as disk_name, case mount_status when 'MISSING' then -3 when 'CLOSED' then -2 when 'CLOSING' then -1 when 'IGNORED' then 0 when 'OPENED' then 1 when 'CACHED' then 2 end as mount_status, case mode_status when 'OFFLINE' then 0 when 'ONLINE' then 1 end as mode_status, case state when 'NORMAL' then 1 when 'UNKNOWN' then 0 when 'ADDING' then 2 when 'DROPPING' then 3 when 'HUNG' then -1 when 'FORCING' then -2 end as state, os_mb, total_mb, free_mb,COLD_USED_MB from v$asm_disk_stat</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username>{$DB_USERNAME}</username>
<password>{$DB_PASSWORD}</password>
<publickey/>
<privatekey/>
<port/>
<filter>
<evaltype>0</evaltype>
<formula/>
<conditions/>
</filter>
<lifetime>7d</lifetime>
<description/>
<item_prototypes>
<item_prototype>
<name>ASM disk: {#DISK_NAME}: mode status</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>oracle.asm.disk.mode_status[{#DISK_NAME}]</key>
<delay>5m</delay>
<history>90d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#MODE_STATUS}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>when 'OFFLINE' then 0
when 'ONLINE' then 1</description>
<inventory_link>0</inventory_link>
<applications/>
<valuemap>
<name>Oracle ASM disk mount status</name>
</valuemap>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>ASM</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>ASM disk: {#DISK_NAME}: mount status</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>oracle.asm.disk.mount_status[{#DISK_NAME}]</key>
<delay>5m</delay>
<history>90d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#MOUNT_STATUS}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>when 'MISSING' then -3
when 'CLOSED' then -2
when 'CLOSING' then -1
when 'IGNORED' then 0
when 'OPENED' then 1
when 'CACHED' then 2</description>
<inventory_link>0</inventory_link>
<applications/>
<valuemap>
<name>Oracle ASM disk mount status</name>
</valuemap>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>ASM</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>ASM disk: {#DISK_NAME}: state</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>oracle.asm.disk.state[{#DISK_NAME}]</key>
<delay>1m</delay>
<history>90d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#STATE}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description>when 'NORMAL' then 1
when 'UNKNOWN' then 0
when 'ADDING' then 2
when 'DROPPING' then 3
when 'HUNG' then -1
when 'FORCING' then -2</description>
<inventory_link>0</inventory_link>
<applications/>
<valuemap>
<name>Oracle ASM disk state</name>
</valuemap>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>ASM</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>ASM disk: {#DISK_NAME}: total space</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>oracle.asm.disk.total_space[{#DISK_NAME}]</key>
<delay>5m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>B</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#TOTAL_MB}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications/>
<valuemap/>
<logtimefmt/>
<preprocessing>
<step>
<type>1</type>
<params>1048576</params>
<error_handler>0</error_handler>
<error_handler_params/>
</step>
</preprocessing>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>1</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>ASM</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>ASM disk: {#DISK_NAME}: free space</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>oracle.db.disk.free_space[{#DISK_NAME}]</key>
<delay>5m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>B</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#FREE_MB}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications/>
<valuemap/>
<logtimefmt/>
<preprocessing>
<step>
<type>1</type>
<params>1048576</params>
<error_handler>0</error_handler>
<error_handler_params/>
</step>
</preprocessing>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>ASM</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>ASM disk: {#DISK_NAME}: cold used space</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>oracle.db.disk.cold_free_space[{#DISK_NAME}]</key>
<delay>5m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>B</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#COLD_USED_MB}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications/>
<valuemap/>
<logtimefmt/>
<preprocessing>
<step>
<type>1</type>
<params>1048576</params>
<error_handler>0</error_handler>
<error_handler_params/>
</step>
</preprocessing>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>ASM</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>ASM disk: {#DISK_NAME}: pct free</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>oracle.db.disk.pct_free[{#DISK_NAME}]</key>
<delay>5m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>%</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#FREE_MB} / {#TOTAL_MB} * 100</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications/>
<valuemap/>
<logtimefmt/>
<preprocessing>
<step>
<type>1</type>
<params>1048576</params>
<error_handler>0</error_handler>
<error_handler_params/>
</step>
</preprocessing>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>ASM</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
</item_prototypes>
<trigger_prototypes>
<trigger_prototype>
<expression>{Winn Template Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * {$ASM_USAGE_THRESHOLD} <=5</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>ASM disk {#DISK_NAME} extremely low free space => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>4</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies>
<dependency>
<name>ASM disk {#DISK_NAME} zero free space</name>
<expression>{Winn Template Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} <=0.01</expression>
<recovery_expression/>
</dependency>
</dependencies>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Field</tag>
<value>Storage</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger_prototype>
<trigger_prototype>
<expression>{Winn Template Oracle DB:oracle.asm.disk.state[{#DISK_NAME}].last()}<>1</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>ASM disk {#DISK_NAME} is => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>5</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger_prototype>
<trigger_prototype>
<expression>{Winn Template Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * {$ASM_USAGE_THRESHOLD} <=15</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>ASM disk {#DISK_NAME} low free space => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>2</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies>
<dependency>
<name>ASM disk {#DISK_NAME} very low free space => {ITEM.VALUE1}</name>
<expression>{Winn Template Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * {$ASM_USAGE_THRESHOLD} <=10</expression>
<recovery_expression/>
</dependency>
</dependencies>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Field</tag>
<value>Storage</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger_prototype>
<trigger_prototype>
<expression>{Winn Template Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * {$ASM_USAGE_THRESHOLD} <=10</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>ASM disk {#DISK_NAME} very low free space => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>3</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies>
<dependency>
<name>ASM disk {#DISK_NAME} extremely low free space => {ITEM.VALUE1}</name>
<expression>{Winn Template Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} * {$ASM_USAGE_THRESHOLD} <=5</expression>
<recovery_expression/>
</dependency>
</dependencies>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Field</tag>
<value>Storage</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger_prototype>
<trigger_prototype>
<expression>{Winn Template Oracle DB:oracle.db.disk.pct_free[{#DISK_NAME}].last()} <=0.01</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>ASM disk {#DISK_NAME} zero free space</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>5</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Field</tag>
<value>Storage</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger_prototype>
</trigger_prototypes>
<graph_prototypes/>
<host_prototypes/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>1</request_method>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<lld_macro_paths/>
<preprocessing/>
<master_item/>
</discovery_rule>
<discovery_rule>
<name>Flash Recovery Area Discovery</name>
<type>11</type>
<snmp_community/>
<snmp_oid/>
<key>db.odbc.discovery[Flash Recovery Area Discovery,{$DSN}]</key>
<delay>5m</delay>
<status>0</status>
<allowed_hosts/>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>select name, space_limit, space_used from v$recovery_file_dest</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username>{$DB_USERNAME}</username>
<password>{$DB_PASSWORD}</password>
<publickey/>
<privatekey/>
<port/>
<filter>
<evaltype>0</evaltype>
<formula/>
<conditions/>
</filter>
<lifetime>30d</lifetime>
<description/>
<item_prototypes>
<item_prototype>
<name>FRA: {#NAME}: pct_used</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.fra.pct_used[{#NAME}]</key>
<delay>4m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>0</value_type>
<allowed_hosts/>
<units>%</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#SPACE_USED}/{#SPACE_LIMIT}*100</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>FRA</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>FRA: {#NAME}: size</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.fra.size[{#NAME}]</key>
<delay>4m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>B</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#SPACE_LIMIT}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>FRA</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
<item_prototype>
<name>FRA: {#NAME}: space_used</name>
<type>15</type>
<snmp_community/>
<snmp_oid/>
<key>db.oracle.fra.space_used[{#NAME}]</key>
<delay>4m</delay>
<history>1d</history>
<trends>365d</trends>
<status>0</status>
<value_type>3</value_type>
<allowed_hosts/>
<units>B</units>
<snmpv3_contextname/>
<snmpv3_securityname/>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authprotocol>0</snmpv3_authprotocol>
<snmpv3_authpassphrase/>
<snmpv3_privprotocol>0</snmpv3_privprotocol>
<snmpv3_privpassphrase/>
<params>{#SPACE_USED}</params>
<ipmi_sensor/>
<authtype>0</authtype>
<username/>
<password/>
<publickey/>
<privatekey/>
<port/>
<description/>
<inventory_link>0</inventory_link>
<applications>
<application>
<name>Winn Tests</name>
</application>
</applications>
<valuemap/>
<logtimefmt/>
<preprocessing/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<output_format>0</output_format>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<application_prototypes>
<application_prototype>
<name>FRA</name>
</application_prototype>
</application_prototypes>
<master_item/>
</item_prototype>
</item_prototypes>
<trigger_prototypes>
<trigger_prototype>
<expression>{Winn Template Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * {$FRA_USAGE_THRESHOLD} >= 95</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>FRA is almost full => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>4</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies>
<dependency>
<name>FRA is full => {ITEM.VALUE1}</name>
<expression>{Winn Template Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()}=100</expression>
<recovery_expression/>
</dependency>
</dependencies>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastracture</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger_prototype>
<trigger_prototype>
<expression>{Winn Template Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()}=100</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>FRA is full => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>5</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger_prototype>
<trigger_prototype>
<expression>{Winn Template Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * {$FRA_USAGE_THRESHOLD} >=85</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>FRA space usage is high => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>2</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies>
<dependency>
<name>FRA space usage is very high => {ITEM.VALUE1}</name>
<expression>{Winn Template Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * {$FRA_USAGE_THRESHOLD} >=90</expression>
<recovery_expression/>
</dependency>
</dependencies>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger_prototype>
<trigger_prototype>
<expression>{Winn Template Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * {$FRA_USAGE_THRESHOLD} >=90</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>FRA space usage is very high => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>3</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies>
<dependency>
<name>FRA is almost full => {ITEM.VALUE1}</name>
<expression>{Winn Template Oracle DB:db.oracle.fra.pct_used[{#NAME}].last()} * {$FRA_USAGE_THRESHOLD} >= 95</expression>
<recovery_expression/>
</dependency>
</dependencies>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger_prototype>
</trigger_prototypes>
<graph_prototypes/>
<host_prototypes/>
<jmx_endpoint/>
<timeout>3s</timeout>
<url/>
<query_fields/>
<posts/>
<status_codes>200</status_codes>
<follow_redirects>1</follow_redirects>
<post_type>0</post_type>
<http_proxy/>
<headers/>
<retrieve_mode>0</retrieve_mode>
<request_method>0</request_method>
<allow_traps>0</allow_traps>
<ssl_cert_file/>
<ssl_key_file/>
<ssl_key_password/>
<verify_peer>0</verify_peer>
<verify_host>0</verify_host>
<lld_macro_paths/>
<preprocessing/>
<master_item/>
</discovery_rule>
</discovery_rules>
<httptests/>
<macros>
<macro>
<macro>{$ASM_USAGE_THRESHOLD}</macro>
<value>1.0</value>
</macro>
<macro>
<macro>{$BACKUP_DSN}</macro>
<value>{$DSN}</value>
</macro>
<macro>
<macro>{$BLOCK_THRESHOLD}</macro>
<value>20</value>
</macro>
<macro>
<macro>{$DB_PASSWORD}</macro>
<value>zabbix</value>
</macro>
<macro>
<macro>{$DB_USERNAME}</macro>
<value>zabbix</value>
</macro>
<macro>
<macro>{$DSN}</macro>
<value/>
</macro>
<macro>
<macro>{$FRA_USAGE_THRESHOLD}</macro>
<value>1.0</value>
</macro>
<macro>
<macro>{$MIN_READ_BPS}</macro>
<value>10485760</value>
</macro>
<macro>
<macro>{$MIN_WRITE_BPS}</macro>
<value>1048576</value>
</macro>
<macro>
<macro>{$ORACLE_BACKUP_HOUR}</macro>
<value>0</value>
</macro>
<macro>
<macro>{$TB_USAGE_THRESHOLD}</macro>
<value>1.0</value>
</macro>
</macros>
<templates/>
<screens/>
<tags>
<tag>
<tag>{$BACKUP_DSN}</tag>
<value>{$DSN}</value>
</tag>
</tags>
</template>
</templates>
<triggers>
<trigger>
<expression>{Winn Template Oracle DB:db.odbc.select[Instance Status,{$DSN}].count(#1,OPEN,eq)}=0
or
{Winn Template Oracle DB:db.odbc.select[Instance Status,{$DSN}].nodata(150)}=1</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>Database Is Down</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>5</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger>
<trigger>
<expression>{Winn Template Oracle DB:db.odbc.select[Instance startup time,{$DSN}].change()}=1</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>Instance startup time Is change</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>5</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger>
<trigger>
<expression>{Winn Template Oracle DB:db.odbc.select[archive log gap,{$DSN}].last()}>=5</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>DB - DG archive gap detected => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>2</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies>
<dependency>
<name>DB - DG massive archive gap detected => {ITEM.VALUE1}</name>
<expression>{Winn Template Oracle DB:db.odbc.select[archive log gap,{$DSN}].last()}>=10</expression>
<recovery_expression/>
</dependency>
</dependencies>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger>
<trigger>
<expression>{Winn Template Oracle DB:db.odbc.select[archive log gap,{$DSN}].last()}>=10</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>DB - DG massive archive gap detected => {ITEM.VALUE1}</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>4</priority>
<description/>
<type>0</type>
<manual_close>0</manual_close>
<dependencies/>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger>
<trigger>
<expression>{Winn Template Oracle DB:db.odbc.select[backup status,{$BACKUP_DSN}].last()}=-1
or
{Winn Template Oracle DB:db.odbc.select[backup status,{$BACKUP_DSN}].nodata(24h)}=1</expression>
<recovery_mode>1</recovery_mode>
<recovery_expression>{Winn Template Oracle DB:db.odbc.select[backup status,{$BACKUP_DSN}].last()}>=0</recovery_expression>
<name>Database has no backup last 24hrs</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>3</priority>
<description/>
<type>0</type>
<manual_close>1</manual_close>
<dependencies/>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger>
<trigger>
<expression>{Winn Template Oracle DB:db.odbc.select[backup status,{$BACKUP_DSN}].last()}=3</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>Last DB backup contains errors</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>4</priority>
<description/>
<type>0</type>
<manual_close>1</manual_close>
<dependencies/>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger>
<trigger>
<expression>{Winn Template Oracle DB:db.odbc.select[backup status,{$BACKUP_DSN}].last()}=2</expression>
<recovery_mode>0</recovery_mode>
<recovery_expression/>
<name>Last DB backup contains warnings</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>2</priority>
<description/>
<type>0</type>
<manual_close>1</manual_close>
<dependencies/>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger>
<trigger>
<expression>{Winn Template Oracle DB:db.odbc.select[backup status,{$BACKUP_DSN}].last()}=-1</expression>
<recovery_mode>1</recovery_mode>
<recovery_expression>{Winn Template Oracle DB:db.odbc.select[backup status,{$BACKUP_DSN}].last()}>=0</recovery_expression>
<name>Last DB backup is failed</name>
<correlation_mode>0</correlation_mode>
<correlation_tag/>
<url/>
<status>0</status>
<priority>4</priority>
<description/>
<type>0</type>
<manual_close>1</manual_close>
<dependencies/>
<tags>
<tag>
<tag>Application</tag>
<value>Oracle</value>
</tag>
<tag>
<tag>Field</tag>
<value>Database</value>
</tag>
<tag>
<tag>Scope</tag>
<value>Infrastructure</value>
</tag>
<tag>
<tag>Type</tag>
<value>Technical</value>
</tag>
</tags>
</trigger>
</triggers>
<value_maps>
<value_map>
<name>Oracle ASM disk mount status</name>
<mappings>
<mapping>
<value>-1</value>
<newvalue>CLOSING</newvalue>
</mapping>
<mapping>
<value>-2</value>
<newvalue>CLOSED</newvalue>
</mapping>
<mapping>
<value>-3</value>
<newvalue>MISSING</newvalue>
</mapping>
<mapping>
<value>0</value>
<newvalue>IGNORED</newvalue>
</mapping>
<mapping>
<value>1</value>
<newvalue>OPENED</newvalue>
</mapping>
<mapping>
<value>2</value>
<newvalue>CACHED</newvalue>
</mapping>
</mappings>
</value_map>
<value_map>
<name>Oracle ASM disk state</name>
<mappings>
<mapping>
<value>-1</value>
<newvalue>HUNG</newvalue>
</mapping>
<mapping>
<value>-2</value>
<newvalue>FORCING</newvalue>
</mapping>
<mapping>
<value>0</value>
<newvalue>UNKNOWN</newvalue>
</mapping>
<mapping>
<value>1</value>
<newvalue>NORMAL</newvalue>
</mapping>
<mapping>
<value>2</value>
<newvalue>ADDING</newvalue>
</mapping>
<mapping>
<value>3</value>
<newvalue>DROPPING</newvalue>
</mapping>
</mappings>
</value_map>
<value_map>
<name>Oracle backup status</name>
<mappings>
<mapping>
<value>-1</value>
<newvalue>FAILED</newvalue>
</mapping>
<mapping>
<value>0</value>
<newvalue>UNKNOWN</newvalue>
</mapping>
<mapping>
<value>1</value>
<newvalue>COMPLETED</newvalue>
</mapping>
<mapping>
<value>2</value>
<newvalue>WITH WARNINGS</newvalue>
</mapping>
<mapping>
<value>4</value>
<newvalue>WITH ERRORS</newvalue>
</mapping>
</mappings>
</value_map>
<value_map>
<name>Oracle tablespace contents</name>
<mappings>
<mapping>
<value>PERMANENT</value>
<newvalue>1</newvalue>
</mapping>
<mapping>
<value>TEMPORARY</value>
<newvalue>2</newvalue>
</mapping>
<mapping>
<value>UNDO</value>
<newvalue>3</newvalue>
</mapping>
</mappings>
</value_map>
<value_map>
<name>TruthValue</name>
<mappings>
<mapping>
<value>1</value>
<newvalue>true</newvalue>
</mapping>
<mapping>
<value>2</value>
<newvalue>false</newvalue>
</mapping>
</mappings>
</value_map>
</value_maps>
</zabbix_export>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/70031606/viewspace-2980460/ ，如需转载，请注明出处，否则将追究法律责任。
