"partner checking" monitor of Oracle DB

My understanding is you can SSH into the DB or set up some sort of sql select or get statement as an additional monitor. v9 supports using multiple monitors for determining entire system health.

 

 

Look here or search Ask F5

 

Best,

 

mIke

 

 

https://support.f5.com/kb/en-us/products/big-ip_ltm/manuals/product/bigip9_0config/ConfigGuide9_0-11-1.htmlwp1185889

 

 

Oracle

 

 

With an Oracle type of monitor, you can check the status of an Oracle database server. The check is successful if the monitor is able to connect to the server, log in as the indicated user, and log out.

 

 

Figure 10.18 shows the settings and default values of an Oracle-type monitor.

 

Figure 10.18 An Oracle-type custom monitor with default values

 

 

Name my_oracle

 

 

Type Oracle

 

 

Interval 30

 

 

Timeout 91

 

 

Send String GET /

 

 

Receive String ""

 

 

User Name ""

 

 

Password ""

 

 

Database ""

 

 

Receive Row ""

 

 

Receive Column ""

 

 

Alias Address * All Addresses

 

 

Alias Service Port * All Ports

 

 

 

 

The Send String setting specifies a SQL statement that the LTM system should send to the Oracle server. An example is SELECT * FROM sales.

 

 

The Receive String setting is an optional parameter that specifies the value expected to be returned for a specific row and column of the table that the Send String setting retrieved. An example of a Receive String value is SMITH.

 

 

In an Oracle type of monitor, the Database setting specifies the name of the data source on the Oracle server. Examples are sales and hr.

 

 

The Receive Row setting is optional, and is useful only if the Receive String setting is specified. This setting specifies the row in the returned table that contains the Receive String value.

 

 

The Receive Column setting is optional and is useful only if the Receive String setting is specified. This setting specifies the column in the returned table that contains the Receive String value.