Re: Connection time out to Oracle10G, XP-Pro

Bob T wrote:

> 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

Add this to your SQLNET.ORA and see what happens.

trace_level_client= 16
trace_file_client=client
trace_directory_client=c:\temp
trace_unique_client=true

I've not seen this before either but then I'd be running Linux, not Windows, on that hardware.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)