Re: Intermittent SQLNET errors

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

.

Relevant Pages

  • Re: IIS and Licensing question
    ... >Clients connecting via anonymous HTTP only do not need ... Windows Server CALs. ... >> buy addt'l licenses of some kind for users connecting to ...
    (microsoft.public.inetserver.iis.security)
  • Catastrophic Failure (8000ffff)
    ... We have a Windows 2003 Server acting as a web server and connected using an ... ODBC to a Windows 2000 server with an Oracle DB. ... The ODBC connecting is using ...
    (microsoft.public.data.odbc)
  • Numerics in the schema become strings in Ruby using ODBC to MS SQL 2000
    ... remote MSSQL2000 server using ODBC. ... preventing it from connecting when the application is executed remotely ...
    (microsoft.public.data.odbc)
  • Re: programme on a network
    ... but the OP mentioned he wanted to run a 'program' on a server. ... I was reading that the main thing was connecting all clients to ... Using ODBC he can hardcode the connection, and setup the ODBC name the same ...
    (microsoft.public.vb.general.discussion)
  • Re: Forms authentication - change password
    ... Contact the server administrator. ... I think your authentication validation method needs to be set to ... the change password feature within ISA ... | | meant not connecting to a Global Catalog. ...
    (microsoft.public.isa)