Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
>
Sounds like sqlnet.timeout. Anything like that in
the network configuration on the server? (sqlnet.ora, iirc)
-- Regards, Frank van BortelReceived on Fri May 06 2005 - 06:01:08 CDT