Re: not able to shutdown the database, detached processes to terminate

From: Yong Huang <yong321_at_yahoo.com>
Date: 15 Sep 2004 09:37:38 -0700
Message-ID: <b3cb12d6.0409150837.1872de59@posting.google.com>

yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0409141832.31024c3_at_posting.google.com>...
> joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0409131256.3e661eba_at_posting.google.com>...
> >
> > Did you get anything in udump?
> >
> > jg
>
> i get the below
>
> "SHUTDOWN: waiting for detached processes to terminate."
>
> in my alert and trace files. And this happened again today.

Joel asked you if you see anything in udump. Please answer.

When you see that error in alert.log, can you still login as sysdba? If so, what're the sessions in the database? (select * from v$session where type = 'USER') Do you have a dbsnmp or any type of OEM connections? Try stopping all Oracle-related services before you shutdown the database service.

In any case, you can always shutdown abort to do back up. Just make sure you bring up the database one more time and shutdown cleanly.

Yong Huang Received on Wed Sep 15 2004 - 11:37:38 CDT