Ad Widget

Collapse

Problems adding LLD to discover Multiple Oracle Databases on a server

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MMoe
    Junior Member
    • Jun 2019
    • 1

    #1

    Problems adding LLD to discover Multiple Oracle Databases on a server

    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
Working...