其他常用的需要点检的信息
如告警日志、用户信息、dblink信息、job信息、分区表等，
可以配置计划任务定期输出到log，然后统一上传到ftp服务器进行人工点检。
1. 重要信息
-
该查询的执行时间不能超过服务器上的[Timeout]参数。从Zabbix 2.0.8开始，[Timeout]参数值也用作ODBC登录超时（请注意，根据ODBC驱动程序，登录超时设置可能会被忽略）。 -
该查询只能返回一个值。 -
如果查询返回多个列，则只读取第一列。 -
如果查询返回多行，则只读取第一行。 -
SQL命令必须以select开始。 -
SQL命令不能包含任何换行符。
<?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>Other Template Oracle DB</template>
<name>Other Template Oracle DB</name>
<description/>
<groups>
<group>
<name>Templates</name>
</group>
<group>
<name>Templates/Databases</name>
</group>
</groups>
<applications>
<application>
<name>Other Database</name>
</application>
<application>
<name>Other 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>Other 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>Other 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>Other 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 Alert log</name>
<type>11</type>
<snmp_community/>
<snmp_oid/>
<key>db.odbc.select[Instance Alert log,{$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>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</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>Other 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>
</items>
<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>{Other Template Oracle DB:db.odbc.select[Instance Status,{$DSN}].count(#1,OPEN,eq)}=0
or
{Other 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>{Other 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>
</triggers>
<value_maps>
<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-2981112/ ，如需转载，请注明出处，否则将追究法律责任。
