Orabbix:"Another way to monitor Oracle reloaded"

[dalle]

You are right because you have all down so at startup all down database will be removed automatically....
anyway it's the same with a small patch that should send always and also if an error exist "alive"... but you should startup your database so they will have a valid state and after you can shutdown your oracle and you'll see alive in red.
Anyway I'm going to publish officially this patch as soon as possible.

[sa22]

You are right because you have all down so at startup all down database will be removed automatically....
anyway it's the same with a small patch that should send always and also if an error exist "alive"... but you should startup your database so they will have a valid state and after you can shutdown your oracle and you'll see alive in red.
Anyway I'm going to publish officially this patch as soon as possible.

but orabbix service can't start with a new .jar

[dalle]

I've released Orabbix 1.2.0-RC3 that solve "alive" issue and add some new functionality.
Now Orabbix can run as a windows service too!
there are more information here
source are availabe as usual on sourceforge
this one should be the final release
any feedback is welcome!
NOTE:There is no more a default QueryFile and now a QueryFile should be specified for each database.

[zaicnupagadi]

Hi Andrea!,

I have recently faced a little problem with orabbix. We moved one of our databases to another server.

Orabbix couldn't contact the database instance till I have changed the node name, basicly the situation looked like this:

Our database:
atmodb.Url=jdbcracle:thin:@server1.domain.pl:1521:atmodb
atmodb.User=zabbix
atmodb.Password=password

....later I have changed the server1 to server2, it wasn't working...:
atmodb.Url=jdbcracle:thin:@server2.domain.pl:1521:atmodb
atmodb.User=zabbix
atmodb.Password=password

...till I have changed the node name - I added a "1" as a suffix:
atmodb1.Url=jdbcracle:thin:@server2.domain.pl:1521:atmodb
atmodb1.User=zabbix
atmodb1.Password=password

It seemes like orabbix has some list of database linked to the hosts or sth like that, and after changing the host name I have to change also the node name.

Is this true?

[dalle]

It seemes like orabbix has some list of database linked to the hosts or sth like that, and after changing the host name I have to change also the node name.

Is this true?

Orabbix don't have any kind of internal list. It simply send the value retrieved with your connection url to "atmodb" and nothing more.
Obviously to do that you need to stop Orabbix and restart it otherwise he can't see the changes in url.

[zaicnupagadi]

Hmm we didn't restart the service because in other database we changed the host name and the instance name and it worked without the restart.

I will try to back to my previous name and restart the service.

Many thanks for your help!!

[dalle]

Hmm we didn't restart the service because in other database we changed the host name and the instance name and it worked without the restart.

I will try to back to my previous name and restart the service.

Many thanks for your help!!

AAA ok it's quite clear
if you would like to refresh a database without restart it you should remove your database "atmodb"
from the list wait that orabbix remove from databaselist (look in logfile with a tail -f)
and after you can add atmodb to the databaselist.
This because Orabbix check for new database but if you have a valid connection he don' consider to rebuild it (because destroy and create connection introduce overhead on Oracle databases)
let me know

[dalle]

Many thanks for your help!!

You are welcome!

[jplele]

about Templates

You are welcome!

Hi,dalle.

when i had Importing the your templates to zabbix server,why the ‘interval’ column nothing to show if Application with 'Oracle' ?

[fflux]

The interval for oracle checks is in the config.props.

as it's a zabbix trapper item, so zabbix has no control over that.

[jplele]

error of starting orabbix

The interval for oracle checks is in the config.props.

as it's a zabbix trapper item, so zabbix has no control over that.

thx fflux! but i found some wrong:


[root@My init.d]# ./orabbix restart
Stopping Orabbix service:./orabbix: line 35: kill: (25371) -no process
Starting Orabbix service:

[root@My init.d]# Stopping
java.lang.Exception: ERROR on main - Connections is empty
at com.smartmarmot.orabbix.Orabbixmon.run(Orabbixmon. java:101)
at com.smartmarmot.orabbix.bootstrap.main(bootstrap.j ava:54)

[root@My logs]# cat *log
2011-06-04 20:42:48,961 [main] INFO Orabbix - Starting Orabbix Version 1.2.0 RC2
2011-06-04 20:42:48,995 [main] INFO Orabbix - Orabbix started with pid:1485
2011-06-04 20:42:48,995 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2011-06-04 20:42:49,290 [main] INFO Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@2393385d
2011-06-04 20:42:49,290 [main] INFO Orabbix - URL=jdbcracle:thin:@10.1.10.213:1521rcl
2011-06-04 20:42:49,290 [main] INFO Orabbix - maxPoolSize=10
2011-06-04 20:42:49,290 [main] INFO Orabbix - maxIdleSize=1
2011-06-04 20:42:49,290 [main] INFO Orabbix - maxIdleTime=1800000ms
2011-06-04 20:42:49,291 [main] INFO Orabbix - poolTimeout=100
2011-06-04 20:42:49,292 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
2011-06-04 20:42:49,292 [main] INFO Orabbix - numTestsPerEvictionRun=3
2011-06-04 20:42:49,399 [main] ERROR Orabbix - Error on Configurator for database orcl -->IO Error: The Network Adapter could not establish the connection
2011-06-04 20:42:49,399 [main] INFO Orabbix - This Database orcl removed
2011-06-04 20:42:49,401 [main] ERROR Orabbix - ERROR on main - Connections is empty

[jplele]

config.props

[root@My conf]# cat config.props
#comma separed list of Zabbix servers
ZabbixServerList=zabbix_server

zabbix_server.Address=10.1.10.213
zabbix_server.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=100

#put here your databases in a comma separated list
DatabaseList=orcl

#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
orcl.Url=jdbcracle:thin:@10.1.10.213:1521rcl
orcl.User=zabbix
orcl.Password=zabbix
#Those values are optionals if not specified Orabbix is going to use the general values
orcl.MaxActive=10
orcl.MaxWait=100
orcl.MaxIdle=1
orcl.QueryListFile=./conf/query.props

#Query Parameter Files
#this still remain as DEFAUL query file for all databases
QueryListFile=/opt/orabbix/conf/query.props

[dalle]

thx fflux! but i found some wrong:


[root@My init.d]# ./orabbix restart
Stopping Orabbix service:./orabbix: line 35: kill: (25371) -no process
Starting Orabbix service:

[root@My init.d]# Stopping
java.lang.Exception: ERROR on main - Connections is empty
at com.smartmarmot.orabbix.Orabbixmon.run(Orabbixmon. java:101)
at com.smartmarmot.orabbix.bootstrap.main(bootstrap.j ava:54)

[root@My logs]# cat *log
2011-06-04 20:42:48,961 [main] INFO Orabbix - Starting Orabbix Version 1.2.0 RC2
2011-06-04 20:42:48,995 [main] INFO Orabbix - Orabbix started with pid:1485
2011-06-04 20:42:48,995 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2011-06-04 20:42:49,290 [main] INFO Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@2393385d
2011-06-04 20:42:49,290 [main] INFO Orabbix - URL=jdbcracle:thin:@10.1.10.213:1521rcl
2011-06-04 20:42:49,290 [main] INFO Orabbix - maxPoolSize=10
2011-06-04 20:42:49,290 [main] INFO Orabbix - maxIdleSize=1
2011-06-04 20:42:49,290 [main] INFO Orabbix - maxIdleTime=1800000ms
2011-06-04 20:42:49,291 [main] INFO Orabbix - poolTimeout=100
2011-06-04 20:42:49,292 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
2011-06-04 20:42:49,292 [main] INFO Orabbix - numTestsPerEvictionRun=3
2011-06-04 20:42:49,399 [main] ERROR Orabbix - Error on Configurator for database orcl -->IO Error: The Network Adapter could not establish the connection
2011-06-04 20:42:49,399 [main] INFO Orabbix - This Database orcl removed
2011-06-04 20:42:49,401 [main] ERROR Orabbix - ERROR on main - Connections is empty

Orabbi trap an error diuring connection may be there is a firewall or something in front of ORCL instance.
the error trapped is IO Error: The Network Adapter could not establish the connection
try to do a connection to your orcl database from your zabbix/orabbix server

[jplele]

right

Orabbi trap an error diuring connection may be there is a firewall or something in front of ORCL instance.
the error trapped is IO Error: The Network Adapter could not establish the connection
try to do a connection to your orcl database from your zabbix/orabbix server

thx dalle!

you are right,the problem is connection for DB,It's working now,thank u!

[dalle]

Orabbix 1.2.0 final release

Orabbix 1.2.0 has been released.
More info are available here

Orabbix is availabe on my website and on sourceforge as usual
have a nice day
Andrea