Re: Oracle hangs while shutdown immediate

I used to see Oracle support did the following with success.

svrmgrl>alter system switch logfile;
svrmgrl>alter system switch logfile;
svrmgrl>alter system switch logfile;
svrmgrl>alter system switch logfile;
svrmgrl>alter system switch logfile;
svrmgrl>alter system switch logfile;
svrmgrl>alter system switch logfile;
svrmgrl>alter system switch logfile;
svrmgrl>shutdown immediate;

The following also works for me if there are any jobs running in the background.
1. ps -ef | grep ora

2. Find process ID for snpXXX

3. Find pid from V$process by spid

4. Find 'sid,SERIAL#' from V$session by pid

5. alter system kill session 'sid,SERIAL#'

6. In OS, kill - 9 spid

• Jack

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3EDE1F50.D2DEAC55_at_exxesolutions.com...
> Anton Dischner wrote:
>
> > Hi,
> >
> > Daniel, i forgot to say:
> >
> > We shut down all our programs which do mostly inserts and short queries.
> > Only emergengy laboratory is working at his time and they are aware of
> > the switch.
> > There is no activity for plenty of time (approx. 1 hour) til the
> > DBA is called.
> > The system is complete idle at this time.
> >
> > Vitaly:
> >
> > How do you do the 'dump state of all sessions' ?
> >
> > Regards,
> >
> > Toni
>
> If you can verify that there are no connected users and no jobs running
> internally such as those kicked off by DBMS_JOB then I'd go with Connor's
> suggestion.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>
Received on Wed Jun 04 2003 - 12:24:24 CDT