Orabbix:"Another way to monitor Oracle reloaded"

[n4rk0o]

Hello,

I need to monitor an Oracle server installed on Windows 2003 Server.

Orabbix is installed on my Oracle server and I modified the run.bat file.

When I start the run.bat I have an error:

log4j:WARN No appenders could be found for logger (Orabbix).
log4j:WARN Please initialize the log4j system properly.
java.lang.NullPointerException
at com.smartmarmot.orabbix.Configurator.refresh(Confi gurator.java:279)
at com.smartmarmot.orabbix.Querybox.refresh(Querybox. java:42)
at main.main(main.java:157)

Can you help me?

Thanks in advance

Best regards

[dalle]

Hello,

I need to monitor an Oracle server installed on Windows 2003 Server.

Orabbix is installed on my Oracle server and I modified the run.bat file.

When I start the run.bat I have an error:

log4j:WARN No appenders could be found for logger (Orabbix).
log4j:WARN Please initialize the log4j system properly.

this means that log4j isn't able to find log4j.properties.
please verify that there is this parameter on run.bat and it referrer to right location
-Dlog4j.configuration=./conf/log4j.properties

java.lang.NullPointerException
at com.smartmarmot.orabbix.Configurator.refresh(Confi gurator.java:279)
at com.smartmarmot.orabbix.Querybox.refresh(Querybox. java:42)
at main.main(main.java:157)

and this that is missing your query file or the specified path is incorrect
on windows you should specify your query file as follow
e.g.
QueryListFile=C:/programs/orabbix/conf/query.props

let me know

[n4rk0o]

Hello,

I tried to change the paths.

The file orabbix.pid has been created successfully.

Here is my run.bat:

java -Duser.language=en -Duser.country=US -Dlog4j.configuration=D:\Orabbix\conf\log4j.propert ies -jar D:\Orabbix\orabbix-1.2.0-RC2.jar D:\Orabbix\conf\config.props

Here is my config.props:

#comma separed list of Zabbix servers
ZabbixServerList=zabbix-server

zabbix-server.Address=XXX
zabbix-server.Port=10051

#pidFile
OrabbixDaemon.PidFile=D:/Orabbix/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=labo-oracle

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

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

I have the same errors after the changes.

Thank you.

Best regards

[fflux]

Ik think you made a mistale.
You need to install orabbix on the zabbix server, not on the oracle server.

[n4rk0o]

Hello,

Why there is a file "run.bat" so ?

It is not exactly explain in the installation documentation.

Maybe you are right.

Best regards

[dalle]

java -Duser.language=en -Duser.country=US -Dlog4j.configuration=D:\Orabbix\conf\log4j.propert ies -jar D:\Orabbix\orabbix-1.2.0-RC2.jar D:\Orabbix\conf\config.props

I see a blank space on "propert ies"
is an error introduce by cut&paste?
btw try so
java -Duser.language=en -Duser.country=US -Dlog4j.configuration=D:/Orabbix/conf/log4j.properties -jar D:/Orabbix/orabbix-1.2.0-RC2.jar D:/Orabbix/conf/config.props

with "/" instead of "\" that sometimes need to be escaped it depend about cmd.com or windows shell etc..

and let me know

[dalle]

Ik think you made a mistale.
You need to install orabbix on the zabbix server, not on the oracle server.

You're absolutely right!
the best way is to run Orabbix on Zabbix server anyway Orabbix is wrote in java and can run everywhere (more or less ).But there is an issue following this way: you need run-it as a window service otherwise you can't logoff from windows server without closing this batch

[fflux]

Wel maybe there is al windows zabbix server, not sure tho.
I just ignored that file

[dalle]

Wel maybe there is al windows zabbix server, not sure tho.
I just ignored that file

nope simply Orabbix can be detached from Zabbix installation you can put-it on windows or in another server because Orabbix use natively Zabbix protocol to comunicate with server and not zabbix_send or other stuff.
simply acquire data from another location and send it to the zabbix server

[n4rk0o]

Thank you guys.

I will try on my zabbix server. I think it will more easier.

It is possible to run Orabbix on a windows server by using SRVANY. It will create a Windows service launching the .bat file.

Best regards

[fflux]

nope simply Orabbix can be detached from Zabbix installation you can put-it on windows or in another server because Orabbix use natively Zabbix protocol to comunicate with server and not zabbix_send or other stuff.
simply acquire data from another location and send it to the zabbix server

doh, who wants to run it on windows anyway

but anyway, learned something new today, as i didn't knew that.

[sa22]

Dalle, thanks a lot for your plugin!
I have a small bug-report:

1. "locks" query hangs oracle9.2i instance, could you check it?
2. "DB Version" query doesn't return anything at oracle9.2i
3. "Archivelog" query doesn't work at oracle9.2i

Thanks!

[fflux]

@sa22

1: this is a known problem Dalle is already working on it, disable it for now.

2: new query:
dbversion.Query=select * from v$version where banner like 'Oracle%'


3: i think i made a new query for that, you might check that out:

archive.Query=select round(A.LOGS*B.AVG/1024/1024/10) from ( SELECT COUNT (*) LOGS FROM V$LOG_HISTORY WHERE FIRST_TIME >= (sysdate -10/60/24)) A, ( SELECT Avg(BYTES) AVG, Count(1), Max(BYTES) Max_Bytes, Min(BYTES) Min_Bytes FROM v$log) B
archive.RaceConditionQuery=select value from v$parameter where name='log_archive_start'
archive.RaceConditionValue=FALSE


hope you can do anything with it

feel free to ask if you need something else.

Felix

[sa22]

Thanks fflux!
Db version now works fine, but I can't see Archivelog counter in zabbix:



What can be a problem?

[fflux]

best guess is, are you running in archivelog mode?

if no, then it won't show up because of the RaceCondition.
if yes, put the query in sqlplus, first as sysdba if that works, try it on the orabbix user.

if it's still working, try the RaceConditionQuery in sqlplus.

if everything seems ok to you, then be sure to run orabbix 1.2rc2.

otherwise i'm lost

Felix