Path: text.usenetserver.com!out03b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!u10g2000prn.googlegroups.com!not-for-mail From: joel garry Newsgroups: comp.databases.oracle.server Subject: Re: Incremental Commits and Disappearing Sessions Date: Mon, 3 Mar 2008 10:51:10 -0800 (PST) Organization: http://groups.google.com Lines: 37 Message-ID: <0ca3ad57-8f28-4eae-b600-e93a55464482@u10g2000prn.googlegroups.com> References: NNTP-Posting-Host: 75.49.200.201 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1204570271 20921 127.0.0.1 (3 Mar 2008 18:51:11 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 3 Mar 2008 18:51:11 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: u10g2000prn.googlegroups.com; posting-host=75.49.200.201; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv User-Agent: G2/1.0 X-HTTP-Via: 1.0 ISA2K4-OC1 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1),gzip(gfe),gzip(gfe) Xref: usenetserver.com comp.databases.oracle.server:442071 X-Received-Date: Mon, 03 Mar 2008 13:51:11 EST (text.usenetserver.com) On Mar 2, 6:44 pm, "Dereck L. Dietz" wrote: > 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)? Having one might: http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/apxtblsh.htm#sthref1644 and see bug 5607984. Now, those are probably not your problems... but it is possible that there are related problems, since Oracle has to assume defaults - and there are definitely problems with server side expire time. jg -- @home.com is bogus. "This place is great! It's like the Internet - but it's real." - Excited child at grand opening of new Encinitas library. It has wifi on a deck overlooking the ocean, too.