Forum Discussion
shawn_kellermey
Nimbostratus
Nimbostratus"partner checking" monitor of Oracle DB
BIG-IP 9.4.0 Build 529.4. One VIP with pool contaiing web nodes. We perform HTTP monitor of web nodes without issue.
We would like to add, what the BigIP training documentation calls, a "partner checking" monitor to also monitor the Oracle DB, and thus mark the front end servers down if the DB should go down.
I cannot find anything on "partner checking" monitor. I do obviously see the Oracle monitor as being available when creating a custom monitor, but not sure if that is strictly for monitoring an Oracle DB which is being load balanced, as we are not doing this.
Any help would be greatly appreciated.
shawn_kellermey...or perhaps that is all I need...the custom oracle monitor specifying Oracle DB IP and port in alias fields. I would simply try this and see if works, however we're in a change freeze and I'm supposed to implement a solution as soon as we come out of freeze. If no one can confirm this by then, I'll certainly post back in two weeks as to whether or not it works.
thanks again- 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. - shawn_kellermeyvery much appreciated Mike. Will post back in a week with my success story and details.
