Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newshub.sdsu.edu!router2.astraweb.com!news.astraweb.com!router1.astraweb.com!sn-xt-sjc-04!sn-xt-sjc-08!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.tools Subject: Re: Intermittent SQLNET errors Date: Tue, 04 Apr 2006 08:54:33 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1144166072.503657@yasure.drizzle.com> User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 References: <1143826687.210292.263890@g10g2000cwb.googlegroups.com> <1143827666.653264@yasure.drizzle.com> <1143828008.887757.13160@j33g2000cwa.googlegroups.com> <1144080655.420087@yasure.drizzle.com> <1144084231.717462.11210@z34g2000cwc.googlegroups.com> <1144092788.690986@yasure.drizzle.com> <1144094130.911266.121850@g10g2000cwb.googlegroups.com> In-Reply-To: <1144094130.911266.121850@g10g2000cwb.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 42 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.tools:70561 yoram.ayalon@structuredweb.com wrote: > You mention App Servers, ODBC, SQLNET, BEQ. > > How precisely are the clients connecting? > > ------------------------------------ > > clients are either CFM or ASP pages that are connecting using Microsoft > ADO, which in itself uses ODBC drivers. We are using both MS ODBC for > Oracle and Oracle ODBC drivers. the trace does not tell us which > drivers are responsible for the errors. > > all connection are to the database server which resides on a local > network, all connections as defined in tnsnames.ora are TCP. all host > resolutions are using HOSTS file > > this is why the BEQ protocol you see in the sqlnet.log file is a > mystery. as I said, I happened on an old post that stated the same: > they were using only TCP connections, but saw these errors in > sqlnet.log > > DB server uses dedicated server technology, version 9.2.0.5 > > do you want me to post the trace files? these are VERY large, and I > said before I see no error message at all. all I "see" is a break of > between few seconds to almost a minute in which there is no recorded > activity, as opposed to normal which is ~2500 lines/second (trace level > 6). these breaks match the time at which the web server is not > responsive I think you could spend a lot of time playing with this or just open a TAR at metalink. Were it me I'd try a SQL*Plus connection from the client and run the same code and see what happens. That would indicate whether the issue is the database or your client and its connection: I suspect the later. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)