Re: Intermittent connection problems from web servers to DB server

On Nov 3, 2:43 pm, "Yoram Ayalon" <yoram.aya..._at_structuredweb.com> wrote:
> Mark,
>
> thanks for the reply. not a typo. the error is 20004
>
> we have no user application that generates this error. I triple-checked
>
>
>
> Mark D Powell wrote:
> > On Nov 3, 11:37 am, "Yoram Ayalon" <yoram.aya..._at_structuredweb.com>
> > 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 ?
>
> > Unless you made a typo entering the error number the ORA-2004 should be
> > a user application issued error.
>
> > Do you have any database logon event triggers?
>
> > $ oerr ora 21000
> > 21000, 00000, "error number argument to raise_application_error of %s%s
> > is out of range"
> > // *Cause:
> > // *Action: Use an error number in the range of -20000 to -20999,
> > inclusive.
>
> > HTH -- Mark D Powell --- Hide quoted text -- Show quoted text -

Did the DBA check for database event logon triggers? VPD packages? Object methods?

HTH -- Mark D Powell -- Received on Fri Nov 03 2006 - 14:15:26 CST