Re: Oracle Errors ORA-03113 and ORA-01041

An ORA-3113 usually means that the server has died. The ORA-1041 occurs because the client process has lost communications with the server.

This is most likely a bug. The server should not be crashing. Contact Oracle Support. They should be able to help you figure out what's going on.

                                   Rick

craig_at_ina.com.au (Craig Read) writes:

> Hi Everyone,
>
> I hope somebody can help me with these errors. Sorry for
> cross-posting to non-Delphi news groups but I'm at a loss to why this
> is happening.
>
> I have a Delphi 4.0 client (with the latest updates including BDE
> 5.10) communicating with Oracle 8i. Everything was fine up until
> today. :( Then I came in and our tester showed me the following
> messages coming up on his screen.
>
> ===================================================================
> "Lost communication with SQL server. ORA-03113: end-of-file on
> communication channel."
>
> followed by
>
> "General SQL Error. ORA-01041: internal error. hostdef extension
> doesn't exist."
> ===================================================================
>
> At first, I thought it must be something with his config. So I tested
> it on my machine. And guess what, I have exactly the same problem. :(
>
> The program was using a stored procedure to return a ref cursor from a
> view. That was pretty slow, so I spent most of the day converting it
> to query the tables directly by creating the SQL dynamically at the
> Delphi. Still no go!
>
> I then tried running the SQL for the original view (which is big and
> has 4 unions) and got the same error.
>
> Please email & post any suggestions as I'd like to fix this ASAP!
> Email will get to me quicker.
>
> Thanks in advance,
>
> Craig Read...
 

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

       The statements and opinions expressed here are my own and do not
             necessarily represent those of  Oracle Corporation.