Database Networking (MOSC)

MOSC Banner

client-side timeout

edited Aug 3, 2009 10:13AM in Database Networking (MOSC) 5 commentsAnswered
Hi, we have a network problem that causes the clients to hang.

We are using Oracle 8i/ 9i /10g databases and Forms6 on the client side. Whenever there is a network connection problem the Forms freezes and we have to kill the processes.

Is there possible to set a client-side timeout (sqlnet.ora  or tnsnames.ora)? That is, if there is no response from the Database after X seconds then abort the query.

 

Certainly we must fix the network problem, but there can always be some bug on the network. So I feel that a timeout function will reduce the danger of clients that hangs.

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