zabbix orabbix problem 11G

[pbergdolt]

Hello,

I'm facing problem making zabbix (1.9.4)and orabbix (1.2.3) work on Solaris x86 with Oracle 11.2.0.1 instances.

I did all the config steps described on good doc
found at zabbix wiki.


It work with 10G database, but I can't make it work on a 11G2 database.
Here is what I get on orabbix log:

2012-01-13 20:57:00,408 [main] INFO Orabbix - Starting Orabbix Version 1.2.3
2012-01-13 20:57:00,439 [main] INFO Orabbix - Orabbix started with pid:12644
2012-01-13 20:57:00,439 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2012-01-13 20:57:00,617 [main] INFO Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@d1e89e
2012-01-13 20:57:00,618 [main] INFO Orabbix - URL=jdbcracle:thin:@prdbbi-prbkp-lh:1521:MCM9BSCS
2012-01-13 20:57:00,618 [main] INFO Orabbix - maxPoolSize=100
2012-01-13 20:57:00,618 [main] INFO Orabbix - maxIdleSize=1
2012-01-13 20:57:00,618 [main] INFO Orabbix - maxIdleTime=1800000ms
2012-01-13 20:57:00,618 [main] INFO Orabbix - poolTimeout=100
2012-01-13 20:57:00,618 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
2012-01-13 20:57:00,618 [main] INFO Orabbix - numTestsPerEvictionRun=3
2012-01-13 20:57:01,048 [main] ERROR Orabbix - Error on Configurator for database MCM9BSCS -->-1
2012-01-13 20:57:01,048 [main] INFO Orabbix - This Database MCM9BSCS removed


on database server side in listener log I can see connection coming.





Here is the config.props file:



bash-3.2# cat config.props
#comma separed list of Zabbix servers
ZabbixServerList=mobi103

mobi103.Address=10.99.1.37
mobi103.Port=10051

#pidFile
OrabbixDaemon.PidFile=./logs/orabbix.pid
#frequency of item's refresh
OrabbixDaemon.Sleep=300
#MaxThreadNumber should be >= than the number of your databases
OrabbixDaemon.MaxThreadNumber=20

#put here your databases in a comma separated list
DatabaseList=MCM9BSCS,MCM9RTX

#Configuration of Connection pool
#if not specified Orabbis is going to use default values (hardcoded)
#Maximum number of active connection inside pool
DatabaseList.MaxActive=100
#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
#DB1.Url=jdbcracle:thin:@server.domain.example.com:<LISTENER_PO RT>B1
#DB1.User=zabbix
#DB1.Password=zabbix_password
##Those values are optionals if not specified Orabbix is going to use the general values
#DB1.MaxActive=10
#DB1.MaxWait=100
#DB1.MaxIdle=1
#DB1.QueryListFile=./conf/query.props

MCM9BSCS.Url=jdbcracle:thin:@prdbbi-prbkp-lh:1521:MCM9BSCS
MCM9BSCS.User=ZABBIX
MCM9BSCS.Password=ZABBIX
MCM9BSCS.QueryListFile=./conf/query.props

MCM9RTX.Url=jdbcracle:thin:@prdbbi-prbkp-lh:1521:MCM9RTX
MCM9RTX.User=ZABBIX
MCM9RTX.Password=ZABBIX
MCM9RTX.QueryListFile=./conf/query.props




How can I try to find where it faild, I tried to change log level in log4J.properties but with no success.

Any help, will be appreciated.

Thanks,
Regards