Home » RDBMS Server » Networking and Gateways » DB Connection Timeout
DB Connection Timeout [message #200240] Sun, 29 October 2006 21:46 Go to next message
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!
Re: DB Connection Timeout [message #201476 is a reply to message #200240] Sat, 04 November 2006 14:41 Go to previous messageGo to next message
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
Re: DB Connection Timeout [message #201497 is a reply to message #201476] Sat, 04 November 2006 22:54 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

As per suggested by Kim.
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.
Previous Topic: TNS Names Worked a second ago now errors
Next Topic: Shutdown database & lsnrctl start
Goto Forum:
  


Current Time: Thu Dec 08 14:24:54 CST 2016

Total time taken to generate the page: 0.11120 seconds