Re: Incremental Commits and Disappearing Sessions

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Mon, 03 Mar 2008 02:44:23 GMT
Message-ID: <bCJyj.10319$5K1.2038@newssvr12.news.prodigy.net>


Just wondering, can you post a copy of the server's SQLNET.ORA file? In one of your previous posts, you indicated that you saw "Got ORA-3135 while running PLSQL" in one of Oracle's trace files. ORA-3135, I believe, means that the server lost contact with the session. Settings in the SQLNET.ORA file, such as sqlnet.expire_time, may contribute to that error message, possibly due to a bug (see Metalink to see if it applies in your case).

---

I mentioned this to our "DBA" and his response was that the SQLNET.ORA file 
was a "client" file.

I was finally able to get an error logged and the error WAS the ORA-03135 
error which points to the SQLNET.ORA.  I checked the client configuration 
and there is no SQLNET.ORA files configured for the client.

Would not having an SQLNET.ORA on the server cause problems (assuming there 
isn't one configured which I don't know since I don't have access to the 
server itself)? 
Received on Sun Mar 02 2008 - 20:44:23 CST

Original text of this message