OraFAQ Forum: Networking and Gateways » DB Connection Timeout

Home » RDBMS Server » Networking and Gateways » DB Connection Timeout

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DB Connection Timeout [message #200240]

Sun, 29 October 2006 21:46

lowcash75
Messages: 67
Registered: February 2006

Member

I have an instance of Oracle 9.2.0.5 running on an XP machine. Everytime I use tools like Toad, Sql Navigator or even sql plus to connect to the database from another machine and I'm idle for a few mins I loose my connection and I have re connect. If I'm using sqlplus or TOAD locally on the same box I'm completely fine I don't loose my connection.

Please let me know what I should be looking at to fix this issue.

Thanks!

Report message to a moderator

Re: DB Connection Timeout [message #201476 is a reply to message #200240]

Sat, 04 November 2006 14:41

kimant
Messages: 201
Registered: August 2006
Location: Denmark

Senior Member

On the machine that get the time out, check the sqlnet.ora file for a timeout.

It is in the $oracle_home\network\admin folder.

Br
Kim

Report message to a moderator

Re: DB Connection Timeout [message #201497 is a reply to message #201476]

Sat, 04 November 2006 22:54

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

As per suggested by Kim.

Code: [Select all] [Show/ hide]

Inactive Session Expiration Time Kill inactive SQLNET sessions

sqlnet.expire_time = <integer_minutes> 
sqlnet.expire_time=10 
***
sqlnet.expire_time=0 ( set and see what happen)

Hope this Helps
Mohammad Taj.

Report message to a moderator

Previous Topic:	TNS Names Worked a second ago now errors
Next Topic:	Shutdown database & lsnrctl start

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 10:52:25 CDT 2025