Orabbix:"Another way to monitor Oracle reloaded"

[sybex]

Hi, ...

the hostname doesn't matter for orabbix it just needs the connection to right database in the jdbc connector.

The link between Orabbix and Zabbix is created by the name your are using in Zabbix e.g. sc022hd01.

For example you have two servers as a cluster with one active instance on one of them.

sc020hd01 - Cluster
sc022hd01 - Node A
sc022hd02 - Node B

To point on the active instance you should use the vip (virtual ip adress) or a dns name which is pointing to it.

In Zabbix you should have 3 Servers, the 2 phyical ones and the logical one.
To send the orabbix data to the logical server in zabbix you have to choose the zabbix name in the orabbix configuration. E.g. sc020hd01
Zabbix: sc020hd01
orabbix:
DatabaseList=sc020hd01
sc020hd01.Url=jdbcracle:thin:@sc020hd01:<port>:<sid>

Orabbix will send the data direct to zabbix in the configurated server with the name "sc020hd01". There is no link between hostnames or ip's.

[PieterB]

Hi, ...

the hostname doesn't matter for orabbix it just needs the connection to right database in the jdbc connector.

<cut>

Thx Sybex, orabbix is working as expected now.

[lioxa_zab]

Problem working with 2 oracle instances.

I have problem with Orabix.
I have 2 Instances on the same box. My config is.

#comma separed list of Zabbix servers
ZabbixServerList=zabbix

ZabbixServer.Address=x.x.x.x
ZabbixServer.Port=10051

#pidFile
OrabbixDaemon.PidFile=./logs/orabbix.pid
#frequency of item's refresh
OrabbixDaemon.Sleep=300
#MaxThreadNumber should be >= than the number of your databases
OrabbixDaemon.MaxThreadNumber=100

#put here your databases in a comma separated list
DatabaseList=52DEV,52SUP

#Configuration of Connection pool
#if not specified Orabbis is going to use default values (hardcoded)
#Maximum number of active connection inside pool
DatabaseList.MaxActive=10
#The maximum number of milliseconds that the pool will wait
#(when there are no available connections) for a connection to be returned
#before throwing an exception, or <= 0 to wait indefinitely.
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1

#define here your connection string for each database
52SUP.Url=jdbcracle:thin:@xxx:1521:SUP
52SUP.User=zabbix
52SUP.Password=xxx
#Those values are optionals if not specified Orabbis is going to use the general values
52SUP.MaxActive=10
52SUP.MaxWait=100
52SUP.MaxIdle=1

52DEV.Url=jdbcracle:thin:@x.x.x.x:1522EV
52DEV.User=zabbix
52DEV.Password=xxx
#Those values are optionals if not specified Orabbis is going to use the general values
52DEV.MaxActive=10
52DEV.MaxWait=100
52DEV.MaxIdle=1

in orabix log i can see that all date is gotten from instances and passed to zabbix server.

Zabbix log look like this.

28527:20100922:154434.650 Item [52DEV:archive] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.652 Item [52DEV:hitratio_body] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.653 Item [52DEV:hitratio_sqlarea] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.654 Item [52DEV:hitratio_table_proc] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.656 Item [52DEVga_aggregate_target] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.657 Item [52DEVga] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.658 Item [52DEVinhitratio_body] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.659 Item [52DEVinhitratio_sqlarea] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.660 Item [52DEVinhitratio_table-proc] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.661 Item [52DEVinhitratio_trigger] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.662 Item [52DEVool_dict_cache] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.662 Item [52DEVool_free_mem] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.663 Item [52DEVool_lib_cache] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.664 Item [52DEVool_misc] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.665 Item [52DEVool_sql_area] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.668 Item [52DEV:sga_buffer_cache] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.669 Item [52DEV:sga_fixed] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.670 Item [52DEV:sga_java_pool] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.671 Item [52DEV:sga_large_pool] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.672 Item [52DEV:sga_log_buffer] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.673 Item [52DEV:sga_shared_pool] error: Type of received value [] is not suitable for value type [Numeric (float)]
28527:20100922:154434.675 Item [52DEV:hitratio_trigger] error: Type of received value [] is not suitable for value type [Numeric (f

52SUP working properly, some of 52DEV data also good. If i'm configuring instances separately everything is working good. How to get working them together ?

[dantony79]

wrong config file

change 52SUP.Url=~~~~~~~~~~~~~~~~~~:SUP to

52SUP.Url=jdbcracle:thin:@xxx:1521:52SUP

and

52DEV.Url=~~~~~~~~~~~~~~~~~~~~~~~EV to

52DEV.Url=jdbcracle:thin:@x.x.x.x:1522:52DEV

restart orabbix service after changes

[lioxa_zab]

But instance name is DEV and SUP , in the beginning it was
SUP.Url=jdbcracle:thin:@xxx:1521:SUP
no difference.

change 52SUP.Url=~~~~~~~~~~~~~~~~~~:SUP to

52SUP.Url=jdbcracle:thin:@xxx:1521:52SUP

and

52DEV.Url=~~~~~~~~~~~~~~~~~~~~~~~EV to

52DEV.Url=jdbcracle:thin:@x.x.x.x:1522:52DEV

restart orabbix service after changes

[dantony79]

wrong config file

#comma separed list of Zabbix servers
ZabbixServerList=zabbix

ZabbixServer.Address=x.x.x.x
ZabbixServer.Port=10051


it should be

ZabbixServerList=ZabbixServer

[lioxa_zab]

No , did help. Same Error.

[lioxa_zab]

triggers

Orabbix_export_triggers.xml file is wrong it's same as Orabbix_export_items.xml it's impossible to create any triggers from this file.

archives 1.0.3 and 1.0.4 is wrong .
archive 1.0.2 is last one had proper Orabbix_export_triggers.xml file.

[dalle]

Orabbix_export_triggers.xml file is wrong it's same as Orabbix_export_items.xml it's impossible to create any triggers from this file.

archives 1.0.3 and 1.0.4 is wrong .
archive 1.0.2 is last one had proper Orabbix_export_triggers.xml file.

Thank you i was looking about I've relased 1.0.4 one hour ago and I didn't notified this release at all incredible that you have already tryed thank you

[dalle]

Orabbix 1.0.4 released

about this release:
Improved dynamic rebuild of databaselist
Correct a critical bug in some case can Orabbix send wrong values now send always right values
Correct template to easy import
more news are coming stay tuned!
more info on my website

http://www.smartmarmot.com/

[lioxa_zab]

non existing items.

When I tried to import Orabbix_export_graphs.xml , it's giving an error that
dbsize and dbfilesize items doesn't exist. After I created this items , graphs was imported successfully. This items also not existing in 1.0.3 and 1.0.2 ver.

[dalle]

When I tried to import Orabbix_export_graphs.xml , it's giving an error that
dbsize and dbfilesize items doesn't exist. After I created this items , graphs was imported successfully. This items also not existing in 1.0.3 and 1.0.2 ver.

You are absolutely right i'm sorry
Use the template in attach or create two items
Thank you for this feedback

Anyway I've updated my distribution on my website

[Varamaster]

Tablespace : none

What about tablespace ??

Timestamp Value
[2010.Oct.07 13:00:22] none

is important information that is not listed or is not correct.

[sybex]

Hi, ...

if you would have a look in the SQL Querys in Orabbix then you would see in the tbl_space query something like that:

"where kperc > 93"

This means you will see the values in Zabbix if one of the Tablespaces has reached 93%.

I'm also thinking about so remove this to see the tablespace sizes all the time. Problem there is that you don't can create a new trigger because the returned value is HTML code.

But you could double the tbl_space entry and modify the query in the way that you would get only percentage and tablespace name ... after 93%, else "none".

The trigger you could made would like a string trigger which send alarms if something else then "none" was coming back.

[dalle]

to see the dimension of the database there is dbsize and dbfilsize.
When i've made this daemon I've thinked that was completely useless see
all tablespaces listed .
This item is born to send an alarm when a tablespace reache a value of free space of 93%