Hi,

Each evening, when I shutdown my database for cold backup I have the
following:

ORA-00604: error occurred at recursive SQL level 1
ORA-01089: immediate shutdown in progress - no operations are permitted
ORA-00604: error occurred at recursive SQL level 2
ORA-01089: immediate shutdown in progress - no operations are permitted

I tried to find the active sessions just before the shutdown but nothing
other my own request.

How this can be ? any hints ?

Thanks in advance

Oracle 8.1.7.4
AIX 5.2

"zeb" <spam@nowhere.com> a écrit dans le message de news:4229d4d8$0$31849$636a15ce@news.free.fr...
| Hi,
|
| Each evening, when I shutdown my database for cold backup I have the
| following:
|
| ORA-00604: error occurred at recursive SQL level 1
| ORA-01089: immediate shutdown in progress - no operations are permitted
| ORA-00604: error occurred at recursive SQL level 2
| ORA-01089: immediate shutdown in progress - no operations are permitted
|
| I tried to find the active sessions just before the shutdown but nothing
| other my own request.
|
| How this can be ? any hints ?
|
| Thanks in advance
|
| Oracle 8.1.7.4
| AIX 5.2
|

Haven't you a database trigger on shutdown?

Regards
Michel Cadot

>
> Haven't you a database trigger on shutdown?
>
> Regards
> Michel Cadot

Thanks for the answer,
I have only logon/logoff triggers
Any ideas ?

Do you have enterprise manager or 'intelligent' agent running on the
machine?

> Do you have enterprise manager or 'intelligent' agent running on the
> machine?
Thanks for the answer ...
I have no intelligent agent and no OEM

zeb wrote:
> > Do you have enterprise manager or 'intelligent' agent running on
the
> > machine?
> Thanks for the answer ...
> I have no intelligent agent and no OEM

Any jobs scheduled through dbms_job?


David Fitzjarrell

check for trace files in /bdump and /udump.
if its due to SNPn processes (dbms_jobs) they should dump trace in
/bdump.

if you really want a clean shutdown prior to a cold backup, I'd suggest


alter system switch logfile
shutdown abort
startup mount restrict
alter system set job_queue_processes=0
alter database open
shutdown immediate

In general, I find cold backups to be a pain, unless you're talking
about a DW running in noarchivelog mode.

I'd rather just use a hot physical backup, copy the online redo logs
and controlfiles + any archlogs and call that a cold backup set - like
prior to applying a patchset. Less downtime, one set of scripts to
maintain.

-bdbafh

>
> Any jobs scheduled through dbms_job?
>
> David Fitzjarrell

Thanks
No dbms_job
but I have some MV log for remote replication
maybe a refresh is occuring during shutdown ?

zeb wrote:

>>Any jobs scheduled through dbms_job?
>>
>>David Fitzjarrell
>
>
> Thanks
> No dbms_job
> but I have some MV log for remote replication
> maybe a refresh is occuring during shutdown ?

And since no-one has mentioned it yet ... how about AQ?
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

> And since no-one has mentioned it yet ... how about AQ?

Simplify things - what Oracle processes ARE running when you try to shut
the instance?

FGB