zabbix 监控 Oracle db 模板初版

来源：这里教程网时间：2026-03-03 18:57:55 作者：

简单测试监控几个指标。监控指标测试可用。 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>