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.

"Dereck L. Dietz" <dietzdl@ameritech.net> wrote in
news:0g1zj.10400$5K1.9452@newssvr12.news.prodigy.n et:

> 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.

On Mar 4, 4:14*am, "Ana C. Dent" <anaced...@hotmail.com> wrote:
> "Dereck L. Dietz" <diet...@ameritech.net> wrote innews:0g1zj.10400$5K1.9452@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?