Another way to monitor Oracle

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

    #31
    zabbix check_ora 1.2 released

    n this release is included a new item and graph that is used to monitor archivelog production on a database.

    In particular i’m going to get an average value that is calculate on a slice of 10 minutes.

    So you can monitor your archivelog production, this is really useful if you have an Oracle DataGuard installation or simply to monitor the workload of transaction that are acting on youd database.

    Normally this value is really low, on mine database is something like 500 MB/hour but if an hig load is coming this value grown until 16-20GB/hour and is becoming dangerous.

    The trigger associated send a mail if this value is mode than 100MB/minute.

    downloadable here:
    https://sourceforge.net/projects/checkora/files/
    or in attachment.
    more info here:
    http://www.smartmarmot.com/
    on the following image there is the new check.
    Attached Files
    Last edited by dalle; 24-05-2010, 22:21.
    Andrea Dalle Vacche
    website:http://www.smartmarmot.com/
    e-mail:
    Author of:Mastering Zabbix Book - second edition
    Zabbix Network Monitoring Essentials

    Comment


      #32
      Monitoring Multiple Oracle Instances

      Hi for every one sorry for my pour english,

      I'm new working with Zabbix, I stay monitored two oracle server, with O.S. Linux Red Hat 4 and Oracle 9i Enterprise, but each one server have three Oracle Instances, I don't know how monitoring this instances with this method.

      As I understand it should create several new servers that have the names of each instance, I'm right?

      I appreciate any help I can offer, regards.

      Comment


        #33
        it's easy to install , simply follow the instruction inside readme.txt or in this thread or on http://rootzone.wordpress.com/2009/1...og-in-generak/.
        Btw you need add for each instance an host, and apply to this host the "template oracle", and obviously your redhat server should be able to connect to each instance with a working sqlplus etc..
        Andrea Dalle Vacche
        website:http://www.smartmarmot.com/
        e-mail:
        Author of:Mastering Zabbix Book - second edition
        Zabbix Network Monitoring Essentials

        Comment


          #34
          Hi,

          I am trying to import the template, but I am getting this error...

          Added new application Template_Oracle:Oracle
          Added new item Template_Oracle:ALERTLOG
          Added new item Template_Oracle:alertlog.warn
          Added new item Template_Oracle:archive
          Added new item Template_Oracle:audit
          Added new item Template_Oracle:cert.expire2
          Added new item Template_Oracle:connection
          Added new item Template_Oracle:dbblockgets
          Added new item Template_Oracle:dbconsistentgets
          Added new item Template_Oracle:dbhitratio
          Added new item Template_Oracle:dbphysicalread
          Added new item Template_Oracle:dbversion
          Added new item Template_Oracle:EXP
          Added new item Template_Oracle:EXPDP
          Added new item Template_Oracle:EXPDP_HISTORY
          Added new item Template_Oracle:EXP_HISTORY
          Added new item Template_Oracle:hitratio_body
          Added new item Template_Oracle:hitratio_sqlarea
          Added new item Template_Oracle:hitratio_table_proc
          Added new item Template_Oracle:hitratio_trigger
          Added new item Template_Oracle:lio_block_changes
          Added new item Template_Oracle:lio_consistent_read
          Added new item Template_Oracle:lio_current_read
          Added new item Template_Oracle:locks
          Added new item Template_Oracle:maxprocs
          Added new item Template_Oracle:maxsession
          Added new item Template_Oracle:miss_latch
          Added new item Template_Oracleerf_counter[\LogicalDisk(C\% Free Space]
          Added new item Template_Oracleerf_counter[\LogicalDisk(D\% Free Space]
          Added new item Template_Oracleerf_counter[\Paging File(_Total)\% Usage]
          Added new item Template_Oraclega
          Added new item Template_Oraclega_aggregate_target
          Added new item Template_Oraclehio_datafile_reads
          Added new item Template_Oraclehio_datafile_writes
          Added new item Template_Oraclehio_redo_writes
          Added new item Template_Oracleinhitratio_body
          Added new item Template_Oracleinhitratio_sqlarea
          Incorrect key format 'key_name[param1,param2,...]'
          Internal zabbix error
          No such monitored parameter (session) for host (Template_Oracle)
          Unknown ZABBIX internal error

          Zabbix 1.8.1

          Tkz All

          Comment


            #35
            Just for documentation, I removed this item and all works.

            <item type="2" key="pinhitratio_table-proc" value_type="0">
            <description>Pin hit ratio - TABLE/PROCEDURE</description>
            <ipmi_sensor></ipmi_sensor>
            <delay>300</delay>
            <history>90</history>
            <trends>365</trends>
            <status>0</status>
            <units>%</units>
            <multiplier>0</multiplier>
            <delta>0</delta>
            <formula>1</formula>
            <lastlogsize>0</lastlogsize>
            <logtimefmt></logtimefmt>
            <delay_flex></delay_flex>
            <params>DSN=&lt;database source name&gt;\nuser=&lt;user name&gt;\npassword=&lt;password&gt;\nsql=&lt;query &gt;</params>
            <trapper_hosts></trapper_hosts>
            <snmp_community>public</snmp_community>
            <snmp_oid>interfaces.ifTable.ifEntry.ifInOctets. 1</snmp_oid>
            <snmp_port>161</snmp_port>
            <snmpv3_securityname></snmpv3_securityname>
            <snmpv3_securitylevel>0</snmpv3_securitylevel>
            <snmpv3_authpassphrase></snmpv3_authpassphrase>
            <snmpv3_privpassphrase></snmpv3_privpassphrase>
            <applications>
            <application>Oracle</application>
            </applications>
            </item>

            Comment


              #36
              I'm sorry but i didn't have yet zabbix 1.8.1 probably is a trouble with this release, with 1.6.x the import of template don't cause any trouble, i'm sorry for the inconvenience but i can't try with your release now.
              Andrea Dalle Vacche
              website:http://www.smartmarmot.com/
              e-mail:
              Author of:Mastering Zabbix Book - second edition
              Zabbix Network Monitoring Essentials

              Comment


                #37
                Dalle,

                Thank you for your plugin for oracle, it is simple and amazing !

                Could you explain me, how this triggers works ?

                {Template_Oracle:EXP_HISTORY.str(CORRECT)}=0

                {Template_Oracle:EXPDP_HISTORY.str(CORRECT)}=0

                how put this to work ?

                Thank you !

                thiagomz

                Comment


                  #38
                  I'm really happy that you like mine work!!!
                  THANKS!!!

                  this trigger EXPDP, EXPDP_HISTORY are trigger that i use to monitor mine export on database.
                  I'm going to explain: i have another plugin, that when i have a few more of free time i'll publish, and this plugin simply keep monitored mine daily export datapump on oracle and History export. History export are export that runs on last day of each month. I use zabbix to keep monitored also rman/tsm backup whit another script, i'm sorry that this trigger and item are on template, are completely useless without the other plugin.





                  Originally posted by thiagomz View Post
                  {Template_Oracle:EXP_HISTORY.str(CORRECT)}=0

                  {Template_Oracle:EXPDP_HISTORY.str(CORRECT)}=0

                  how put this to work ?

                  Thank you !

                  thiagomz
                  Andrea Dalle Vacche
                  website:http://www.smartmarmot.com/
                  e-mail:
                  Author of:Mastering Zabbix Book - second edition
                  Zabbix Network Monitoring Essentials

                  Comment


                    #39
                    released a new version 1.2.1

                    in this release there are some minor change in particular, i have correct the template and removed some query useless.
                    Attached Files
                    Last edited by dalle; 01-03-2010, 17:00.
                    Andrea Dalle Vacche
                    website:http://www.smartmarmot.com/
                    e-mail:
                    Author of:Mastering Zabbix Book - second edition
                    Zabbix Network Monitoring Essentials

                    Comment


                      #40
                      check_ora 1.2.2 rleased

                      I’ve found a bug inside a check_ora_sendtrap.sh on line 58:

                      echo “ -s for sqlplus login connection and return time in second”

                      in particular there was an escape character and the line appear so:

                      echo “ -s for sqlplus login connection and return time in seco

                      without a correct termination, pleas download the new release 1.2.2 at

                      https://sourceforge.net/projects/checkora/
                      or in attach here
                      Attached Files
                      Andrea Dalle Vacche
                      website:http://www.smartmarmot.com/
                      e-mail:
                      Author of:Mastering Zabbix Book - second edition
                      Zabbix Network Monitoring Essentials

                      Comment


                        #41
                        One other way: send Oracle values from a Java code

                        As far as I know Oracle can run Java classes and JDBC is very handy with Oracle. To turn a java class into a Zabbix agent a Jabbix Java library can be used. See "Jabbix" thread on this cookbook topic for more information.

                        Comment


                          #42
                          please follow also this thread may be that is interesting
                          http://www.zabbix.com/forum/showthread.php?t=16391
                          any kind of feedback will be appreciate
                          nice day to everyone!
                          Dalle
                          Andrea Dalle Vacche
                          website:http://www.smartmarmot.com/
                          e-mail:
                          Author of:Mastering Zabbix Book - second edition
                          Zabbix Network Monitoring Essentials

                          Comment


                            #43
                            Orabbix 0.5 released

                            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://www.smartmarmot.com/
                            downloadable here:
                            https://sourceforge.net/projects/orabbix/
                            Last edited by dalle; 24-05-2010, 22:21.
                            Andrea Dalle Vacche
                            website:http://www.smartmarmot.com/
                            e-mail:
                            Author of:Mastering Zabbix Book - second edition
                            Zabbix Network Monitoring Essentials

                            Comment


                              #44
                              Orabbix Version 0.6.1

                              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:21.
                              Andrea Dalle Vacche
                              website:http://www.smartmarmot.com/
                              e-mail:
                              Author of:Mastering Zabbix Book - second edition
                              Zabbix Network Monitoring Essentials

                              Comment


                                #45
                                new blog

                                Hi to every one, i've moved my blog here
                                http://www.smartmarmot.com/
                                nice day
                                Andrea Dalle Vacche
                                website:http://www.smartmarmot.com/
                                e-mail:
                                Author of:Mastering Zabbix Book - second edition
                                Zabbix Network Monitoring Essentials

                                Comment

                                Announcement

                                Collapse
                                No announcement yet.
                                Working...
                                X