Orabbix:"Another way to monitor Oracle reloaded"

[mxa]

Problem with AIX 5.3

On project page, there is mentioned, that orabbix was tested with AIX 5.3, I try with 1.2.0 rc3
when I run run.sh I get wrong java version.

# ./run.sh
# The java class could not be loaded. java.lang.UnsupportedClassVersionError: com/smartmarmot/orabbix/bootstrap (Unsupported major.minor version 50.0)

Our java version:
# java -version
java version "1.4.2"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2)
Classic VM (build 1.4.2, J2RE 1.4.2 IBM AIX build ca142-20090307 (SR13) (JIT enabled: jitc))
I am aware that it should be 1.6 not 1.4, but as far as I know 1.4.2 is already a newest java version that is available..

So I will probably need some jar created in 1.4 not in 1.6.. Do someone have some experience? I don't want to be force try older versions.. at this point I don't know what else can I do..

I won't be able install sun java, at this point I'm working on test environment, but on production there will no possibility to change any existing part of IT environment.. so..

BTW: I tried to (multiple times) send info in contact us in http://www.smartmarmot.com/about/#FSContact1 but every time there is an error with CAPTCHA Code -this is also my try to inform author that there is a problem..


Could not read CAPTCHA token file. Try again.

PS: Orabbix tested on OEL -works great..

So i will propably need some jar created in 1.4 not in 1.6.. Do someone have some experience? I don't wath to be force to try older versions..

[dalle]

On project page, there is mentioned, that orabbix was tested with AIX 5.3, I try with 1.2.0 rc3
when I run run.sh I get wrong java version.

# ./run.sh
# The java class could not be loaded. java.lang.UnsupportedClassVersionError: com/smartmarmot/orabbix/bootstrap (Unsupported major.minor version 50.0)

Our java version:
# java -version
java version "1.4.2"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2)
Classic VM (build 1.4.2, J2RE 1.4.2 IBM AIX build ca142-20090307 (SR13) (JIT enabled: jitc))
I am aware that it should be 1.6 not 1.4, but as far as I know 1.4.2 is already a newest java version that is available..

So I will probably need some jar created in 1.4 not in 1.6.. Do someone have some experience? I don't want to be force try older versions.. at this point I don't know what else can I do..

I won't be able install sun java, at this point I'm working on test environment, but on production there will no possibility to change any existing part of IT environment.. so..

BTW: I tried to (multiple times) send info in contact us in http://www.smartmarmot.com/about/#FSContact1 but every time there is an error with CAPTCHA Code -this is also my try to inform author that there is a problem..


Could not read CAPTCHA token file. Try again.

PS: Orabbix tested on OEL -works great..

So i will propably need some jar created in 1.4 not in 1.6.. Do someone have some experience? I don't wath to be force to try older versions..

I'm sorry for your issue with CAPTCHA I'm going to check if is readabale thank you to notice it to me!

mmm
If you can't install java sun 1.6 it's not so easy....
I can try to compile it with the old one (1.4) but I'm not sure that is possible let me try.

[mxa]

mmm
If you can't install java sun 1.6 it's not so easy....
I can try to compile it with the old one (1.4) but I'm not sure that is possible let me try.

I would be very very thankful, really..
If it works, I may be able to help you in conversion from Linux version of script to AIX when I'm done If you interested (it's silly thing like for loop with echo -n that does not exist in AIX so run.sh fails.. that kind of stuff)
Maybe some of your users will be interested in AIX version

[kawakamikun]

Zabbix Agent

Hello,

iam new here and i try to configure the orabbix.
1 question- i need to install zabbix agent on host that contain the oracle?
how to create the host on zabbix? with the oracle address or zabbix address?

[fflux]

You need to install orabbix on the zabbix server.

you need to create a host to define the database in zabbix, we use hostname-dbname (but you can do what you want)

and the dns-name would be the name of the server the oracle database runs on.

and assign the orabbix template to it.

the first part in config.props is the name you give the database in zabbix.

[kawakamikun]

You need to install orabbix on the zabbix server.

you need to create a host to define the database in zabbix, we use hostname-dbname (but you can do what you want)

and the dns-name would be the name of the server the oracle database runs on.

and assign the orabbix template to it.

the first part in config.props is the name you give the database in zabbix.

I configure how u explain, the triggers is OK, but the graphs dont work.
The logs inform that the connection with database is succefull.
My Oracle Server is hosted in outside datacenter.

[mxa]

Problem with AIX 5.3 -CD

I was wrong to IBM java 1.4.2
I found on that Java 6 =1.6.
now while ececuting run.sh (upgraded -original run.sh is for Linux, not AIX)

/usr/java6_64/bin/java -Duser.language=en -Duser.country=US -Dlog4j.configuration=/opt/orabbix/conf/log4j.properties -cp /opt/orabbix/lib/commons-codec-1.4.jar:/opt/orabbix/lib/commons-dbcp-1.4.jar:/opt/orabbix/lib/commons-lang-2.5.jar:/opt/orabbix/lib/commons-logging-1.1.1.jar:/opt/orabbix/lib/commons-pool-1.5.4.jar:./orabbix-1.2.0-RC3.jar com.smartmarmot.orabbix.bootstrap start /opt/orabbix/conf/config.props &

I get:
# Exception in thread "main" java.lang.NoClassDefFoundError: org.apache.log4j.Level
at com.smartmarmot.orabbix.Orabbixmon.<init>(Orabbixm on.java:46)
at com.smartmarmot.orabbix.bootstrap.main(bootstrap.j ava:52)
Caused by: java.lang.ClassNotFoundException: org.apache.log4j.Level
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:434)
at java.lang.ClassLoader.loadClass(ClassLoader.java:6 60)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:358)
at java.lang.ClassLoader.loadClass(ClassLoader.java:6 26)
... 2 more

There is no log created

if I try:
/usr/java6_64/bin/java -Duser.language=en -Duser.country=US -Dlog4j.configuration=./conf/log4j.properties -cp /opt/orabbix/lib/commons-codec-1.4.jar:/opt/orabbix/lib/commons-dbcp-1.4.jar:/opt/orabbix/lib/commons-lang-2.5.jar:/opt/orabbix/lib/commons-logging-1.1.1.jar:/opt/orabbix/lib/commons-pool-1.5.4.jar:./orabbix-1.2.0-RC3.jar com.smartmarmot.orabbix.bootstrap start ./conf/config.props &
# pwd
/opt/orabbix
# ix-1.2.0-RC3.jar com.smartmarmot.orabbix.bootstrap start ./conf/config.props & <
[1] 262292
# Exception in thread "main" java.lang.NoClassDefFoundError: org.apache.log4j.Level
at com.smartmarmot.orabbix.Orabbixmon.<init>(Orabbixm on.java:46)
at com.smartmarmot.orabbix.bootstrap.main(bootstrap.j ava:52)
Caused by: java.lang.ClassNotFoundException: org.apache.log4j.Level
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:434)
at java.lang.ClassLoader.loadClass(ClassLoader.java:6 60)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:358)
at java.lang.ClassLoader.loadClass(ClassLoader.java:6 26)
... 2 more
The is pid file created.. but still that all..

[mxa]

Problem with AIX 5.3 -CD

ok, I did try copy line from ps wfom my test OEL where I have working orabbix (whats funny on OEL it took me 1h, on AIX like 10h.. and it's still not working)

Now I got:
# /usr/java6_64/bin/java -Duser.language=en -Duser.country=US -Dlog4j.configuration=./conf/log4j.properties -cp lib/commons-codec-1.4.jar:lib/commons-dbcp-1.4.jar:lib/commons-lang-2.5.jar:lib/commons-logging-1.1.1.jar:lib/commons-pool-1.5.4.jar:lib/log4j-1.2.15.jar:lib/ojdbc6.jar:.:./orabbix-1.2.0-RC3.jar com.smartmarmot.orabbix.bootstrap start ./conf/config.props

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)

So it look much better
At this momnet its really nothing listening on 1521, my SID is ok.. I will have to check with someone from Orcale team, but I'm much more optimistic..

[Keitamax]

Hi,
thank you for your work! I managed to monitor an Oracle server, works great, except for some parameters : i get no data for DBSize, DBFilesSize and the numerous eventwaits stats.
In Orabbix.log:
2011-07-21 08:50:19,719 [pool-1-thread-16] WARN Orabbix - Error while executing ->dbversion- on database ->My_DB- Exception received ORA-02003: invalid USERENV parameter
2011-07-21 08:50:19,719 [pool-1-thread-16] ERROR Orabbix - Error on DBEnquiry on query=dbversion on database=My_DB Error returned is java.lang.IllegalArgumentException: null value for key 'dbversion'

Would you have a clue what's going wrong?

[dalle]

ok, I did try copy line from ps wfom my test OEL where I have working orabbix (whats funny on OEL it took me 1h, on AIX like 10h.. and it's still not working)

Now I got:
# /usr/java6_64/bin/java -Duser.language=en -Duser.country=US -Dlog4j.configuration=./conf/log4j.properties -cp lib/commons-codec-1.4.jar:lib/commons-dbcp-1.4.jar:lib/commons-lang-2.5.jar:lib/commons-logging-1.1.1.jar:lib/commons-pool-1.5.4.jar:lib/log4j-1.2.15.jar:lib/ojdbc6.jar:.:./orabbix-1.2.0-RC3.jar com.smartmarmot.orabbix.bootstrap start ./conf/config.props

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)

So it look much better
At this momnet its really nothing listening on 1521, my SID is ok.. I will have to check with someone from Orcale team, but I'm much more optimistic..

To solve this issue you need your Oracle Up and running at least one server... otherwise Orabbix can't create his own internal structure.
let me know when you have one Oracle server running

[dalle]

Hi,
thank you for your work! I managed to monitor an Oracle server, works great, except for some parameters : i get no data for DBSize, DBFilesSize and the numerous eventwaits stats.
In Orabbix.log:
2011-07-21 08:50:19,719 [pool-1-thread-16] WARN Orabbix - Error while executing ->dbversion- on database ->My_DB- Exception received ORA-02003: invalid USERENV parameter
2011-07-21 08:50:19,719 [pool-1-thread-16] ERROR Orabbix - Error on DBEnquiry on query=dbversion on database=My_DB Error returned is java.lang.IllegalArgumentException: null value for key 'dbversion'

Would you have a clue what's going wrong?

what version of oracle are you using?
I will try to reproduce your issue this one seem a trouble made by jdbc session.

[Keitamax]

Here it is :
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production

[mxa]

Aix 5.3 ok

To solve this issue you need your Oracle Up and running at least one server... otherwise Orabbix can't create his own internal structure.
let me know when you have one Oracle server running

It wasn't any problem from this point.
Oracle instance was running, but, as I said, 1521 wasnt listening, (It was test enviroment.. and listener was stopped)
lsnrctl start
and problem solved
Thank you for produkct and support Adrea

[dalle]

It wasn't any problem from this point.
Oracle instance was running, but, as I said, 1521 wasnt listening, (It was test enviroment.. and listener was stopped)
lsnrctl start
and problem solved
Thank you for produkct and support Adrea

opppsss sorry I didn't read right ...

[dalle]

Here it is :
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production

mmm right... on 9i don't work this kind of query...
I don't have any more Oracle 9i here to make some test but i think that you can change your query so:

dbversion.Query=select * from v$version where banner like 'Oracle%'
dbversion.Period=720

I know that is "restrictive" but this should work right