Orabbix:"Another way to monitor Oracle reloaded"

[dalle]

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?

It's already implemented

http://www.smartmarmot.com/wiki/index.php/Orabbix

customQueryItemName.Period=<Express a period in minute>
let me know if you have issue with

[Yello]

Hi,
I have installed orabbix and am getting this error on startup:

Exception in thread "main" java.lang.ClassFormatError: com.smartmarmot.orabbix.bootstrap (unrecognized class file version)
at java.lang.VMClassLoader.defineClass(libgcj.so.7rh)
at java.lang.ClassLoader.defineClass(libgcj.so.7rh)
at java.security.SecureClassLoader.defineClass(libgcj .so.7rh)
at java.net.URLClassLoader.findClass(libgcj.so.7rh)
at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
at gnu.java.lang.MainThread.run(libgcj.so.7rh)

Please advise.


Regards,
David

[dalle]

Hi,
I have installed orabbix and am getting this error on startup:

Exception in thread "main" java.lang.ClassFormatError: com.smartmarmot.orabbix.bootstrap (unrecognized class file version)
at java.lang.VMClassLoader.defineClass(libgcj.so.7rh)
at java.lang.ClassLoader.defineClass(libgcj.so.7rh)
at java.security.SecureClassLoader.defineClass(libgcj .so.7rh)
at java.net.URLClassLoader.findClass(libgcj.so.7rh)
at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
at gnu.java.lang.MainThread.run(libgcj.so.7rh)

Please advise.


Regards,
David

which java version are you using?
could you try
java -version
and
javac -version

[dalle]

Hi,
I have installed orabbix and am getting this error on startup:

Exception in thread "main" java.lang.ClassFormatError: com.smartmarmot.orabbix.bootstrap (unrecognized class file version)
at java.lang.VMClassLoader.defineClass(libgcj.so.7rh)
at java.lang.ClassLoader.defineClass(libgcj.so.7rh)
at java.security.SecureClassLoader.defineClass(libgcj .so.7rh)
at java.net.URLClassLoader.findClass(libgcj.so.7rh)
at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
at java.lang.ClassLoader.loadClass(libgcj.so.7rh)
at gnu.java.lang.MainThread.run(libgcj.so.7rh)

Please advise.


Regards,
David

which java version are you using?
could you try
java -version
and
javac -version

[Yello]

which java version are you using?
could you try
java -version
and
javac -version

Ah yes, thanks for the prompt. There was a version mistmatch. After massaging the enironment settings things are now looking much better.


Regards,
David

[mhuggins1978]

customquery.Period

Ok so I've implemented but it doesn't seem to be honoring the window I define. Sometimes the custom queries execute on the same cycle as the default queries sometimes they execute less frequently but they never seem to execute on the window I've defined.


I've put my custom queries in a second file that I defined with the DBNAME.ExtraQueryListFile=relative path to file

Inside of that I've defined 3 queries so the structure of my custom query file is

QueryList=query1,query2,query3

query1.Period=15
query2.Period=15
query3.Period=10

query1.Query=sql statement
query2.Query=sql statement
query3.Query sqlstatement


My query list file is the default query.props file.
I did notice that the query.props file has a DefaultQueryPeriod=2 defined at the beginning of the file. Does the order of the fields matter should I move the .Period nodes in my custom file to before the QueryList node etc. Any help would appreciated.

[mhuggins1978]

Issues with &quot;alive'

I'm having some problems with orrabix in our production environment.
The alive check is intermittently returning 0 when I know the DB's are up and running. We are monitoring 7 DB's in an oracle 11g RAC environment. I'm using the sample query file as well as an Extra Query file with some custom queries to monitor the health of our customer applications. I'm running 50 threads with the following settings on each pool.
DBName.MaxActive=2
DBName.MaxWait=100
DBName.MaxIdlle=1


What exactly is alive checking for?

[dalle]

I'm sorry for delay.
Alive check if connection is available, for this reason if you shutdown the listener you are not going to see Alive trigger on fire.
Alive go on fire if the pool is not able to get a valid connection
Actually there isn't a "tnsping" like trigger

[harishgupta111]

Hi, I have one doubt. Please tell me Does Orabbix support CURSOR. I have one explict cursor. So I wann confirm if I use that explicit cursor in query.prop file then does it work. Actually the cursor currently I am having for that I have no database with me.. dat's why I am asking before starting.

[harishgupta111]

Hi this is the statement that I am using in query.prop file and

test_cursor.Query= declare \
cursor testcursor is \
select avgtime, tmptime from sachinsoa.testing_event_log where avgtime>100; \
testcursordata testcursor%rowtype; \
temp_avgtime NUMBER := 0; \
begin \
open testcursor; \
loop \
exit when testcursor%NOTFOUND; \
fetch testcursor into testcursordata; \
temp_avgtime := temp_avgtime + TO_NUMBER(testcursordata.avgtime); \
END LOOP; \
dbms_output.put_line(temp_avgtime); \
CLOSE testcursor; \
End;
test_cursor.NoDataFound=none


In Zabbix frontend
please see attached file:

Now when I am checking in Graph its showing no data and not supported.

Any idea???

[harishgupta111]

Sory i forget to attach

Hi, here is the item details ->

[harishgupta111]

Hi

Hi all,

I have no reply from anyone. Please someone from orabbix fell me the soution ofproblem.

[dalle]

Orabbix don't support cursors
just retrieve the output and send it to zabbix...
there is no way if you are using cursors

[harishgupta111]

Super urgent

HI dalle,

this time i made a function

create or replace function harish(tem in NUMBER) return number IS
temp_avgtime NUMBER;
cursor testcursor is
select avgtime, tmptime from sachinsoa.testing_event_log where avgtime>100;
testcursordata testcursor%rowtype;
temp_avgtime1 NUMBER:= 0;
begin
OPEN testcursor;
loop
exit when testcursor%NOTFOUND;
fetch testcursor into testcursordata;
temp_avgtime1 := temp_avgtime1 + TO_NUMBER(testcursordata.avgtime);
END LOOP;
dbms_output.put_line(temp_avgtime1);
CLOSE testcursor;
temp_avgtime:=0;
return temp_avgtime1;
End;
and when m checking this function
select sachinsoa.harish(7) from dual

Its giving me correct results in sql developer.

But when i used this in query.prop file
test_cursor.Query=select sachinsoa.harish(7) from dual
test_cursor.NoDataFound=none

nd the ITEM:
Type Zabbix trapper
Key test_cursor
Type of information Numeric(float)

Its giving NoT supported. I am not able to understand.

Please reply asap.

Thanks in advance

[dalle]

HI dalle,

this time i made a function

create or replace function harish(tem in NUMBER) return number IS
temp_avgtime NUMBER;
cursor testcursor is
select avgtime, tmptime from sachinsoa.testing_event_log where avgtime>100;
testcursordata testcursor%rowtype;
temp_avgtime1 NUMBER:= 0;
begin
OPEN testcursor;
loop
exit when testcursor%NOTFOUND;
fetch testcursor into testcursordata;
temp_avgtime1 := temp_avgtime1 + TO_NUMBER(testcursordata.avgtime);
END LOOP;
dbms_output.put_line(temp_avgtime1);
CLOSE testcursor;
temp_avgtime:=0;
return temp_avgtime1;
End;
and when m checking this function
select sachinsoa.harish(7) from dual

Its giving me correct results in sql developer.

But when i used this in query.prop file
test_cursor.Query=select sachinsoa.harish(7) from dual
test_cursor.NoDataFound=none

nd the ITEM:
Type Zabbix trapper
Key test_cursor
Type of information Numeric(float)

Its giving NoT supported. I am not able to understand.

Please reply asap.

Thanks in advance

ok place in debug orabbix and send to me the complete logfile or attach here in a message