Downloaded 87 times
![• Oracle Database and Network Monitoring in the Cloud with Zabbix5 § The design principle: KISS § Heartbeat § Mature § [Re]active development § Active community • IRC is very active irc://verne.freenode.net/zabbix • Zabbix forum https://www.zabbix.com/forum/ § Large installed base § Very stable § Good Oracle database citizen (can still be improved) § easy to extend with plugins Why Zabbix?](https://image.slidesharecdn.com/oraclemonitoringwithzabbix-160323074752/75/Monitoring-Oracle-Database-Instances-with-Zabbix-5-2048.jpg)
![• Oracle Database and Network Monitoring in the Cloud with Zabbix13 §the biggest pitfall is creating items on hosts §almost certainly there will be more hosts with same item[s] §create templates §use MACROS for tunables §use value lists to explain the meaning of values §use prefixes to visually relate MACROS to templates templates](https://image.slidesharecdn.com/oraclemonitoringwithzabbix-160323074752/75/Monitoring-Oracle-Database-Instances-with-Zabbix-13-2048.jpg)
![• Oracle Database and Network Monitoring in the Cloud with Zabbix15 host p_ts.lld 1458212406 {“data":[ {"{#TS_NAME}": "SYSTEM", "{#PDB}": null} , {"{#TS_NAME}": "CTXD", "{#PDB}": null} , {"{#TS_NAME}": "OWAPUB", "{#PDB}": null} , {"{#TS_NAME}": "ODM", "{#PDB}": null} <snip> ]} example lld data Permanent TableSpaces host has to be known in zabbix and have the template attached p_ts.lld has to be a key in the discovery rules for the host 1458212406 unix timestamp when the discovery was done (date “+%s”) data is the discovered array There will be item prototypes where {#TS_NAME} and {#PDB} are placeholders for the names in Item Prototypes When using zabbix_sender, make sure the complete array is on 1 line.](https://image.slidesharecdn.com/oraclemonitoringwithzabbix-160323074752/75/Monitoring-Oracle-Database-Instances-with-Zabbix-15-2048.jpg)
![• Oracle Database and Network Monitoring in the Cloud with Zabbix20 host p_ts[,USERS,maxsize] 1458212417 524288000 host p_ts[,SYSTEM,maxsize] 1458212417 18027118592 host p_ts[,APPS_TS_INTERFACE,maxsize] 1458212417 18874368000 host p_ts[,ODM,maxsize] 1458212417 104857600 Think about quoting! Space is column delimiter, if space can be in key, quote the key Missing value? -> null Example data for zabbix_sender](https://image.slidesharecdn.com/oraclemonitoringwithzabbix-160323074752/75/Monitoring-Oracle-Database-Instances-with-Zabbix-20-2048.jpg)
Uploaded byGerger
Monitoring Oracle Database Instances with Zabbix
The document discusses monitoring Oracle databases and networks using Zabbix, covering installation, configuration, and data collection methods. It highlights Zabbix's advantages such as a stable community, ease of extension with plugins, and low-level discovery features. Additionally, it details integration with Oracle through a plugin called zbxora, which facilitates data collection and monitoring for Oracle databases.
Monitoring Oracle Database Instances with Zabbix
- 1. pro huddle •Ronald Rood @ik_zelf Monitoring Oracle with zabbix on Oracle
- 2. What I do principalconsultant @ Ciber Oracle DBA Oracle ACE Oracle Certified Master Father of 2 Scouting Skeeler http://twitter.com/ik_zelf http://github.com/ikzelf http://ronr.blogspot.com https://www.packtpub.com/big-data-and-business- intelligence/mastering-oracle-scheduler-oracle-11g- databases monitoring enthusiast IT veteran, does not believe something is impossible • Oracle Database and Network Monitoring in the Cloud with Zabbix2
- 3. Klik om detekststijl • Klik om de tekststijl van het model te bewerken What Ciber does
- 4. Monitoring solutions home grownscripts and email Oracle Enterprise Manager Oracle Grid Control Oracle Cloud Control Nagios Zabbix heart beat …._________… • Oracle Database and Network Monitoring in the Cloud with Zabbix4
- 5. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix5 § The design principle: KISS § Heartbeat § Mature § [Re]active development § Active community • IRC is very active irc://verne.freenode.net/zabbix • Zabbix forum https://www.zabbix.com/forum/ § Large installed base § Very stable § Good Oracle database citizen (can still be improved) § easy to extend with plugins Why Zabbix?
- 6. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix6 § Installation from source • - name: install instant client /usr/lib/oracle/12.1/client/ • yum: name={{ item }} state=present • with_items: • - oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm • - oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm • - oracle-instantclient12.1-precomp-12.1.0.2.0-1.x86_64.rpm • - oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm • ./configure --enable-server --with-oracle=yes --with-oracle-include=/usr/include/oracle/12.1/client64 -- with-oracle-lib=/usr/lib/oracle/12.1/client64/lib --with-net-snmp --with-ssh2 --with-openipmi --with-ldap --with-libcurl --with-jabber --with-unixodbc --with-openssl --with-libxml2" § pre build packages yum • zabbix offical yum repository at http://repo.zabbix.com/ server and proxy must have same main version • this is a pity, nice would be to have backward compatibility to make upgrades more manageable server (and proxy) supports all versions of agents • wow! Installation of zabbix - on Oracle
- 7. Configuration of zabbix §Server §Agent §Proxy •Oracle Database and Network Monitoring in the Cloud with Zabbix7
- 8. Configuration of zabbix §serverdoes all central functions §update database §insert new data §maintain history §analyse data §trigger alerts §activate scripts/actions §push notifications - zabkit §ticket creations §maintain history • Oracle Database and Network Monitoring in the Cloud with Zabbix8
- 9. Configuration of zabbix §agentdoes data collection §active §passive §auto registration - must be active agent • Oracle Database and Network Monitoring in the Cloud with Zabbix9 - name: adjust agent config file lineinfile: dest={{ item.file }} regexp="^{{ item.key }} *=" line="{{ item.key }} = {{ item.value }}" create=yes state=present with_items: - { file: /etc/zabbix/zabbix_agentd.conf, key: LogFileSize, value: 1 } - { file: /etc/zabbix/zabbix_agentd.conf, key: User, value: zabbixa } - { file: /etc/zabbix/zabbix_agentd.conf, key: Hostname, value: "{{ zabbix_hostname }}" } - { file: /etc/zabbix/zabbix_agentd.conf, key: HostMetadataItem, value: "system.uname" } - { file: /etc/zabbix/zabbix_agentd.conf, key: Server, value: "{{ zabbix_agents_server }}" } - { file: /etc/zabbix/zabbix_agentd.conf, key: ServerAcQve, value: "{{ zabbix_agents_server }}" } - { file: /etc/zabbix/zabbix_agentd.conf, key: UserParameter, value: "custom.vfs.dev.discovery,/opt/ zabbix/linux/queryDisks.pl" }
- 10. Configuration of zabbix §proxyway to couple networks to server §active §passive §does caching when server not reachable §since v3 encryption supported §think about upgrades! • Oracle Database and Network Monitoring in the Cloud with Zabbix10
- 11. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix11 1. Prepare packages 2. shutdown proxies 3. shutdown server 4. when using sqlite as proxy database: remove cache database (no upgrade) 5. upgrade proxies 6. start proxies - this re-creates the cache database (no upgrade for sqlite) 7. upgrade server 8. start server 9. cached data comes in first (maintenance mode might prevent a few alerts) Upgrade from v2 to v3 DownQme is a maUer of minutes Database upgrade is automaQc
- 12. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix12 § data collection is not limited by agents § user scripts can collect data and act as extension for active agents • key,script -> stdout • keep it quick! § user scripts can collect data and use zabbix_sender to send data to server § zabbix_sender not only handles measurements, also lld json arrays (on one line) Data collection
- 13. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix13 §the biggest pitfall is creating items on hosts §almost certainly there will be more hosts with same item[s] §create templates §use MACROS for tunables §use value lists to explain the meaning of values §use prefixes to visually relate MACROS to templates templates
- 14. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix14 §very powerful mechanism to detect variable lists of items (tablespaces,users) §LLD basically gives lists of items §passes a json array to the server §think about what happens when item is no longer discovered §The discovered items can have all kinds of definitions on them (triggers, graphs, screens) §In the discovery rule there are the prototypes lld - Low Level Discovery
- 15. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix15 host p_ts.lld 1458212406 {“data":[ {"{#TS_NAME}": "SYSTEM", "{#PDB}": null} , {"{#TS_NAME}": "CTXD", "{#PDB}": null} , {"{#TS_NAME}": "OWAPUB", "{#PDB}": null} , {"{#TS_NAME}": "ODM", "{#PDB}": null} <snip> ]} example lld data Permanent TableSpaces host has to be known in zabbix and have the template attached p_ts.lld has to be a key in the discovery rules for the host 1458212406 unix timestamp when the discovery was done (date “+%s”) data is the discovered array There will be item prototypes where {#TS_NAME} and {#PDB} are placeholders for the names in Item Prototypes When using zabbix_sender, make sure the complete array is on 1 line.
- 16. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix16 f f f Zabbix Trapper and Calculated types. Item prototypes for p_ts.lld
- 17. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix17 Simple item, from Zabbix trapper
- 18. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix18 Calculated Item prototype
- 19. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix19 Predictive Item Prototype how much data to analyze?
- 20. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix20 host p_ts[,USERS,maxsize] 1458212417 524288000 host p_ts[,SYSTEM,maxsize] 1458212417 18027118592 host p_ts[,APPS_TS_INTERFACE,maxsize] 1458212417 18874368000 host p_ts[,ODM,maxsize] 1458212417 104857600 Think about quoting! Space is column delimiter, if space can be in key, quote the key Missing value? -> null Example data for zabbix_sender
- 21. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix21 §agent can register itself to the server §server can scan for new hosts in the network §with zabbix_sender we can auto define hosts using templates § a host is owner of discovered items … (also discovered hosts) Host discovery
- 22. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix22 § there are several tools to monitor databases and pass data to zabbix § Zabbix-v3 also has internal odbc support § tools like dbforbix Java based and a bit hard to grasp (for me) • http://www.smartmarmot.com/product/dbforbix/ § zbxora.py is born • https://github.com/ikzelf/zbxora Oracle monitoring integration
- 23. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix23 zbxora is a zabbix plugin consisting of § zbxora.py § oracle query files for primary/standby/asm instances § zabbix template • Low Level Discovery rules (lld) • items • triggers • graphs § queries per version of Oracle § zbxora_starter § zbxora_sender Oracle monitoring integration - zbxora
- 24. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix24 § Very user extensible § Very open § Very simple to use § runs from a client using SQL*net (the machine running the proxy is a good candidate) § needs a regular Oracle client installation (instant client is OK) § requires python 2.7 or newer § requires cx_Oracle § http://ronr.blogspot.nl/2015/09/install-python-without-root-access-to.html?m=1 § monitors itself § collects data in files per connection § zbxora_sender collects the zbxora output and sends them to the server § zbxora_sender keeps a little history for debugging purposes § zbxora_starter is meant to guarantee your monitors are running Oracle monitoring integration - zbxora
- 25. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix25 make new server compatible with previous version of proxy. make remote tasks possible for agents behind proxy - will be done. make more use of bind variables when running in Oracle database. make use of bulk operations when running in Oracle database. make use of an install and of a runtime user in the database. make a current timestamp variable to add in notifications. my requests for zabbix
- 26. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix26 Questions?
- 27. • Oracle Databaseand Network Monitoring in the Cloud with Zabbix27