Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Intermittent connection problems from web servers to DB server
Yoram Ayalon wrote:
> we have several web servers, some win2K, some 2003 server, all running
> Oracle client 9.2.0.7, running against an Oracle 9.2.0.8 DB on Solaris.
>
> on a totally unpredictable basis, some of our web servers will refuse
> to talk to the DB server. The first call to the DB, which is a call to
> a stored proc, will fail with error
>
> Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
> [Microsoft][ODBC driver for Oracle][Oracle]ORA-20004
>
> and after a reset of the IIS everything works fine. At the same time
> other web servers are not impacted. All web servers have the same
> version of MDAC.
>
> On the DB server, I see no error in the alert file, or sqlnet log file
> on the web servers, I see no errors in sqlnet.log
>
>
> any ideas ?
Metalink Note:216912.1 describes how to do ODBC and sql*net tracing.
An interesting comment: "ODBC tracing may work intermittantly. If
this is the case you can try reinstalling Microsoft's Data Acces
Components (MDAC) from
http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp
and the reboot the computer. "
You don't see errors in those logs because it is considered an application error to be handled by the application.
jg
-- @home.com is bogus. Good afternoon, Mr. Orwell. "This is a new standard of 'Don't bother us with the facts'...It looks like what you would end up with after a two-beer, two-hour conference. " - Franklin Zimring, about California Proposition 83, which includes lifetime GPS tracking of sex offenders.Received on Fri Nov 03 2006 - 18:27:51 CST