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

Matthew_64708's avatar
Matthew_64708
Icon for Nimbostratus rankNimbostratus
Feb 02, 2009

Oracle Monitor Connection Issue

On our project we're having trouble configuring Oracle monitors on our F5 appliances. We are getting the following error in the F5 logs:     Recvd: 'jdbc:oracle:thin:@xxx.xxx.xxx.xxx::SID(...
management
monitoring
Shah_13931's avatar
Shah_13931
Icon for Nimbostratus rankNimbostratus
Feb 03, 2009
I work with mtorrenzano. We have Oracle RAC 10g Release 2 cluster. The issue seem to be that of service_name vs SID. Via typical jdbc url, we can specify SID but not service_name. For that the url needs to be something like - jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname1)(PORT = port)) (ADDRESS = (PROTOCOL = TCP)(HOST = hostname2)(PORT = port)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = service_name) ) )

 

 

How do we specify such URL while configuring an Oracle health monitor? The only other way around this seem to be installing Oracle client on F5 and configuring tnsnames.ora in appropriate manner.

 

 

Any suggestions are appreciated.