SQL error during shutdown ..

[zeb]

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

[unknown]

"zeb" <***@nowhere.com> a écrit dans le message de news:4229d4d8$0$31849$***@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

[zeb]

Post by unknown
Haven't you a database trigger on shutdown?
Regards
Michel Cadot

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

[GreyBeard]

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

[zeb]

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

Thanks for the answer ...
I have no intelligent agent and no OEM

[f***@cox.net]

Post by zeb

Post by GreyBeard
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

[zeb]

Post by f***@cox.net
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 ?

[DA Morgan]

Post by zeb

Post by f***@cox.net
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?

[GreyBeard]

Post by DA Morgan
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

[DA Morgan]

Post by GreyBeard

Post by DA Morgan
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

And to simply further:

ps -ef | grep ora

Now we are just down to a cut and paste. ;-)

[zeb]

Post by DA Morgan

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

ps -ef | grep ora
Now we are just down to a cut and paste. ;-)

Thanks for your answer..
processes using CPU, something like top ?

[Dave]

Post by zeb

Post by DA Morgan

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

ps -ef | grep ora
Now we are just down to a cut and paste. ;-)

Thanks for your answer..
processes using CPU, something like top ?

no, the output of the command that was given

[DA Morgan]

Post by zeb

Post by DA Morgan

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

ps -ef | grep ora
Now we are just down to a cut and paste. ;-)

Thanks for your answer..
processes using CPU, something like top ?

The correct answer was handed to you on a silver platter?
What are you charging off in some other direction?

[b***@gmail.com]

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