Orabbix:"Another way to monitor Oracle reloaded"

[ferri]

root@zabbix:/usr/lib# aptitude install sun-java6-jre
No candidate version found for sun-java6-jre s
No candidate version found for sun-java6-jre
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B of archives. After unpacking 0B will be used.

[ferri]

No one can help me?
Please

[dalle]

No one can help me?
Please

Download java jre 6 from Java website.

http://javadl.sun.com/webapps/download/AutoDL?BundleId=49015

or

http://javadl.sun.com/webapps/download/AutoDL?BundleId=49019

anyway the official homepage is this one:
http://java.com/en/download/manual.jsp

[ferri]

I installed java as you said but I still have the same problem.

[dalle]

I installed java as you said but I still have the same problem.

Ops sorry I didn't understand
try to see if you have java in your path and if not put them on you path.
about your issue "Can't open /etc/rc.d/init.d/functions" try to remove the line inside the script and let me know

[ferri]

Here is my path value:
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games


And I remove the line concerning "/etc/rc.d/init.d/functions and now I have an other error message:
.: 13: Can't open /etc/sysconfig/network

This directory is for RedHat, isn't it?

[dalle]

yes everything has been develop and tested on redhat (as documented) other distribution are not tested at all mostly because I have only RedHat (commercial) where i work

[ferri]

OK, I understand now.
Thank you, maybe I'll install Zabbix on a Redhat machine.

[dalle]

OK, I understand now.
Thank you, maybe I'll install Zabbix on a Redhat machine.

let me know if you need other info, on redhat is working right.

[eyup]

Orabbix alive check

Hi,

I am just starting out with orabbix and zabbix. So far it's looking great! I had a question similar to that of sa22. I am testing running orabbix-1.2.0-RC3.jar against several oracle databases.

Today I shut down a test database (9i running on Windows) and get the following error in the orabbix log:

2011-08-17 12:32:46,034 [pool-1-thread-12] ERROR Orabbix - Error on dbJob for database TSTDB QueryList error: org.apache.commons.dbcp.SQLNestedException: Could not retrieve connection info from pool

However, the alive trigger has not fired and is green for that database.

I am only using one query file and one config file for all databases. My trigger is: {Template_Oracle:alive.last(0)}#1 and the item is: Alive {HOSTNAME}

The latest data for that database is hours ago. Is there something I have missed in the configuration?

[Keitamax]

hit ratio?

Hi,
could you explain me what the different HIT RATIO stand for?
I guess it's the hit ratio for Oracle SGA's buffer, but what are the different hit ratios Orabbix gives? (Table/procedure, sql area, body, trigger)

[dalle]

there are different kind of statistics.
hitratio is made with the following query
select ( sum(decode(name,'consistent gets', value,0)) + sum(decode(name,'db block gets', value,0)) - sum(decode(name,'physical reads', value,0))) (sum(decode(name,'consistent gets', value,0)) + sum(decode(name,'db block gets', value,0)) ) * 100 "hit_ratio" FROM v$sysstat

and it's about system statistics.

the others are made enquiring library cache

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1143.htm

[dalle]

Orabbix 1.2.2 has been released!!

On this release:
Added the following parameter on main configuration file:
DefaultUser = <USERNAME>
DefaultPassword = <PASSWORD>
<DB_NAME>.ExtraQueryListFile = <relative path to extra query file> on query’s properties file I’ve added the following parameter:
<QUERY_NAME>.WhenNotAlive = <VALUE>

You can download it here
ore on sourceforge as usual



Complete changelog here:

1.2.2
Added the following parameter on main configuration file:
DefaultUser = <USERNAME>
DefaultPassword = <PASSWORD>
<DB_NAME>.ExtraQueryListFile =

on query’s properties file I’ve added the following parameter:
<QUERY_NAME>.WhenNotAlive = <VALUE>

with these parameter you can define a default username and password for
all the database.
DefaultUser = <USERNAME>
DefaultPassword = <PASSWORD>
this default parameter can be overridden using the couple
<DB_NAME>.User and <DB_NAME>.User
Is possible to override only Username or Password.

the following parameter
<DB_NAME>.ExtraQueryListFile =
add another custom query to a default query file.
if there are duplicate the ExtraQueryListFile will override them.

the following parameter
<QUERY_NAME>.WhenNotAlive = <VALUE>
is used to specify a value or a string to send if a database is not working,
doing so you are going to “clean” the graphs generated in Zabbix with a “set” value.
This fix the issue introduced by “Zabbix Trapper”:
- if Zabbix don’t receive data the graphs don’t change anymore.

[dalle]

Orabbix 1.2.3 ha been released!


Orabbix 1.2.3 has been released!!

On this release:

Fixed the issue with Alive
Deeply improved the dynamic recognition of new databases

Now you can add and remove databases simply writing them on configuration file.

I've improved the scalability.

You can download it here
or on sourceforge as usual



Complete changelog here:

1.2.3

[mhuggins1978]

Query intervals

Would it be possible to be able to run different queries at different intervals.

Currently we have some custom scripts that we use to execute queries against an oracle db. These queries allow us to better monitor the health of our customer facing application. Some of the queries run every 5 minutes others run ever couple of hours and some run once a day. I would love to move these queries into orabbix but from what I've found so far all the queries on a database run on the same schedule. Am I missing a config setting or would this be something that easy to implement?