Database Networking (MOSC)

MOSC Banner

Dead connection detection

edited Nov 9, 2012 4:22AM in Database Networking (MOSC) 15 commentsAnswered ✓
 Hello,

I'm working on the Dead connection detection for an 11.2.0.2 RAC Db.

A connection pool is opened by the application server to this DB, the TCP traffic goes through a FW. The expire time on the FW is 3600 s , so if a session in the pool is idle for more than one hour, it is killed by FW, but neither the client or the db server are noticed.
I found note ID 257650.1 on MOS about this issue, and about the use of sqlnet.expire_time.

It has been set on server-side, but I would like to set the same thing on client side to ease dead connection detection on client side.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center