Ad Widget

Collapse

Orabbix:"Another way to monitor Oracle reloaded"

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

    Orabbix:"Another way to monitor Oracle reloaded"

    I’ve released my first release of orabbix.

    Orabbix is a plug-in for zabbix, and more or less do the same work of check_ora BUT has this pros (compared with shell script):

    * connection pool
    * use log4j
    * is completely in java

    so pratically:

    * you don’t need more to install an oracle client (simply download this package and install)
    * you will neve see listener.log on oracle server that grown anc ocntinue to grown (because in check_ora for every query there is a new connection) here everything is solved with connection pooling
    * you have a log wrote with log4j
    * is wrote in java so can run on windows and linux machine without troubles

    This is my first initial release so please give any feedback to me and in particular this is tested on redhat EL 5.3 and with java-1.6.0-openjdk.x86_64 prm package it’s tested also with java jre 1.6.0_10, actually work with Zabbix server 1.6.6.

    This initial release is downloadable here:
    https://sourceforge.net/projects/orabbix/

    more info here:
    http://www.smartmarmot.com/
    Last edited by dalle; 24-05-2010, 22:17.
    Andrea Dalle Vacche
    website:http://www.smartmarmot.com/
    e-mail:
    Author of:Mastering Zabbix Book - second edition
    Zabbix Network Monitoring Essentials

    #2
    Orabbix 0.2 released

    In this release there are some correction, i’ve removed some dead code, and in particular added this new item:

    * a new query to inspect user locked as LOCKED(TIMED) and EXPIRED(GRACE)

    so you can receive a mail if someone lock an user on database.

    I consider this item foundamental to keep monitored users on production databases.

    I’ve correct the bug that hang orabbix if you have wrong connection parameter.

    An last but not the least i’ve added a new parameter on query.props <QUERY_NAME>.NoDataFound= where you can spacify a value that will be used when no data are founded so you can grep this value on trigger.

    Download the new version here:

    https://sourceforge.net/projects/orabbix/


    http://www.smartmarmot.com/
    Last edited by dalle; 24-05-2010, 22:17.
    Andrea Dalle Vacche
    website:http://www.smartmarmot.com/
    e-mail:
    Author of:Mastering Zabbix Book - second edition
    Zabbix Network Monitoring Essentials

    Comment


      #3
      Orabbix 0.3 released

      In this new release :

      1. fixed trouble with connection, now if a database is unavailable will be removed and on next loop the daemon try again to get connection and execute query etc..
      2. added dynamics configuration features, if you add a database this will be used on next loop.
      3. added a new parameter ZabbixDaemon.MaxThreadNumber on config.props

      There is only a constraint with thid dynamics configuration the parameter ZabbixDaemon.MaxThreadNumber need be >= of the number of your databases.

      this new release is available for donwload here:

      https://sourceforge.net/projects/orabbix/


      more info here:http://www.smartmarmot.com/
      Last edited by dalle; 24-05-2010, 22:17.
      Andrea Dalle Vacche
      website:http://www.smartmarmot.com/
      e-mail:
      Author of:Mastering Zabbix Book - second edition
      Zabbix Network Monitoring Essentials

      Comment


        #4
        Orabbix 0.4 Released

        I’m using this on production servers on RedHat EL 5.3 , with zabbix server 1.6.6, if someone can try on zabbix server 1.8.1 i’ll be happy to receive a feedback.

        On this release:

        * Modified the version query now return :

        - DB_NAME = <dbname> – INSTANCE_NAME = <instancename>

        - SERVERNAME = <server.example.com> – SERVERADDRESS = <192.168.0.1>
        CATALOG Oracle Database Catalog Views 10.2.0.4.0 VALID
        CATJAVA Oracle Database Java Packages 10.2.0.4.0 VALID
        CATPROC Oracle Database Packages and Types 10.2.0.4.0 VALID
        EXF Oracle Expression Filter 10.2.0.4.0 VALID
        JAVAVM JServer JAVA Virtual Machine 10.2.0.4.0 VALID
        ORDIM Oracle interMedia 10.2.0.4.0 VALID
        OWM Oracle Workspace Manager 10.2.0.4.3 VALID
        RUL Oracle Rules Manager 10.2.0.4.0 VALID
        XDB Oracle XML Database 10.2.0.4.0 VALID
        XML Oracle XDK 10.2.0.4.0 VALID

        as you can see i’ve added this information: DB_NAME INSTANCE_NAME SERVERNAME SERVERADDRESS. DB_NAME and INSTANCE_NAME can be different just in case of RAC or DATAGUARD configuration.

        * Modified how retrieve the values from resultset now is supported an output with more column and more rows

        * Database are removed dynamically this mean that you can add and remove database without restart the daemon.
        * Founded a little bug on connection to database, there was a connection that was idle and never used now is fixed.

        New release available at:

        https://sourceforge.net/projects/orabbix/


        more info here:
        http://www.smartmarmot.com/
        Last edited by dalle; 24-05-2010, 22:17.
        Andrea Dalle Vacche
        website:http://www.smartmarmot.com/
        e-mail:
        Author of:Mastering Zabbix Book - second edition
        Zabbix Network Monitoring Essentials

        Comment


          #5
          Orabbix 0.5 released

          I've released a new version of Orabbix.
          actual improvements are:
          1) Added retry on ZabbixSend items and values (max 10 times) , increased socket timeout to 30 sec.
          2) Now exception are managed better and is less verbose i've revisited all loglevel to clean the software
          Actually this daemon keep monitored 43 Oracle instances on mine production environment, with success

          see ya
          more info available:
          http://rootzone.wordpress.com/
          downloadable here:
          http://www.smartmarmot.com/
          Last edited by dalle; 24-05-2010, 22:17.
          Andrea Dalle Vacche
          website:http://www.smartmarmot.com/
          e-mail:
          Author of:Mastering Zabbix Book - second edition
          Zabbix Network Monitoring Essentials

          Comment


            #6
            Orabbix 0.6 Released

            What's new on this release 0.6:

            1. Added an item to monitor Data Guard Error, and the relative trigger.
            2. Changed parameter in config.properties from ZabbixDaemon to OrabbixDaemon because are cause of a lot of confusion.
            3. Wrote a better documentation

            Now the documentation is more or less complete!

            download the new release here:

            https://sourceforge.net/projects/orabbix/

            More info here:

            http://www.smartmarmot.com/


            nice day
            Last edited by dalle; 24-05-2010, 22:18.
            Andrea Dalle Vacche
            website:http://www.smartmarmot.com/
            e-mail:
            Author of:Mastering Zabbix Book - second edition
            Zabbix Network Monitoring Essentials

            Comment


              #7
              I'm having problems with 0.6

              Code:
              Starting Orabbix service:
              
              java.lang.NullPointerException
              at java.io.File.<init>(File.java:222)
              at com.orabbix.Configurator.<init>(Configurator.java:47)
              at main.main(main.java:65)
              The orabbix.log file only contained the following:

              2010-04-14 13:31:37,652 [main] INFO Orabbix - Starting Orabbix Version 0.6


              My config.props looks like this:

              Code:
              ZabbixServer.Address=10.150.0.20
              ZabbixServer.Port=10051
              
              #frequency of item's refresh
              OrabbixDaemon.Sleep=300
              #MaxThreadNumber should be >= than the number of your databases
              OrabbixDaemon.MaxThreadNumber=100
              
              #put here your databases in a comma separated list
              DatabaseList=CZAB11DB
              
              #Configuration of Connection pool
              #Maximum number of active connection inside pool
              DatabaseList.MaxActive=10
              #The maximum number of milliseconds that the pool will wait 
              #(when there are no available connections) for a connection to be returned 
              
              #before throwing an exception, or <= 0 to wait indefinitely. 
              DatabaseList.MaxWait=100
              DatabaseList.MaxIdle=1
              
              #define here your connection string for each database
              CZAB11DB.Url=jdbc:oracle:thin:@czab11db.incert.REDACTED.com:1560:CZAB11DB
              CZAB11DB.User=zabbix_dbuser
              CZAB11DB.Password=REDACTED
              
              #Query Parameter Files 
              OracleQUeryListFile=/opt/orabbix/conf/query.props

              Comment


                #8
                It's amazing what you find when you paste something.

                That last line had an erroneous capital U:
                Code:
                OracleQUeryListFile=/opt/orabbix/conf/query.props
                I corrected it to:
                Code:
                OracleQueryListFile=/opt/orabbix/conf/query.props
                It worked after that.

                Comment


                  #9
                  Your template is completely empty

                  Code:
                  <?xml version="1.0"?>
                  <zabbix_export version="1.0" date="08.04.10" time="18.32">
                          <hosts>
                                  <host name="Template_Oracle">
                                          <useip>0</useip>
                                          <dns></dns>
                                          <ip>0.0.0.0</ip>
                                          <port>10050</port>
                                          <status>3</status>
                                          <groups>
                                                  <group>Templates</group>
                                          </groups>
                                  </host>
                          </hosts>
                  </zabbix_export>
                  Do you have an actual export of these items?

                  Comment


                    #10
                    Orabbix Version 0.6 - XML-Template is empty

                    Hi Andrea,

                    thanks for the nice tool ;-)

                    My Systems...

                    Oracle-Clientssystem:
                    RHEL4 Update4
                    Java version 1.6.0_19
                    ORACLE RDBMS 10.2.0.3.0
                    Orabbix Version 0.6

                    Zabbix-System:
                    Debian 6
                    Zabbix Server 1.8.2
                    Mysql-server 5.1.41

                    I start orrabbix with your start-script, I guess it looks fine :-). You can see in the logfile.

                    Code:
                    2010-04-15 09:10:58,130 [main] INFO  Orabbix - Starting Orabbix Version 0.6
                     2010-04-15 09:11:00,019 [main] INFO  Orabbix - Connected as ZABBIX
                     2010-04-15 09:11:00,026 [main] INFO  Orabbix - --------- on Database -> tlp
                     2010-04-15 09:11:42,247 [pool-1-thread-1] INFO  Orabbix - Done with dbJob on database tlp elapsed time 42132 ms
                     2010-04-15 09:16:43,962 [pool-1-thread-2] INFO  Orabbix - Done with dbJob on database tlp elapsed time 43826 ms
                    The orabbix installation-description is good, but how can i integrate it in zabbix. Can you explain it?
                    The XML-Template is empty :-( Can you fix it ?

                    Thanks a lot!

                    blue

                    Comment


                      #11
                      You are right,
                      i don't know why but the last export of mine template is empty.. i'm sorry about.
                      Just import this one in attach to see graph, item received etc.. let me know if work
                      Have a nice day
                      Dalle
                      Attached Files
                      Last edited by dalle; 15-04-2010, 09:07.
                      Andrea Dalle Vacche
                      website:http://www.smartmarmot.com/
                      e-mail:
                      Author of:Mastering Zabbix Book - second edition
                      Zabbix Network Monitoring Essentials

                      Comment


                        #12
                        Orabbix Version 0.6.1 a little fix on template

                        This is the same release i've just updated the template_oracle.xml inside Template directory.
                        I'm sorry but the old one was empty, please us this release instead Orabbix 0.6.

                        You ca download from here the new release
                        https://sourceforge.net/projects/orabbix/

                        more info here:
                        http://www.smartmarmot.com/
                        see ya
                        Dalle
                        Last edited by dalle; 24-05-2010, 22:18.
                        Andrea Dalle Vacche
                        website:http://www.smartmarmot.com/
                        e-mail:
                        Author of:Mastering Zabbix Book - second edition
                        Zabbix Network Monitoring Essentials

                        Comment


                          #13
                          Hi,

                          thanks, i try it with the new release ;-)

                          Comment


                            #14
                            Originally posted by blueunderground View Post
                            Hi,

                            thanks, i try it with the new release ;-)
                            you can just import the template the release is the same
                            Andrea Dalle Vacche
                            website:http://www.smartmarmot.com/
                            e-mail:
                            Author of:Mastering Zabbix Book - second edition
                            Zabbix Network Monitoring Essentials

                            Comment


                              #15
                              okay, i have import it.

                              What must i do next?

                              Send the Orabbix-Client the data to the zabbix-server? How can i check it ?

                              Comment

                              Announcement

                              Collapse
                              No announcement yet.
                              Working...
                              X