.ExtraQueryListFile==./confQueryTest_2.props

addsanother custom query to the default query file. If there are duplicates theExtraQueryListFile will override them.

query.props

Configurationof query.props file

Thequery.props file can be modified or added to, so you can supply your owncustomised queries through Orabbix against your Oracle instances/databases.Each query created has an associated 'Item' or item name that Zabbix will useto identify the query.

NOTE: Item names must be unique.

Theconfigurable items are formatted as follows.

Youhave to set the query name under the QueryList in the query.props file. Eachquery name is comma separated. For example;

QueryList=queryName1,queryName2,queryName3

Youmust identify the query by the unique item name you specified in the QueryList,followed by '.Query' for Orabbix to recognize that this is the query string.Its important to remember NOT to add the semi-colon “;”to the end of your custom query.

customQueryItemName.Query=yourQueryHere

Nowyou can define what you want Orabbix to return to your Zabbix Server if no datais found for your query.

customQueryItemName.NoDataFound=none

TIP: In the example above, Orabbix would send the string “none”to the Zabbix Server.

Youcan specify if you want a different execution period for your query

customQueryItemName.Period=

TIP:You can change the execution time of dbversion that don’t change often

Nextyou can specify a query that will be executed and if return RaceCondiftionValuethe query customQueryItemName is executed otherwise is skipped

customQueryItemName.ACTIVE=[true|false] iftrue query is executed otherwise skipped

archive.Query=select round(A.LOGS*B.AVG/1024/1024/10 ) \

from ( SELECT COUNT (*) LOGS FROM V$LOG_HISTORYWHERE \

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)

.Trim=[true|false]

iftrue the resultset is trimmed (default is true)

.AddSpaces=[true|false]

iftrue the add a space between columns of resultset(default is true)

.ExcludeColumnsList=[1,2,3,..n]

excludefrom result set the 1st, the 2nd etc.. columns from resultset

.Period

.WhenNotAlive =

isused to specify a value or a string to send if a database is not working, doingsuch will "clean" the graphs generated in Zabbix with a"set" value.

Addedthe following parameter on main configuration file:

DefaultUser =

DefaultPassword =

.ExtraQueryListFile =

onquery's properties file I've added the following parameter:

.WhenNotAlive =

withthese parameter you can define a default username and password for all thedatabase.

DefaultUser =

DefaultPassword =