Orabbix and 9i

[jacifr09]

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]

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

[jacifr09]

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

[dalle]

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

[jacifr09]

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

[dalle]

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.