Orabbix:"Another way to monitor Oracle reloaded"

[dalle]

Problem solved. I named my host with a wrong name. Sorry about that.
Thanks for your help.

you're welcome

[fritz]

Hello everybody,

Orabbix is working very well on my infrastructure. I have a question about the actives session.
The DB Administrator showed me that there is many zabbix session (around 20) running on the Oracle instance.
Do you think is it normal ? or maybe there is something wrong in the Oracle configuration ?

thanks in advance ...

[dalle]

Hello everybody,

Orabbix is working very well on my infrastructure. I have a question about the actives session.
The DB Administrator showed me that there is many zabbix session (around 20) running on the Oracle instance.
Do you think is it normal ? or maybe there is something wrong in the Oracle configuration ?

thanks in advance ...

20 zabbix session are really too much!!
please try to disable lock and audit query from query.properties
removing the keys
"audit" and "locks" from the list
QueryList=
and restart Orabbix maybe that you have aud$ table that have a lot of entry and this slowdown your system
let me know

[fritz]

Hi dalle,
Sorry for the delay.
Now it's ok. I have only one zabbix user in the session.

Thanks

[fflux]

.period

hiya all, first post here.

i'm configure ring orabbix with some custom queries.

now i'm looking for a time period a check will run.
the only thing i have found until now is the .period option, is there anything like
.start and .end?

the reason i want to do it is that i have made a query to check the last backup of the database, and i check on the last backup done with sysdate -1, but some databases are not finished with the backup until 7 am.

in this case i want to check between 8 and 9 am if there is a valid backup.

[dalle]

hiya all, first post here.

i'm configure ring orabbix with some custom queries.

now i'm looking for a time period a check will run.
the only thing i have found until now is the .period option, is there anything like
.start and .end?

the reason i want to do it is that i have made a query to check the last backup of the database, and i check on the last backup done with sysdate -1, but some databases are not finished with the backup until 7 am.

in this case i want to check between 8 and 9 am if there is a valid backup.

Unfortunately I have not yet developed this is good new features.
May be on next release.

[fflux]

trigger name

Hiya all,

is there a way to include the dns name into the triggername?

normaly you use {HOSTNAME} but in case of orabbix the hostname==database name.

so i want my trigger name to include:

Database {HOSTNAME} on {HOST.DNS} (according to the macro's)

but all i see is:

Database db1 on {HOST.DNS}

thanks Felix

[fflux]

next question

if i change the database to accept connections with:
exec dbms_network_acl_admin.create_acl(acl => ‘resolve.xml’,description => ‘resolve acl‘, principal =>’ZABBIX’, is_grant => true, privilege => ‘resolve’);
exec dbms_network_acl_admin.assign_acl(acl => ‘resolve.xml’, host =>’*’);

then other software that uses a network acl is failing.

got to say, i'm not that educated in those acls.

[dalle]

Hiya all,

is there a way to include the dns name into the triggername?

normaly you use {HOSTNAME} but in case of orabbix the hostname==database name.

so i want my trigger name to include:

Database {HOSTNAME} on {HOST.DNS} (according to the macro's)

but all i see is:

Database db1 on {HOST.DNS}

thanks Felix

right because he can't resolve HOST.DNS it's a side effect caused by using of HOSTNAME and treat databases has HOST.
There isn't a solution or bette I don't know a solution to resolve this macro

[dalle]

next question

if i change the database to accept connections with:
exec dbms_network_acl_admin.create_acl(acl => ‘resolve.xml’,description => ‘resolve acl‘, principal =>’ZABBIX’, is_grant => true, privilege => ‘resolve’);
exec dbms_network_acl_admin.assign_acl(acl => ‘resolve.xml’, host =>’*’);

then other software that uses a network acl is failing.

got to say, i'm not that educated in those acls.

Doing so you have limited the acl resolve to the user ZABBIX (principal)
all other users or role that don't have this acl can't use resolve by default.

[fflux]

right because he can't resolve HOST.DNS it's a side effect caused by using of HOSTNAME and treat databases has HOST.
There isn't a solution or bette I don't know a solution to resolve this macro

aha, i get what you are saying, but on the host configuration there is a value of DNS name: in that field i put the right hostname

so by the host: name is sua001 dns name is sulxadb01a

now {HOSTNAME} = sua001 so i expected the HOST.DNS to be the other field.

thanks for the reply, it's just a minor inconfinients.

[fflux]

Doing so you have limited the acl resolve to the user ZABBIX (principal)
all other users or role that don't have this acl can't use resolve by default.

right, thats what i was seeing (and some upset people lol) i have changed the host from '*' to the ip adress of the zabbix server and all is ok again.

Felix

btw, i'm getting into the zabbix and orabbix, it's realy great.

[dalle]

right, thats what i was seeing (and some upset people lol) i have changed the host from '*' to the ip adress of the zabbix server and all is ok again.

Felix

btw, i'm getting into the zabbix and orabbix, it's realy great.

Thank you!!! I'm really happy that you like it!

[fflux]

website in error

don't'know if this is the right place, but it looks like there is something wrong on the orabbix installation page:

archive.Query=select round( A.LOGS*B.AVG/1024/1024/10 )
from ( SELECT COUNT (*) LOGS FROM V$LOG_HISTORY WHERE
FIRST_TIME >= (sysdate -10/60/24)) A,
( SELECT Avg(BYTES) AVG, Count(1), Max(BYTES) Max_Bytes,Min(BYTES) Min_Bytes FROM v$log) B
archive.RaceConditionQuery=select value
from
v$parameter where name=’log_archive_start’
archive.RaceConditionValue=FALSE
TIP: In the example above, Orabbix would execute “archive.Query” only if the query “archive.RaceConditionQuery” return the value “archive.RaceConditionValue”. Pratically the “Archive” query is execute only if database is in arhivelogmode (Parameter “log_archive_start” set to TRUE)

shouldn't that be archive.RaceConditionValue=TRUE

(could be wrong, as in oracle 10 and higher this parameter can't be used.
i changed it to
archive.RaceConditionQuery=select log_mode from v$database
archive.RaceConditionValue=ARCHIVELOG

Felix

and i love orabbix more and more
keep on the good work.

i only wish zabbix was a little better so i could store 2 values with a query.
e.g. now i query tablespace free as 85% and one with 95%

realy wish i could just get the ones with > 85% as a value and the other field with the tablespace name.
then i could make one item with 2 triggers.

or do i do it wrong?

[fritz]

dbsize and dbfilesize

Question about the 2 queries ?
Why do you divided the both queries by 10 ? I believe there s little mistake, no ?

dbsize.Query=SELECT to_char(sum(  NVL(a.bytes/1024/1024/10 - NVL(f.bytes/1024/1024/10, 0), 0)), 'FM99999999999999990') retvalue \

dbfilesize.Query=select to_char(sum(bytes/1024/1024/10), 'FM99999999999999990') retvalue from dba_data_files

Thanks for your feedback ..