Orabbix:"Another way to monitor Oracle reloaded"

[dalle]

please try with this script and let me know

CREATE USER ZABBIX
IDENTIFIED BY <REPLACE WITH PASSWORD>
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
GRANT ALTER SESSION TO ZABBIX;
GRANT CREATE SESSION TO ZABBIX;
GRANT CONNECT TO ZABBIX;
ALTER USER ZABBIX DEFAULT ROLE ALL;
GRANT SELECT ON V_$INSTANCE TO ZABBIX;
GRANT SELECT ON DBA_USERS TO ZABBIX;
GRANT SELECT ON V_$LOG_HISTORY TO ZABBIX;
GRANT SELECT ON V_$PARAMETER TO ZABBIX;
GRANT SELECT ON SYS.DBA_AUDIT_SESSION TO ZABBIX;
GRANT SELECT ON V_$LOCK TO ZABBIX;
GRANT SELECT ON DBA_REGISTRY TO ZABBIX;
GRANT SELECT ON V_$LIBRARYCACHE TO ZABBIX;
GRANT SELECT ON V_$SYSSTAT TO ZABBIX;
GRANT SELECT ON V_$PARAMETER TO ZABBIX;
GRANT SELECT ON V_$LATCH TO ZABBIX;
GRANT SELECT ON V_$PGASTAT TO ZABBIX;
GRANT SELECT ON V_$SGASTAT TO ZABBIX;
GRANT SELECT ON V_$LIBRARYCACHE TO ZABBIX;
GRANT SELECT ON V_$PROCESS TO ZABBIX;
GRANT SELECT ON DBA_DATA_FILES TO ZABBIX;
GRANT SELECT ON DBA_TEMP_FILES TO ZABBIX;
GRANT SELECT ON DBA_FREE_SPACE TO ZABBIX;
GRANT SELECT ON V_$SYSTEM_EVENT TO ZABBIX;

I've made a fast test, and seems that Orabbix is wokring well with this creation script I'm going to update the documentation.
Please let me know if there are issue

[frank0521]

Orabbix monitor Oracle 11gR2 RAC

Hi Dalle,
I want use Orabbix to monitor my Oracle 11gR2 RAC (have two hosts in RAC), I have been installed orabbix and configured config.porps, but, how can I apply the oracle RAC hosts in zabbix? I need apply two host with diffrent IP address or just one without IP?
If I just apply only one host in zabbix, and how can I realize the detection of the nodes alive in the RAC?

By the way, perhaps there is a clerical error about RAC connection string In orabbix installation Instructions. Maybe we need change
RACINST.Url=jdbcracle:thin:@(DESCRIPTION=(ADDRESS_ LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=RAC1.EXAMPLE.COM ) (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=RAC2.EXAM PLE.COM)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=R ACINST)))
to
RACINST.Url=jdbcracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(P ROTOCOL=TCP)(HOST=RAC1.EXAMPLE.COM) (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=RAC2.EXAM PLE.COM)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=R ACINST)))

Thanks.

[zalex_ua]

To all Orabbix users - see please https://support.zabbix.com/browse/ZBX-4980

[dvedadt9]

Multiple oracle instances...

Hi, I have questions regarding monitoring multiple oracle instances.

Is it possible to monitor more than one oracle instance at one oracle server using orabbix?
Another question is, is it possible to monitor instances from different ORacle servers that have same SID names?
Is there any option to do this using Orabbix?

Thank you

[dalle]

To all Orabbix users - see please https://support.zabbix.com/browse/ZBX-4980

Thank you!!! I didn't know!

[dalle]

Hi, I have questions regarding monitoring multiple oracle instances.

Is it possible to monitor more than one oracle instance at one oracle server using orabbix?
Another question is, is it possible to monitor instances from different ORacle servers that have same SID names?
Is there any option to do this using Orabbix?

Thank you

sure
e.g. you have on your Oracle TEST server a sid called "orcl" and on your production environment the same sid "orcl" you should simply call them (in orabbix config file) orcl_test and orcl_prod or something like that, and consequently you need to create two host on zabbix with the same name "orcl_prod" and "orcl_test" nothing more.
ù obviously the connection string on Orabbix's properties file will be the same exept for the IP address.

[dvedadt9]

Whre ORabbix should be installed

Simple question:
Please can you tell me where Orabbix should be installed.
According to installation documentation it is stated following:
"Steps for Installation

Download Orabbix to your Zabbix Server
On your Zabbix server, unzip Orabbix to: /opt/orabbix
Copy file /opt/orabbix/init.d/orabbix to /etc/init.d/orabbix
Grant execute permissions to the following files:
....
"
It seems that this should be installed at zabbix server (not server with oracle database). Is that correct?


Can you also give me info where I can find more explained parameters for config.props? I have few doubts in configuring this file, so your help would be helpful.

[Yello]

Hi,
I'm seeing data being collected at 30 second intervals by orabbix. Can you tell me how I slow down the collection please?

Regards,
David

[buddy]

Multiple values.

Hi.

When reading the orabbix documentation, I don't understand is one custom query can return only one value?

If I misunderstood the documentation, how to pass multiple values in zabbix ?

Sorry for my poor english... :-)

[fflux]

Hi.

When reading the orabbix documentation, I don't understand is one custom query can return only one value?

If I misunderstood the documentation, how to pass multiple values in zabbix ?

Sorry for my poor english... :-)

correct 1 query 1 value to store.

[pietro54]

Hi,
I got a bit problem with orabbix and viewing graphs.
When i look at short perioid i dont see any data, when i look at least month i see normal data.
I was thinking maybe this is becouse history value is to low, but its set to 90 days, trends ar set to 365days.

Maybe some one know why this issue exsists?

[zabbn00b]

sure
e.g. you have on your Oracle TEST server a sid called "orcl" and on your production environment the same sid "orcl" you should simply call them (in orabbix config file) orcl_test and orcl_prod or something like that, and consequently you need to create two host on zabbix with the same name "orcl_prod" and "orcl_test" nothing more.
ù obviously the connection string on Orabbix's properties file will be the same exept for the IP address.

I have also been thinking the same thing.

I see what you're doing here but wont this double up on queries e.g. disk space, cpu etc?

[zabbn00b]

Hi,

For anyone else out there i was having a problem with the dbfilesize not reporting.

It wasn't in the query.props. I copied it from the sample file.

I also changed the item in zabbix units to B for dbfilesize and removed the multiplier from the query as it was reporting incorrectly for me.

dbfilesize.Query=select to_char(sum(bytes), 'FM9999999999999990') retvalue from dba_data_files.

i did the same for dbsize.

Also my archivelog is showing as 0MB, archivelog mode is TRUE.

Thanks.

[daniel.levai]

Zabbix 2.0.x supported?

Hi!

Is Zabbix version 2.0 and up supported? If it is, which Orabbix version is needed?


Thanks,
Daniel

[dalle]

Hi!

Is Zabbix version 2.0 and up supported? If it is, which Orabbix version is needed?


Thanks,
Daniel

The comunication protocol is not changed you can use the version that you prefer