Forum Discussion
Sure. The pool is:
gtm pool MyAccount-ODB-GC_pool {
alternate-mode none
fallback-mode none
max-address-returned 3
members {
GC-Oracle-Prod-SCAN:GC-Oracle-Prod-SCAN-IP1 {
order 0
}
GC-Oracle-Prod-SCAN:GC-Oracle-Prod-SCAN-IP2 {
order 1
}
GC-Oracle-Prod-SCAN:GC-Oracle-Prod-SCAN-IP3 {
order 2
}
}
monitor MyAccount-ODB_prod_monitor
}
The server definition is:
gtm server GC-Oracle-Prod-SCAN {
addresses {
172.16.XX.YY {
device-name GC-Oracle-Prod-SCAN
}
}
datacenter "/Common/Primary Data Center"
product generic-host
virtual-servers {
GC-Oracle-Prod-SCAN-IP1 {
destination 172.16.XX.YY:ncube-lm
}
GC-Oracle-Prod-SCAN-IP2 {
destination 172.16.XX.ZZ:ncube-lm
}
GC-Oracle-Prod-SCAN-IP3 {
destination 172.16.XX.AA:ncube-lm
}
}
}
The monitor:
gtm monitor oracle MyAccount-ODB_prod_monitor {
count 0
database (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=%node_ip%)(PORT=%node_port%))(CONNECT_DATA=(SERVICE_NAME=app_odb)))
debug no
defaults-from oracle
description "Oracle monitor of read-write status of ODB database"
destination *:*
interval 30
password $M$Vw$9eeRFG0XmGiaevM5ubIKAw==
probe-timeout 5
recv "READ WRITE"
recv-column 1
recv-row 1
send "select open_mode from v$database"
timeout 91
username F5CHECK
}
I didn't include the wide IP, as it's downstream of the issue - the issue is that the pool above is never marked as up, even though it should be.
That same server object (with its 3 virtual servers) works fine in other similar monitors. That same monitor works fine for a different server object (with 3 different virtual servers). And, the monitor works fine on THESE IPs, per the monitor debug log (which shows the correct results being returned from Oracle, and the servers being marked as !Up!, see my post above); the DBDaemon log also shows the monitor correctly working, and returning "Up". The only breakdown appears to be getting the status from big3d (which times out). Note there are no other timeouts on any other statuses (statii?) being reported by big3d.
Really stumped. I may restart big3d as a precaution - is that safe to do, or will it potentially interrupt GSLB resolution of hostnames? (we have 4 standalone GTMs in this particular iQuery mesh).
thx