Re: Famous End-of-File on Channel

Gerold Krommer wrote:

> Wow. My second post in 2 days. I think I'm getting hyperactive.
>
> We have written an web app using ASP pages (IIS), that accesses an Oracle
> 8.1.7 database on HPUX 11i using ADO/ODBC.
> Oracle client SW was (see below) 8.1.7
>
> We have a problem, where several times a day we cannot connect to the
> database. The error ist the famous 3113 (I believe) EOF on channel.
> It does this intermittantly to different users. While one cannot connect,
> the person on the next PC can (with the same oracle user or another). The
> only way to fix this is to restart IIS, then it runs for a while.
>
> We saw some bugs mentioned in various articles. So we changed the ODBC
> driver from Oracle to MS and we installed the latest patchset, bringing the
> Oracle client SW to 8.1.7.4.
> Subjectively,this reduced the frequency of the problem a little bit, but it
> is still occurring 2-3 times a day.
>
> I'm absolutely out of clues on how to chase this further.
>
> Any ideas ?
>
> /Gerold (g.krommer_at_doremove.fns.co.at)

ORA-03113 is almost always Oracle's way of telling you that whoever installed Oracle didn't read and follow the instructions on the CD.

Either get them off the CD or get them from http://docs.oracle.com and go into SAM. There ... verify the kernel parameters related to shared memory and semaphores.

If that isn't it get back to us. If it is then revisit the rest of the installation instructions that weren't followed to avoid other problems.

Daniel Morgan Received on Wed Dec 11 2002 - 12:28:07 CST