Orabbix:"Another way to monitor Oracle reloaded"

[dalle]

Solved!

I've solved this problem was made by the upgrade there was an error on exported graphs.
I'm going to explain:
I've upgraded our system from 1.6 to 1.8 and after this upgrade most of this graphs has an error on Ymax and Ymin and the scale was "Item" and no more "Calculated". the strange thing is that my graphs work pretty well but all export/import was on error.
I've release a new version of Orabbix 1.0.0 here on template items graphs and trigger are divided on 3 files and I've made some minor change on logging class.

[yoda]

Now it works! Thanks.

[yoda]

I'm noting some problem with pid file creation (Orabbix installed on oracle server CentOS release 5.2, java-1.6.0-openjdk-1.6.0.0-1.11.b16.el5); here are the error rows from orabbix log:

2010-08-09 16:14:56,318 [main] ERROR Orabbix - Error on Configurator getPidFile java.lang.NullPointerException
2010-08-09 16:14:56,320 [main] ERROR Orabbix - Error while trying to write pidfile java.lang.NullPointerException

So I temporarily changed the init script:

# diff /opt/orabbix/init.d/orabbix /etc/init.d/
34c34
< kill `cat $orabbix/logs/orabbix.pid`
---
> kill $pid
75c75

[dalle]

right it's not blocking
to solve this issue add this line on Config.props

#pidFile
OrabbixDaemon.PidFile=./logs/orabbix.pid

I've changed my package

Pidfile is wonderful if you want multiple instances of Orabbix on same server, doing so you can specify different sleep parameters and have one Orabbix instances for your Production database one for developement DB etc... and each installation with different sheduling of Orabbix.

[yoda]

Ok, it's ok now, thx.

Just a silly question...
I've installed and configured Orabbix on /opt/orabbix of my Oracle server, whereas nothing done on Zabbix server apart host creation and templates import. Is it right?
If so, could you please specify this thing on the installation instructions that are not so precise for a dummy user like me?

Again thanks.

[dalle]

Ok, it's ok now, thx.

Just a silly question...
I've installed and configured Orabbix on /opt/orabbix of my Oracle server, whereas nothing done on Zabbix server apart host creation and templates import. Is it right?
If so, could you please specify this thing on the installation instructions that are not so precise for a dummy user like me?

Again thanks.

right you need to create an host with the same name of your instace e.g.
create an host ORCL (with the ip that you want it's useless ip here)
apply to ORCL host (on zabbix) the Template_Oracle

create a zabbix user on ORCL and configure credentials on Orabbic properties file
and now you just need run Orabbix and nothig more.
Yep the install instruction probably (or better of course) need a revision

[rickymarino]

2 Instances with the same

How do I monitor 2 Instances in different databases which have the same name?

Orabbix is great! Keep up the good work.

[dalle]

Thank you guys!
nope it's not possible i didn't think about before because for Orabbix SID should be a unique SID.

[rickymarino]

Thank you guys!
nope it's not possible i didn't think about before because for Orabbix SID should be a unique SID.

Do you plan to add that future?

Thanks

[dalle]

why you simply don't do so:
e.g you have a database that is named ORCL on server1 and another ORCL on
server2
you can just create (inside zabbix) one host that is called ORCL1 and
another one that is called ORCL2 after you can modify properties file to
point ORCL1 and ORCL2 with the same SID but on different hosts.
This way should work.
I've used a correspondency between host(on zabbix) and sid but you
can change hostname on zabbix and call him "John" also if your database
has "Thomas" as sid.
Those are just label you can use as you want.

[rickymarino]

It Worked!

I recommend you to add that to the documentation.

Thanks a lot!

[dalle]

Orabbix 1.0.1 relased

On this release i've added:

• One item that monitor Uptime of a database
• One trigger that send an error if uptime is less than one hour
• Modified a query that retrieve data about tablespaces usage now work correctly also with autoextend and maxsize unlimited specified
• Modified DBEnquiry to log more infos about error on retrieved query and to log all Oracle error.

You can download the new release here or on sourceforge as usual.
Thank to Thiago for those hints.

[yoda]

Updated to 1.0.1.

Now I'm getting the following errors on orabbix.log (no changes on configuration):

2010-08-12 12:29:36,072 [main] INFO Orabbix - PidFile -> /opt/orabbix/logs/orabbix.pid
2010-08-12 12:29:36,537 [main] INFO Orabbix - Connected as SYSTEM
2010-08-12 12:29:36,539 [main] INFO Orabbix - --------- on Database -> orarec
2010-08-12 12:29:36,620 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query =audit Error returned is java.sql.SQLException: Connection oracle.jdbc.driver.T4CConnection@6ca084f8 is closed.
2010-08-12 12:29:36,620 [pool-1-thread-1] WARN Orabbix - I'm going to return none for query audit
2010-08-12 12:29:36,620 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query =dbblockgets Error returned is java.sql.SQLException: Connection oracle.jdbc.driver.T4CConnection@6ca084f8 is closed.
2010-08-12 12:29:36,620 [pool-1-thread-1] WARN Orabbix - I'm going to return for query dbblockgets
2010-08-12 12:29:36,620 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query =dbconsistentgets Error returned is java.sql.SQLException: Connection oracle.jdbc.driver.T4CConnection@6ca084f8 is closed.
[...]

What is wrong?

[dalle]

Please download the 1.0.2 version from my website and let me know
thank you in advance (there also a new features on 1.0.2 i send Orabbix Version so you can easily know which version is running )

[yoda]

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