Ad Widget

Collapse

Orabbix and 9i

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jacifr09
    Junior Member
    • Sep 2010
    • 9

    #1

    Orabbix and 9i

    Hi

    has anyone either managed to get orabbix working with 9i R2 or defined a query.props file that would work against such an instance?


    thanks for reading..
    Jacifr
  • dalle
    Senior Member
    Zabbix Certified Specialist
    • Mar 2009
    • 402

    #2
    what exactly don't work?
    I'm sorry but I don't have more oracle 9i so for me it's hard to test
    anyway let me know I'll try to help you
    Andrea Dalle Vacche
    website:http://www.smartmarmot.com/
    e-mail:
    Author of:Mastering Zabbix Book - second edition
    Zabbix Network Monitoring Essentials

    Comment

    • jacifr09
      Junior Member
      • Sep 2010
      • 9

      #3
      orabbix and 9i

      Thanks for getting back. not sure I have configured properly but I put it down to the fact I have 9i databases and orabbix is cert'd against on 10/11g, or I'm just being thick..!
      I have loads of 9i if you want me to test for you
      getting:
      2011-05-09 15:03:48,797 [main] INFO Orabbix - Orabbix started with pid:12372
      2011-05-09 15:03:48,797 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
      2011-05-09 15:03:48,820 [main] ERROR Orabbix - Error on Configurator getConnection while getting avdev5.Url null
      2011-05-09 15:03:48,900 [main] ERROR Orabbix - Error on Configurator for database avdev5 -->No suitable driver found for
      2011-05-09 15:03:48,901 [main] INFO Orabbix - This Database avdev5 removed
      2011-05-09 15:03:48,965 [main] INFO Orabbix - New database founded! avdev5
      2011-05-09 15:03:48,966 [main] ERROR Orabbix - Error on Configurator getConnection while getting avdev5.Url null
      2011-05-09 15:03:48,966 [main] ERROR Orabbix - Error on Configurator for database avdev5 -->No suitable driver found for

      main props from conf are :
      ZabbixServerList=localhost
      ZabbixServer1.Address=10.40.10*.***
      ZabbixServer1.Port=10051
      DatabaseList=avdev5
      vm-avdev5.Url=jdbcracle:thin:@vm-avdev5:1521:avdev5
      avdev5.User=ZABBIX
      avdev5.Password=lalalaala

      thanks
      Jacifr

      Comment

      • dalle
        Senior Member
        Zabbix Certified Specialist
        • Mar 2009
        • 402

        #4
        Originally posted by jacifr09
        Thanks for getting back. not sure I have configured properly but I put it down to the fact I have 9i databases and orabbix is cert'd against on 10/11g, or I'm just being thick..!
        I have loads of 9i if you want me to test for you
        getting:
        2011-05-09 15:03:48,797 [main] INFO Orabbix - Orabbix started with pid:12372
        2011-05-09 15:03:48,797 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
        2011-05-09 15:03:48,820 [main] ERROR Orabbix - Error on Configurator getConnection while getting avdev5.Url null
        2011-05-09 15:03:48,900 [main] ERROR Orabbix - Error on Configurator for database avdev5 -->No suitable driver found for
        2011-05-09 15:03:48,901 [main] INFO Orabbix - This Database avdev5 removed
        2011-05-09 15:03:48,965 [main] INFO Orabbix - New database founded! avdev5
        2011-05-09 15:03:48,966 [main] ERROR Orabbix - Error on Configurator getConnection while getting avdev5.Url null
        2011-05-09 15:03:48,966 [main] ERROR Orabbix - Error on Configurator for database avdev5 -->No suitable driver found for

        main props from conf are :
        ZabbixServerList=localhost
        ZabbixServer1.Address=10.40.10*.***
        ZabbixServer1.Port=10051
        DatabaseList=avdev5
        vm-avdev5.Url=jdbcracle:thin:@vm-avdev5:1521:avdev5
        avdev5.User=ZABBIX
        avdev5.Password=lalalaala

        thanks
        Jacifr
        mmmm sorry but you have specified "DatabaseList=avdev5"
        so Orabbix is waiting to find a database called
        avdev5
        and not
        "vm-avdev5"
        as you have specified
        on config file.
        you should solve so
        Andrea Dalle Vacche
        website:http://www.smartmarmot.com/
        e-mail:
        Author of:Mastering Zabbix Book - second edition
        Zabbix Network Monitoring Essentials

        Comment

        • jacifr09
          Junior Member
          • Sep 2010
          • 9

          #5
          thats it thanks, also had to remove the lock monitor as per the other thread as the cpu was bombing out
          thanks for your help

          Comment

          • dalle
            Senior Member
            Zabbix Certified Specialist
            • Mar 2009
            • 402

            #6
            I know the queries that can be really heavy are "locks" and "audit" I can't debug locks on oracle 9i because I don't have anymore oracle 9i on my environment.
            Andrea Dalle Vacche
            website:http://www.smartmarmot.com/
            e-mail:
            Author of:Mastering Zabbix Book - second edition
            Zabbix Network Monitoring Essentials

            Comment

            Working...