recovering after Oracle shutdown

From: pretzelman <pretzelman_at_fakeaddress.com>
Date: 2000/08/02
Message-ID: <E20B5AA1606C488D.B4A1564FA9283400.9943969848156646@lp.airnews.net>#1/1

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