Ok, I'm a newbie at Zabbix. I'm having some issues creating a Discovery Rule to discover Database on a server. We currently are using Zabora, and I've added Items to monitor DB setting without a problem. In our environment we have over 800+ Oracle databases spread across 100+ servers, so ease of deployment is important.
I have a KSH script which reads the oratab file and can output to STDOUT or a file in either of the following formats and successfully executes from Zabbix.
> cat database.sh
# sort -t: -k1 /etc/oratab | grep -v '^\s*$\|^#\|^\s*\#' | grep -v 'AGENT' | awk -F":" '{ print "[" ""$1"" "," ""$2"" "]"}'
# sort -t: -k1 /etc/oratab | grep -v '^\s*$\|^#\|^\s*\#' | grep -v 'AGENT' | awk -F":" '{ print "[" ""$1"" "," ""$2"" "]"}' >>/etc/zabbix/scripts/agentd/zabora/zabora.log
sort -t: -k1 /etc/oratab | grep -v '^\s*$\|^#\|^\s*\#' | grep -v 'AGENT' | awk -F":" '{ print ""$1"" }'
sort -t: -k1 /etc/oratab | grep -v '^\s*$\|^#\|^\s*\#' | grep -v 'AGENT' | awk -F":" '{ print ""$1"" }' >>/etc/zabbix/scripts/agentd/zabora/zabora.log
+ASM
marctest
TDSTGRID
TDSTRMAN
-or-
[+ASM,/apps/orabase/app/grid12c]
[marctest,/apps/orabase/app/oracle/product/12.1.0.2]
[TDSTGRID,/apps/orabase/app/oracle/product/12.1.0.2]
[TDSTRMAN,/apps/orabase/app/oracle/product/12.1.0.2]
So my problem, is:
1. How do I read either one of these, or another format into Zabbix?
2. How do I create the Item Prototype's in Zabbix?
Thanks,
Marc
I have a KSH script which reads the oratab file and can output to STDOUT or a file in either of the following formats and successfully executes from Zabbix.
> cat database.sh
# sort -t: -k1 /etc/oratab | grep -v '^\s*$\|^#\|^\s*\#' | grep -v 'AGENT' | awk -F":" '{ print "[" ""$1"" "," ""$2"" "]"}'
# sort -t: -k1 /etc/oratab | grep -v '^\s*$\|^#\|^\s*\#' | grep -v 'AGENT' | awk -F":" '{ print "[" ""$1"" "," ""$2"" "]"}' >>/etc/zabbix/scripts/agentd/zabora/zabora.log
sort -t: -k1 /etc/oratab | grep -v '^\s*$\|^#\|^\s*\#' | grep -v 'AGENT' | awk -F":" '{ print ""$1"" }'
sort -t: -k1 /etc/oratab | grep -v '^\s*$\|^#\|^\s*\#' | grep -v 'AGENT' | awk -F":" '{ print ""$1"" }' >>/etc/zabbix/scripts/agentd/zabora/zabora.log
+ASM
marctest
TDSTGRID
TDSTRMAN
-or-
[+ASM,/apps/orabase/app/grid12c]
[marctest,/apps/orabase/app/oracle/product/12.1.0.2]
[TDSTGRID,/apps/orabase/app/oracle/product/12.1.0.2]
[TDSTRMAN,/apps/orabase/app/oracle/product/12.1.0.2]
So my problem, is:
1. How do I read either one of these, or another format into Zabbix?
2. How do I create the Item Prototype's in Zabbix?
Thanks,
Marc