Monitoramento Oracle com Orabbix

[emersonmartins8]

Olá pessoal.

Venha tentando resolver um problema de conexao com banco de dados Oracle versao 11g R2 no zabbix com o plugin Orabbix;

No inicio ele ate conecta porém recebo apos uma mensagem de alerta e no zabbix nao gera os graficos.

Ambiente

Zabbix Server 2.4.3
Centos 7 x64

Segue log.
2014-08-19 19:25:37,574 [main] INFO Orabbix - Starting Orabbix Version 1.2.3
2014-08-19 19:25:37,582 [main] INFO Orabbix - Orabbix started with pid:5703
2014-08-19 19:25:37,582 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2014-08-19 19:25:37,661 [main] INFO Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@76ff3813
2014-08-19 19:25:37,661 [main] INFO Orabbix - URL=jdbcracle:thin:@serverhomol:1521rod
2014-08-19 19:25:37,661 [main] INFO Orabbix - maxPoolSize=10
2014-08-19 19:25:37,661 [main] INFO Orabbix - maxIdleSize=1
2014-08-19 19:25:37,661 [main] INFO Orabbix - maxIdleTime=1800000ms
2014-08-19 19:25:37,661 [main] INFO Orabbix - poolTimeout=100
2014-08-19 19:25:37,661 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
2014-08-19 19:25:37,661 [main] INFO Orabbix - numTestsPerEvictionRun=3
2014-08-19 19:25:37,977 [main] INFO Orabbix - Connected as ZABBIX
2014-08-19 19:25:37,978 [main] INFO Orabbix - --------- on Database -> PROD
2014-08-19 19:25:38,459 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'alive'
2014-08-19 19:25:38,460 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'Orabbix.Version'
2014-08-19 19:25:38,461 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'archive'
2014-08-19 19:25:38,462 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'audit'
2014-08-19 19:25:38,463 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'dbblockgets'
2014-08-19 19:25:38,464 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'dbconsistentgets'
2014-08-19 19:25:38,465 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'dbhitratio'
2014-08-19 19:25:38,466 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'dbphysicalread'
2014-08-19 19:25:38,467 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'dbversion'
2014-08-19 19:25:38,468 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'hitratio_body'
2014-08-19 19:25:38,469 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'hitratio_sqlarea'
2014-08-19 19:25:38,471 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'hitratio_table_proc'
2014-08-19 19:25:38,471 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'lio_current_read'
2014-08-19 19:25:38,472 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'locks'
2014-08-19 19:25:38,473 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'maxprocs'
2014-08-19 19:25:38,474 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'maxsession'
2014-08-19 19:25:38,475 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'miss_latch'
2014-08-19 19:25:38,476 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'pga_aggregate_target'
2014-08-19 19:25:38,477 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'pga'
2014-08-19 19:25:38,477 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXDZBX_NOTSUPPORTED' for key 'phio_datafile_reads'

[emersonmartins8]

Olá pessoal problema resolvido.

A causa raiz era que no arquivo config.props eu não estava colocando o nome do host monitorado nas linhas dos databases conforme abaixo:


----->>>>
#put here your databases in a comma separated list
DatabaseList=PROD

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