Re: recovering after Oracle shutdown

To clarify further, I am looking for a way to re-establish the database access once Oracle has been cycled (shutdown, then restarted). Naturally, during the downtime I don't expect Oracle to work, but I need to re-connect to it after it comes back up.

Paul

pretzelman wrote:

> Does anyone know how a ProC program can re-establish the DB connection
> when the Oracle database has been shutdown? I can detect this when I
> get an "ORA-03113 end-of-file on communication channel", and I have
> tried a variety of things, but nothing works so far.
>
> Right when I get the ORA-03113 error, I try a DISCONNECT, but this fails
> with a "ORA-01001 invalid cursor". This is sad, because I'm not even
> using any cursors for this DISCONNECT.
>
> The main question is, what are you supposed to do when you get an
> "ORA-03113 end-of-file on communication channel" error? Cycle the
> program? I hope we can do better than this.
>
> Any help is appreciated.
>
> Paul
Received on Wed Aug 02 2000 - 00:00:00 CDT