Re: ora-01089 error

"Michael" <mo_sullivan_at_hotmail.com> wrote in message news:7EPq9.7816$cP3.16494_at_news.iol.ie...
> we have an oracle database and twice in the last 2 weeks it has crashed .
> the users ccome in in the morning and cannot log in. they recieve the
> following error 'ora-01089: immediate shutdown in progress - no operations
> are permitted'.If i look at the app logs on the server the only thing
there
> is that the tape unit timed out, but that is only because it runs a pre
job
> batch file to shutdown the database before it backs it up, so what i can
> figure is that it cannot shutdown the database so it therefoe cannot
proceed
> with the backup, the backup happens at 22:30 each night. But at 19:30 each
> night the oracle database is shutdown , and export of the data is done and
> then it is restarted.what i think is happening is the export is done, but
> for some reason the database is not restarted, so the backup at 22:30
cannot
> happen. The export log shows that the export is carried out successfully.
> According to our suppliers who took a copy of the oracle trace log the
last
> time [2 weeks ago] it happened the problem is not with oracle.
> If someone could point me in the direction of what to look at, logs etc to
> try to get to the root of the problem. the OS is NT4 fully patched and
> oracle 6i.

It looks as if your database isn't actually shutting down when the batch job issues a shutdown immediate. I would suspect that there's a long running process active in the database and that Oracle is still trying to roll it back the following morning when users try to log in again.

It would be worth looking at the active sessions before attempting to shut the database down (I've had shutdown problems in the past caused by distributed transactions).

Paul Dixon Received on Thu Oct 17 2002 - 06:17:47 CDT