Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: "Bob T" <bob.mailist@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Connection time out to Oracle10G, XP-Pro
Date: 5 May 2005 18:39:22 -0700
Organization: http://groups.google.com
Lines: 34
Message-ID: <1115343562.793306.61030@g14g2000cwa.googlegroups.com>
NNTP-Posting-Host: 208.42.116.153
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1115343567 15206 127.0.0.1 (6 May 2005 01:39:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 6 May 2005 01:39:27 +0000 (UTC)
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=208.42.116.153;
   posting-account=qW4lTA0AAADKU55KkbFMjh6mutYP-poc
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:242126

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