Q
Problem solve Get help with specific problems with your technologies, process and projects.

Client laptop losing connectivity after idle time

I have a client laptop that uses a SQL*Net/Net8 connection to access an Oracle 10g database application on Linux. After five to 10 minutes of idle activity on the client's laptop PC, it loses connection to the Oracle database and generates an ORA-03114 connection error. How can I resolve this issue?

I have a client laptop that uses a SQL*Net/Net8 connection to access an Oracle 10g database application on Linux. After five to 10 minutes of idle activity on the client's laptop PC, it loses connection to the Oracle database and generates an ORA-03114 connection error. How can I resolve this issue so that idle connection activity does not cause the laptop to lose connection to the database and application? There is no firewall or VPN associated with the laptop and the desktop PC that runs the application does not encounter this issue, only the laptop computers that access the application and database on the Linux server. I tried to use a different value on the client sqlnet.ora file to set SQLNET.EXPIRE_TIME=200 to prevent loss of connection during idle time but this did not solve the problem. How can I fix this problem on our laptops that access the Oracle server?
About the only thing I know you can do on the client side is modify the SQLNET.EXPIRE_TIME parameter in your client's sqlnet.ora configuration file. But this is not the only place that idle time is defined. Your DBA may have set your database user's profile to disconnect you after a certain period of time. You'll have to contact your DBA to see if he/she can help you with this issue.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close