Orabbix:"Another way to monitor Oracle reloaded"

[sistemas.aquanima]

All my monitoring problems solved using Zabora, damn I thought using Orabbix was the solution.

[euska]

I would like to get the free space in % .
Can anyone help me on this query ?

Thanks

[euska]

Got it using :

SELECT ROUND(SUM(bytes/1024/1024) / (SELECT SUM(bytes/1024/1024) FROM dba_data_files)*100,2) FROM dba_free_space GROUP BY 1;

[cincin]

Orabbix - nodata graph

Hello

We have an orabbix (1.2.3) on a zabbix (2.2.1).
From the orabbix logs everything seems to be ok:

2014-01-14 15:56:03,510 [pool-1-thread-39] DEBUG Orabbix - Actual query is sessionNextrun 2014/01/14 15:55:35 on database=XXXX Period=2
2014-01-14 15:56:03,511 [pool-1-thread-39] DEBUG Orabbix - I'm going to return 89 for query session on database=XXXX
2014-01-14 15:56:03,512 [pool-1-thread-39] DEBUG Orabbix - Actual query is session_systemNextrun 2014/01/14 15:55:35 on database=XXXX Period=2
2014-01-14 15:56:03,513 [pool-1-thread-39] DEBUG Orabbix - I'm going to return 21 for query session_system on database=XXXX
2014-01-14 15:56:03,513 [pool-1-thread-39] DEBUG Orabbix - Actual query is sga_buffer_cacheNextrun 2014/01/14 15:55:35 on database=XXXX Period=2
2014-01-14 15:56:03,518 [pool-1-thread-39] DEBUG Orabbix - I'm going to return 1024 for query sga_buffer_cache on database=XXXX
2014-01-14 15:56:03,518 [pool-1-thread-39] DEBUG Orabbix - Actual query is sga_fixedNextrun 2014/01/14 15:55:35 on database=XXXX Period=2
2014-01-14 15:56:03,523 [pool-1-thread-39] DEBUG Orabbix - I'm going to return 2.12 for query sga_fixed on database=XXXX

But we don't have data on "Latest data".

Also on orabbix logs we have:

2014-01-14 15:56:04,195 [pool-1-thread-39] DEBUG Orabbix - sending <req><host>anVsaWFkYg==</host><key>cG9vbF9kaWN0X2NhY2hl</key><data>MA==</data></req>
2014-01-14 15:56:04,196 [pool-1-thread-39] DEBUG Orabbix - sending <req><host>anVsaWFkYg==</host><key>c3FsUmVzcG9uc2U=</key><data>MS41NA==</data></req>
2014-01-14 15:56:04,196 [pool-1-thread-39] DEBUG Orabbix - sending <req><host>anVsaWFkYg==</host><key>cG9vbF9mcmVlX21lbQ==</key><data>MjI0LjI3</data></req>
2014-01-14 15:56:04,196 [pool-1-thread-39] DEBUG Orabbix - sending <req><host>anVsaWFkYg==</host><key>cG9vbF9saWJfY2FjaGU=</key><data>MA==</data></req>

Thank you

[dalle]

Hello

We have an orabbix (1.2.3) on a zabbix (2.2.1).
From the orabbix logs everything seems to be ok:

2014-01-14 15:56:03,510 [pool-1-thread-39] DEBUG Orabbix - Actual query is sessionNextrun 2014/01/14 15:55:35 on database=XXXX Period=2
2014-01-14 15:56:03,511 [pool-1-thread-39] DEBUG Orabbix - I'm going to return 89 for query session on database=XXXX
2014-01-14 15:56:03,512 [pool-1-thread-39] DEBUG Orabbix - Actual query is session_systemNextrun 2014/01/14 15:55:35 on database=XXXX Period=2
2014-01-14 15:56:03,513 [pool-1-thread-39] DEBUG Orabbix - I'm going to return 21 for query session_system on database=XXXX
2014-01-14 15:56:03,513 [pool-1-thread-39] DEBUG Orabbix - Actual query is sga_buffer_cacheNextrun 2014/01/14 15:55:35 on database=XXXX Period=2
2014-01-14 15:56:03,518 [pool-1-thread-39] DEBUG Orabbix - I'm going to return 1024 for query sga_buffer_cache on database=XXXX
2014-01-14 15:56:03,518 [pool-1-thread-39] DEBUG Orabbix - Actual query is sga_fixedNextrun 2014/01/14 15:55:35 on database=XXXX Period=2
2014-01-14 15:56:03,523 [pool-1-thread-39] DEBUG Orabbix - I'm going to return 2.12 for query sga_fixed on database=XXXX

But we don't have data on "Latest data".

Also on orabbix logs we have:

2014-01-14 15:56:04,195 [pool-1-thread-39] DEBUG Orabbix - sending <req><host>anVsaWFkYg==</host><key>cG9vbF9kaWN0X2NhY2hl</key><data>MA==</data></req>
2014-01-14 15:56:04,196 [pool-1-thread-39] DEBUG Orabbix - sending <req><host>anVsaWFkYg==</host><key>c3FsUmVzcG9uc2U=</key><data>MS41NA==</data></req>
2014-01-14 15:56:04,196 [pool-1-thread-39] DEBUG Orabbix - sending <req><host>anVsaWFkYg==</host><key>cG9vbF9mcmVlX21lbQ==</key><data>MjI0LjI3</data></req>
2014-01-14 15:56:04,196 [pool-1-thread-39] DEBUG Orabbix - sending <req><host>anVsaWFkYg==</host><key>cG9vbF9saWJfY2FjaGU=</key><data>MA==</data></req>

Thank you

This mean that Orabbix is sending data to zabbix, are you sure you have the same host name you defined for orabbix in Zabbix too?

[dalle]

Win Free Ecopy of new book on Zabbix!

Readers would be pleased to know that I have teamed up with Packt Publishing to organize a Giveaway of the Mastering Zabbix

And three lucky winners stand a chance to win ecopy of their new book. Keep reading to find out how you can be one of the Lucky Winners.
More information are available here

[GemTTb]

Hello Dalle and team and thank you very much for this solution.

It took me several days to have orabbix working but I'm still having trouble with it and couldn't resolve it so far.

Let me sum up the the environment and all my action

Env: Zabbix appliance on suse provided by zabbix site having jre6u45, Oracle 10g installed on Win XP with hostname MACHINE_ORACLE

Actions:
1) Downloaded and installed orabbix on my zabbix server machine.
2) Configured orabbix using config.props as below

ZabbixServerList=ZabbixServer1

ZabbixServer1.Address=10.10.1.230
ZabbixServer1.Port=10051

OrabbixDaemon.PidFile=./logs/orabbix.pid
OrabbixDaemon.Sleep=300
OrabbixDaemon.MaxThreadNumber=100

DatabaseList=DB1
DatabaseList.MaxActive=10
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1

DB1.Url=jdbcracle:thin:@10.10.1.6:1521:pcep
DB1.User=test
DB1.Password=test

DB1.MaxActive=10
DB1.MaxWait=100
DB1.MaxIdle=1
DB1.QueryListFile=./conf/query.props

3) imported the template Template_Oracle provided by orabbix distribution.
4) Created a host on zabbix named pcep and add to this host the Template_Oracle just added.
5) Started the Zabbix_agent on the MACHINE_ORACLE successfully and getting some data like Memory_utilization data.
6) started the orabbix daemon successfully.
7) Changed the log level on the orabbix and getting :
2014-02-18 11:08:57,559 [main] DEBUG Orabbix - Waking up Goood Morning
2014-02-18 11:08:57,560 [main] DEBUG Orabbix - Loaded the properties from ./conf/query.props
2014-02-18 11:08:57,561 [main] DEBUG Orabbix - Note: archive.NoDataFound null or not present null
2014-02-18 11:08:57,562 [main] DEBUG Orabbix - Note: archive.WhenNotAlive null or not present null
2014-02-18 11:08:57,562 [main] DEBUG Orabbix - Note: archive.Period null or not present null
2014-02-18 11:08:57,562 [main] DEBUG Orabbix - Note: archive.ExcludeColumnsList error null
.
.
.


8) On the zabbix GUI I couldn't get any data on the graphs.

Was something missing or wrong during configuration? I'm struggling with this, so please help.

Thanks

[sybex]

Hi, ...

orabbix has to know the servername from the server in zabbix, in your example config the servername would be "DB1"

Change this value to match the data to your host.

e.g. Server in Zabbix: testserver01

testserver01.Url=jdbcracle:thin:@10.10.1.6:1521cep
testserver01.User=test
testserver01.Password=test

A lot of the orabbix config is optional. Check the Docs.

[GemTTb]

Thank you Sybex for your quick reply.

That was it, I had to use the "DB1" as the hostname on zabbix server host name and I finally started to get data.

That's somehow wierd, because on the Orabbix documentation page, the name has to be the SID.

ensure the name of your host in Zabbix is the same name of the SID or Oracle instance name.

Anyways it's working, so it's fine by now.

Thank you very much :-)

[cincin]

Hello Dale

Thaks for your response.
That was the problem, the host name wasn´t the same with the name of DB in orabbix.
Now is working fine.

I have one more question: how can we set the check period of the query.props file?

Thank you

[s4chin]

No data on zabbix server

Hi Frnds,

I have zabbix server on 192.168.0.162 (CentOS 6.5). Zabbix version is 2.2.1.
My Oracle server (10.2.0.5) is on 192.168.0.244. So i installed orabbix 1.2.3 on oracle server in /opt directory and i think it is working ok. I imported oracle template "Orabbix_export_full.xml" from orabbix template folder in zabbix server and added host also...but there is no data on zabbix server related to oracle template

My files config are :
1 ) config.props

ZabbixServerList=ZabbixServer1
ZabbixServer1.Address=192.168.0.162
ZabbixServer1.Port=10051
OrabbixDaemon.PidFile=./logs/orabbix.pid
OrabbixDaemon.Sleep=300
OrabbixDaemon.MaxThreadNumber=2
DatabaseList=DB1
DatabaseList.MaxActive=10
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1

DB1.Url=jdbcracle:thin:@192.168.0.244:1521rcltest10g
DB1.User=zabbix
DB1.Password=zabbix

DB1.MaxActive=10
DB1.MaxWait=100
DB1.MaxIdle=1
DB1.QueryListFile=./conf/query.props


2) orabbix.log

2014-03-08 10:23:57,935 [main] INFO Orabbix - Starting Orabbix Version 1.2.3
2014-03-08 10:23:57,989 [main] INFO Orabbix - Orabbix started with pid:5099
2014-03-08 10:23:57,989 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2014-03-08 10:23:58,434 [main] INFO Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@7a3f437c
2014-03-08 10:23:58,434 [main] INFO Orabbix - URL=jdbcracle:thin:@192.168.0.244:1521rcltest10g
2014-03-08 10:23:58,434 [main] INFO Orabbix - maxPoolSize=10
2014-03-08 10:23:58,435 [main] INFO Orabbix - maxIdleSize=1
2014-03-08 10:23:58,435 [main] INFO Orabbix - maxIdleTime=1800000ms
2014-03-08 10:23:58,435 [main] INFO Orabbix - poolTimeout=100
2014-03-08 10:23:58,435 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
2014-03-08 10:23:58,435 [main] INFO Orabbix - numTestsPerEvictionRun=3
2014-03-08 10:24:02,369 [main] INFO Orabbix - Connected as ZABBIX
2014-03-08 10:24:02,376 [main] INFO Orabbix - --------- on Database -> orcltest
2014-03-08 10:24:04,576 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database DB1 QueryList elapsed time 1988 ms
2014-03-08 10:25:02,665 [pool-1-thread-2] INFO Orabbix - Done with dbJob on database DB1 QueryList elapsed time 31 ms

Why there is no data on zabbix server

[Vapochilled]

Hi, is DB1 the hostname of that hostname in zabbix server?
It needs to be the same

[s4chin]

no its not
DB1 is name of the variable

DatabaseList=DB1

ok let me put Hostname instead of DB1

[tirorex]

Hello. Is it possible to send a parameter to query.

For example

tablespace_space_used.Query[{#TS_NAME}]="select sum() from ... where tablespace name='$1'"

[Alexander Podkopaev]

ExtraQueryListFile is not clear for me

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

Using this feature is not clear for me:
1. if I put QueryList parameter in 'extra' file - will it override QueryList from 'base' props or will merge them?
2. Is it possible to have more than one ExtraQueryListFile?

My usecase for ExtraQueryListFile is separating scripts to two or more scripts with different modification rights:
1. base monitoring scripts - writeable by senior DBA only
2. instance or solution -depended scripts - writeable by principal DBAs