Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.vmunix.org!peer02.cox.net!cox.net!p01!fed1read03.POSTED!53ab2750!not-for-mail Newsgroups: comp.databases.oracle.server Subject: Re: Connection time out to Oracle10G, XP-Pro From: "IANAL_VISTA" References: <1115343562.793306.61030@g14g2000cwa.googlegroups.com> Organization: Black Hole, Inc. Message-ID: User-Agent: Xnews/5.04.25 Lines: 49 Date: Fri, 06 May 2005 02:00:57 GMT NNTP-Posting-Host: 68.7.204.31 X-Complaints-To: abuse@cox.net X-Trace: fed1read03 1115344857 68.7.204.31 (Thu, 05 May 2005 22:00:57 EDT) NNTP-Posting-Date: Thu, 05 May 2005 22:00:57 EDT Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:242129 "Bob T" wrote in news:1115343562.793306.61030@g14g2000cwa.googlegroups.com: > I am running Oracle 10G on WinXP Pro 2.8G CPU 1G Memory New machine, > clean install. I have used Oracle in all capacities for 15 years, but > have not seen this before. > > I am getting an Oracle Connection time-out after 15-30 minutes with no > activity on the database. It occurs with Toad and with SQL*Plus and > Forms. > > Th XP Host machine has a fixed IP, and I am connecting from another > machine that has an IP assigned by my local router. The two machines > are actually only a few feet apart. > > I worked around it in Forms by adding a timer to select 1 from dual > every ten minutes. The connection is never lost with this hack. > > I at first assumed it was a new parameter setting and I would figure > out > what to do about it in due time, then get rid of the timer. However, I > > can't find any reference to a timer or a param that might cause this > behavior. > > I am running MS Firewall on the XP box, but I have tested this with the > > firewall disabled and the timeouts still occur. > > This is what TOAD reports: > The following error has occurred: ORA-12571: > TNS:packet writer failure > > Any ideas or suggestions would be appreciated! > > Thanks Bob Treumann, Minnesota > > Based upon your description I suspect that you are running C/S Forms and not webforms. Right? Does this timeout impact ALL users? I suspect that it could be a SQL*Net or PROFILE "timeout"? 1) If you have a network sniffer, use it. 2) Try enabling SQL*Net tracing at its most verbose settings. Good Luck on the Gremlin hunt.