Re: ERROR 3113 trying to connect OR805 using Pro*c code

"Billy Verreynne" <vslabs_at_onwe.co.za> writes:

> UserAshish wrote in message
> <19990622231611.18004.00004316_at_ng-fr1.aol.com>...
> >we are trying to connect to a Or805 server using pro*c embeded SQL .
>
> Ouch..
>
> EOF on comms channel is a dirty one with no clear cut answers to why it
> occurs and how to solve it. Have experienced it myself and had it
> mysteriously disappear again.
>
> The only thing I can suggest is to change from an IPC connection (if you are
> connecting to a local database) to a TCP/IP (i.e. listener) connection. That
> was one of the tricks that worked for me to circumvent the problem on one
> occasion.

Another possibility is that the Oracle server died unexpectedly. Take a look in the RDBMS log directory. If there are trace files there, they may contain stack dumps showing the problem. On Unix, there may be core dumps in the dbs directory.

If you find one or the other, I suggest that you contact Oracle support. This problem may already have a fix for it.

--

                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com