Re: Help - Can't shutdown database

workaround:
1. shutdown abort
2. startup and shutdown immediate

Allen wrote:

> After I do the shutdown immediate, it will tell me database shutdown and
> dismounted.. but it never returns from that until I manually kill the
> abandoned arc processes. Those are the only processes left running (except
> for the connection to svrmgrl). So ya at that point there are no
> connected users, no jobs, nothing..
>
> Any suggestions much appreciated.. This problem is really screwing up our
> attempts at automating cold backups.
>
> Allen
>
> In article <3AC18DE7.CBAEC9CC_at_exesolutions.com>,
> Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote:
> >> Oracle 8.1.7, Solaris 7. I'm in svrmgrl, issuing the 'shutdown immediate'
> >> command..and the database never finishes shutting down. I have to
> >> manually kill some abandoned arc processes, ie:
> >>
> >> oracle 22736 1 0 Mar 22 ? 0:05 ora_arc5_prod1
> >> oracle 22739 1 0 Mar 22 ? 0:04 ora_arc6_prod1
> >> oracle 18631 1 0 Mar 21 ? 0:06 ora_arc4_prod1
> >>
> >> After I manually kill these procs then the database finishes shutting
> >> down. This is making it difficult to automate the cold backups. Any help
> >> much appreciated...
> >
> >Killing enough processes will always shut things down. Sometimes in an ugly
> >way.
> >
> >Have you verified that you have no connected users?
> >
> >Have you looked at what jobs may be executing inside of the database?
> >
> >Daniel A. Morgan
> >
  Received on Sat Mar 31 2001 - 08:46:16 CST