For more information regarding the security incident at F5, the actions we are taking to address it, and our ongoing efforts to protect our customers, click here.

Forum Discussion

Jason_Keating's avatar
Jason_Keating
Icon for Altostratus rankAltostratus
May 07, 2011

Oracle Service JDBC URL

We've got 4 Oracle RAC Nodes, each with multiple instances, each with multiple DB's       We want to put the services behind LTM's for various reasons, improvement upon the Oracle failove...
config
design
Jason_Keating's avatar
Jason_Keating
Icon for Altostratus rankAltostratus
Jul 12, 2011

Update.

 

 

 

We decided to go with member monitors, see config below.

 

 

 

ltm monitor oracle aimosprod.wip.ssi.govt.nz_SQLNET_1521_myService_myDatabase_oracle {

 

count "0"

 

database "myDatabase"

 

debug "no"

 

defaults-from SQLNET_1521_hisDatabase_oracle

 

interval 10

 

password "myPassword"

 

recv "1"

 

recv-column "1"

 

recv-row "1"

 

send "select 1 from v$active_services where lower(name) = 'myServiceName'"

 

time-until-up 0

 

timeout 31

 

username "myMonitorUser"

 

}

 

 

 

 

Works ok but support for services would be nice.