Re: ORA-03135

On Mar 4, 4:14 am, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> "Dereck L. Dietz" <diet..._at_ameritech.net> wrote innews:0g1zj.10400$5K1.9452_at_newssvr12.news.prodigy.net:
>
> > Oracle 10.2.0.3.0
> > Windows 2003 Server
>
> > Other than improperly set values in an SQLNET.ORA file, or default
> > values due to no SQLNET.ORA file, are there any other possible causes
> > for an ORA-03135 error?
>
> > Thanks.
>
> 03135, 00000, "connection lost contact"
> // *Cause:  1) Server unexpectedly terminated or was forced to terminate.
> //          2) Server timed out the connection.
> // *Action: 1) Check if the server session was terminated.
> //          2) Check if the timeout parameters are set properly in
> sqlnet.ora.

We get this error intermittently every 2nd day or so on our webserver using connection pooling.

In this case what happens to the rest of the connections in the pool....are they all marked as dicarded? Should I be calling the clear connection pool command to free these other connections when experiencing an 03135 error? Received on Wed Mar 26 2008 - 13:13:38 CDT