Oracle errors when the client leaves the application idle for 1hr +

Posted on 2003-03-29
Medium Priority
Last Modified: 2007-12-19
I have a site that is connected to the main site via a VPN connection.
When the users leave the Siebel application open and idle for more than 1 hour they receive the following errors:
Generic SSA NOTOK error message
An error has occured preparing a Sql statement
ORA-03113: end-of-file on communication channel.

the users have no problems with any other applications and the retreive email via Outlook through this VPN connection as well.

Any ideas would be apprecaited.
Question by:jmurray110
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 22

Expert Comment

by:Helena Marková
ID: 8236675
It seems that Siebel application has set timeout...
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 300 total points
ID: 8238238
Hi jmurray110,
   This "problem" can be result of many things:
   * Oracle closing automatically some connections that are inactive for long time
   * Some Connection Pooling that reuses connections
   * Network connection cuts that drop the connection

  Now, you should try to eliminate possible sources, and in case speak with the siebel application support to check for this problem.
  It is a generic problem, and you might look into the trace files on the server of the client sessions to check for more information.


Author Comment

ID: 8238335
i have found out that the Cisco PIX firewall / VPN device was causing the timeout to occur as it would expire the PAT after an hour of inactivity. I was able to bump the setting and reslove the issue.

Thanks for the suggestions though.
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 8238352
Thus, to clean up this question:
* award the points if you think a comment has pointed out the problem.
* ask in the community support to close the question as you solved your problem yourself

LVL 17

Expert Comment

ID: 10360686
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: angelIII {http:#8238238}

Please leave any comments here within the next four days.

EE Cleanup Volunteer

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question