Re: Shutdown of one instance takes about 1hr

From: Digeratus 2006 <digeratus2006_at_nospam.hotmaildotcom>
Date: 03 Feb 2007 15:57:44 GMT
Message-ID: <Xns98CC70D092DC9digeratus2006@63.218.45.20>

Alexander Skwar <alexander_at_skwar.name> wrote in news:4hybr9sd2wl2.dlg_at_std.dialog.schweiz.digitalprojects.com:

> Digeratus 2006 <digeratus2006_at_nospam.hotmaildotcom>:
>

>> As the others have said, "shutdown immediate" is your first step.  

>
> Well, yeah, but I'd like to know why all the other databases,
> which are basically identical to the the RACEREF1 (RACE Reference),
> shutdown fine.
>

>> It looks like something is interrupting the shutdown of "RACEREF1".  
>> Without more details, it is difficult to say what is happening.

>
> How can I get more details? Those are plain normal databases. They
> do make use DBLINKS - pointing to themselves, if I understood the
> developers correctly.
>
>
> Alexander Skwar

My scripts do a

sqlplus "/ as sysdba" >>$TRACE_FILE <<EOF select * from V$SESSIONS;
EOF UNIX
ps -ef|grep -i $ORACLE_SID >>$TRACE_FILE

Andy Young Received on Sat Feb 03 2007 - 09:57:44 CST