DatabaseList.MaxActive=10

#The maximum number of milliseconds

Hereyou define how long that the pool will wait (when there are no available connections)for a connection to be returned before throwing an exception, or set the value<= 0 to wait indefinitely.

DatabaseList.MaxWait=100

Alsounder the same section, you can define the maximum number of connections thatcan remain idle within the connection pool, without being released.Alternatively, you can set a negative value for no limit.

DatabaseList.MaxIdle=1

TIP: You can specify the Database connection parameters for each database youwish to monitor individually, underneath your Database Connection Parameters.This allows you to customise your connection settings based on the Databaseconstraints I.e one connection pool for your PRODUCTION DB and another for youTEST DB, for example;

DB1.MaxActive=10

DB1.MaxWait=100

DB1.MaxIdle=1

Notethat any settings defines this way will override the general settings for yourgeneric connection pool.

Database Connection Parameters

Thissection sets your connection string to the Oracle Database. This string invokesa Java Database Connector (JDBC) to your Oracle Databases, and as such does notneed the Oracle Client to be installed.

#define here your connection string for eachdatabase

Hereyou will define the connection string. These are formatted as: DBName.Url(asspecified in your DatabaseList) followed by the jdbc string and your DatabaseServer information.

EXAMPLE1.Url=jdbc:oracle:thin:@SERVER1.EXAMPLE.COM:1521:DB1

Setyour Database username and password below. e.g.

EXAMPLE1.User=zabbix

EXAMPLE1.Password=zabbix_password

TIP: Setting connections to multiple databases is made easy by adding moreconnection strings, with their corresponding credentials. Example given below.

EXAMPLE2.Url=jdbc:oracle:thin:@server2.domain.example.com::EXAMPLE2

EXAMPLE2.User=zabbix

EXAMPLE2.Password=zabbix_password

EXAMPLE3.Url=jdbc:oracle:thin:@server3.domain.example.com::EXAMPLE3

EXAMPLE3.User=zabbix

EXAMPLE3.Password=zabbix_password

NOTE:After these entries, you can set your MaxActive, MaxWait and MaxIdle forthe individual database connections if you so wish.

Thereis a pair of default parameter:

DefaultUser =

DefaultPassword =

thisdefault parameter can be overridden using the following pair

.User and .User

Itis only possible to override Username or Password.

Query List File

Thisdefines where the file containing the Oracle (SQL) queries can be found. Thisis a customisable file. You can find the query parameter file at:

QueryListFile=/opt/orabbix/conf/query.props

youcan also specify :

.QueryListFile=./confQueryTest.propsthis file specify the query file of adatabase relative path are allowed

TIP: This is really useful to use different query file for differentdatabases or to have a pool of query file one for each

OracleRelease (if you have different release) and/or to have different query filesfor Production environment, Test environment, Developement environment etc..

thefollowing parameter