Orabbix:"Another way to monitor Oracle reloaded"

[dalle]

It's ok now:

2010-08-12 14:42:10,284 [main] INFO Orabbix - PidFile -> /opt/orabbix/logs/orabbix.pid
2010-08-12 14:42:10,746 [main] INFO Orabbix - Connected as SYSTEM
2010-08-12 14:42:10,748 [main] INFO Orabbix - --------- on Database -> orarec
2010-08-12 14:42:15,096 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database orarec QueryList elapsed time 4328 ms

Thankyou i'll publish this release

[dalle]

Orabbix 1.0.2 is Out

I've correct a bug and added a new feature:
Now Orabbix send his own "presentation banner" as item

more info on my website

http://www.smartmarmot.com

[yoda]

Just some warnings when importing triggers:

# Undefined offset: 1[/var/www/zabbix/include/triggers.inc.php:1950]
# Undefined offset: 1[/var/www/zabbix/include/triggers.inc.php:1950]

[dalle]

Just some warnings when importing triggers:

# Undefined offset: 1[/var/www/zabbix/include/triggers.inc.php:1950]
# Undefined offset: 1[/var/www/zabbix/include/triggers.inc.php:1950]

try with this one and let me know thanks for patience

[yoda]

Same warnings (note that they are only warnings: template is imported successfully).

[dalle]

Same warnings (note that they are only warnings: template is imported successfully).

Thankyou but I will be glad to know why there are always warning....

[dantony79]

cannot start orabbix

i cannot start orabbix.

can someone help me on this.

2010-08-23 12:28:04,167 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2010-08-23 12:28:04,168 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .Url null
2010-08-23 12:28:04,168 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .User null
2010-08-23 12:28:04,169 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .Password null
2010-08-23 12:28:04,186 [main] INFO Orabbix - Note: TEST .MaxActive null
2010-08-23 12:28:04,186 [main] INFO Orabbix - Note: TEST .MaxWait null
2010-08-23 12:28:04,186 [main] INFO Orabbix - Note: TEST .MaxIdle null
2010-08-23 12:28:04,188 [main] ERROR Orabbix - Error on Configurator for database TEST -->No suitable driver found for
2010-08-23 12:28:04,194 [main] WARN Orabbix - New Database Founded: adding database TEST
2010-08-23 12:28:04,194 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .Url null
2010-08-23 12:28:04,195 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .User null
2010-08-23 12:28:04,195 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .Password null
2010-08-23 12:28:04,195 [main] INFO Orabbix - Note: TEST .MaxActive null
2010-08-23 12:28:04,195 [main] INFO Orabbix - Note: TEST .MaxWait null
2010-08-23 12:28:04,195 [main] INFO Orabbix - Note: TEST .MaxIdle null
2010-08-23 12:28:04,195 [main] ERROR Orabbix - Error on Configurator for database TEST -->No suitable driver found for

#################################################

[root@/opt]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
[root@/opt]# uname -a
Linux ed-zab-test.xxx.com 2.6.18-194.0.0.0.4.el5 #1 SMP Thu Apr 8 18:35:38 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
##################################################

[root@/opt]# cat conf/config.props
#comma separed list of Zabbix servers
ZabbixServerList=ZabbixServer1

ZabbixServer1.Address=10.100.100.99
ZabbixServer1.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=TEST

#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
TEST.Url=jdbcracle:thin:@10.10.10.10:1541:TEST
TEST.User=zabbix
TEST.Password=golfgti

#Those values are optionals if not specified Orabbix is going to use the general values
TEST.MaxActive=10
TEST.MaxWait=100
TEST.MaxIdle=1




#Query Parameter Files
QueryListFile=/opt/orabbix/conf/query.props

[dalle]

can you attach your conf file? or send me as private message
may be there are some special character that are not printed or use an editor that show newlines and all special character may be there are some character in UTF-16 or similar after
"TEST.User=zabbix"

[dantony79]

Plz see the config file

[root@ed-zab-test orabbix]# cat conf/config.props
#comma separed list of Zabbix servers
ZabbixServerList=ZabbixServer1

ZabbixServer1.Address=10.100.100.99
ZabbixServer1.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=TEST

#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
TEST.Url=jdbcracle:thin:@10.100.100.106:1541:TEST
TEST.User=zabbix
TEST.Password=golfgti
#Those values are optionals if not specified Orabbix is going to use the general values
TEST.MaxActive=10
TEST.MaxWait=100
TEST.MaxIdle=1




#Query Parameter Files
QueryListFile=/opt/orabbix/conf/query.props

Do i need to install the jdbc driver? If yes where?

on the database server or on the orabbix server.

Plz let me know if you need any other info.

[dantony79]

Plz find the attached config file

Plz find the attached config file

[dalle]

nope you don't need because i've included all on mine distribution.
Please use "attach" function of this forum with a "cat" if there are some unprintable char i can't see them
Or send me privately or on
andrea.dallevacche(AT)gmail.com

[dalle]

seem that after "TEST" there is a blank space or a tab because the error is:
"TEST .Url"
so please check if on database list after TEST there is a newline and not tab or escape character or something and let me know

i cannot start orabbix.

can someone help me on this.

2010-08-23 12:28:04,167 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2010-08-23 12:28:04,168 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .Url null
2010-08-23 12:28:04,168 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .User null
2010-08-23 12:28:04,169 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .Password null
2010-08-23 12:28:04,186 [main] INFO Orabbix - Note: TEST .MaxActive null
2010-08-23 12:28:04,186 [main] INFO Orabbix - Note: TEST .MaxWait null
2010-08-23 12:28:04,186 [main] INFO Orabbix - Note: TEST .MaxIdle null
2010-08-23 12:28:04,188 [main] ERROR Orabbix - Error on Configurator for database TEST -->No suitable driver found for
2010-08-23 12:28:04,194 [main] WARN Orabbix - New Database Founded: adding database TEST
2010-08-23 12:28:04,194 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .Url null
2010-08-23 12:28:04,195 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .User null
2010-08-23 12:28:04,195 [main] ERROR Orabbix - Error on Configurator getConnection while getting TEST .Password null
2010-08-23 12:28:04,195 [main] INFO Orabbix - Note: TEST .MaxActive null
2010-08-23 12:28:04,195 [main] INFO Orabbix - Note: TEST .MaxWait null
2010-08-23 12:28:04,195 [main] INFO Orabbix - Note: TEST .MaxIdle null
2010-08-23 12:28:04,195 [main] ERROR Orabbix - Error on Configurator for database TEST -->No suitable driver found for

#################################################

[root@/opt]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
[root@/opt]# uname -a
Linux ed-zab-test.xxx.com 2.6.18-194.0.0.0.4.el5 #1 SMP Thu Apr 8 18:35:38 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
##################################################

[root@/opt]# cat conf/config.props
#comma separed list of Zabbix servers
ZabbixServerList=ZabbixServer1

ZabbixServer1.Address=10.100.100.99
ZabbixServer1.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=TEST

#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
TEST.Url=jdbcracle:thin:@10.10.10.10:1541:TEST
TEST.User=zabbix
TEST.Password=golfgti

#Those values are optionals if not specified Orabbix is going to use the general values
TEST.MaxActive=10
TEST.MaxWait=100
TEST.MaxIdle=1




#Query Parameter Files
QueryListFile=/opt/orabbix/conf/query.props

[dalle]

Orabbix 1.0.3 released

On this release i've added:

• one items dbsize that shows the size of database in MB
• one item for db files size that graphs the size of files in MB
• added more log information on error
• correct archivelog query to run on every databases
• added a default value for uptime when Oracle is not available

For those items i've added a relative graphs
more infos on my website
www.smartmarmot.com

[sybex]

Hi dalle, ...

got a small problem with your latest version 1.0.3.
I have two servers called like

"testwinafabp" and
"testwinafabt"

both have the same "query.conf" profile in use for orabbix. Orabbix gets the data, there is no problem. But Orabbix sends the data from testwinafabp to testwinafabt and for testwinafabt to testwinafabp in zabbix. So Orabbix overcross the sending of data.

Could it be there is a problem of the length of the both servernames so orabbix? And orabbix cuts off the last letter a get wrong in sending data?

[PieterB]

Orabbix installation problem... some missing bits

I've read the installation instructions and forum a lot of times, but I just can't
succeed in receiving orabbix data. I guess I made a fault somewhere in the agent config or webinterface...

The oracle instances are running on Solaris 10.

We've the following situation:
a server/cluster named sc022hd01 with logical name sc020hd01 on which the DB is running, let's call it D04.
so
D04.Url=jdbcracle:thin:@sc020hd01.example.org:152104

This part is working: from the log4j I can see:
[pool-1-thread-10] dbname D04sending item uptime value 2660830

In the zabbix agent config
Hostname=sc022hd01

The 'normal' agent is functioning as wel, I can attach Template_Solaris which is working well.

But I can't connect / receive values when I try to add 'D04'
What values do I need with create host?
Name = D04
DNS = sc022hd01 or sc022hd01?

And the IP address, is this important? What about connect_to?