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

Ken_Taylor_5009's avatar
Ken_Taylor_5009
Icon for Nimbostratus rankNimbostratus
Jan 14, 2009

Oracle Connection Pooling through the LTM

Hi,     I currently have a LTM on 9.3.1 configured with an in path installation between the web server and the database server.     Web Server is IIS6   Oracle client on W...
oracle
partner
Ken_Taylor_5009's avatar
Ken_Taylor_5009
Icon for Nimbostratus rankNimbostratus
Jan 15, 2009
Thanks for the response

 

 

Currently I have the have the F5 configured so that connections on TCP/1521 will not timeout at all. These application have low usage so the connections do timeout if the timeout is not set to infinite.

 

 

What I am looking for is if some has experience with a configuration of SQLNET so I do not have to have the connections set to infinite.

 

 

F5 is causing the issue but I am thinking the resolution is in the configuration of SQLNET.ORA.

 

 

We are going to test the following configuration but i am not sure if it will do the trick.

 

 

sqlnet.expire_time = 45

 

 

 

Possible values: 0-any valid positive integer! (in minutes)

 

Default: 0 minutes

 

Recommended value: 10 minutes

 

 

Purpose: Indicates the time interval to send a probe to verify the

 

client session is alive (this is used to reclaim wasteful

 

resources on a dead client)

 

 

 

We will set the F5 to timeout at 60mins and see what happens.

 

 

Ken