Was it really. That makes idealistic,cynical and just plain wrong all in one
morning. Ho hum.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:aes5g1$1p5$1_at_lust.ihug.co.nz...
> (Er, Transactional was an option in 8.0)
>
> Regards
> HJR
>
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3d103e14$0$8513$ed9e5944_at_reading.news.pipex.net...
> > I'd missed the i in 8i. You are quite correct of course. My apologies.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> >
> > ******************************************
> > "Svend Jensen" <Svend_at_OracleCare.Com> wrote in message
> > news:3D0F8E1E.8090007_at_OracleCare.Com...
> > > Niall Litchfield wrote:
> > >
> > > > "Terry Wallace" <twallace_at_NoSPAMActic.com> wrote in message
> > > > news:3d0f6b40$0$3201$724ebb72_at_reader2.ash.ops.us.uu.net...
> > > >
> > > >>Thank you for your help. I'm running Oracle 8i on an NT2000 server.
I
> > had
> > > >>
> > > > an
> > > >
> > > >>open connection with 9i client over the network when somebody did
> indeed
> > > >>shut down the server without informing me. Would this cause the
> problem?
> > I
> > > >>shut down and opened the database several times before I left it on
> over
> > > >>
> > > > the
> > > >
> > > >>weekend. If I understand your response correctly you are saying that
> > > >>
> > > > Oracle
> > > >
> > > >>cannot gracefully close it's sessions. Is this true?
> > > >>
> > > >>--
> > > >>Terry Wallace
> > > >>
> > > >
> > > > can I introduce you to the first answer in the oracle world. it
> depends.
> > > >
> > > > usually this means on version but this isn't true in this case.
> > > >
> > > > Oracle can shutdown in one of several modes
> > > >
> > > > abort. This is equivalent to a system crash - kills all sessions
> > including
> > > > system ones and necessitates (automatic) recovery on startup.
> > > > immediate. refuses new connections and rolls back existing ones.
This
> > takes
> > > > as long to achieve as the longest transaction takes to rollback and
so
> > is a
> > > > graceful but (possibly) longwinded shutdown.
> > > > normal. waits for all existing sessions (including those abandoned
by
> > the
> > > > user) to either commit or rollback. this could potentially take
> forever.
> > > >
> > > > I would suggest that you shutdown abort the instance by typing
> SHUTDOWN
> > > > ABORT; when connected as sysdba and then restart.
> > > >
> > > >
> > > > --
> > > > Niall Litchfield
> > > > Oracle DBA
> > > > Audit Commission UK
> > > >
> > > >
> > > Forgot the shutdown transactional.
> > >
> > > Refuses new transactions/connections.
> > >
> > > Waits for all active transactions to commit or rollback.
> > >
> > > When all trans are done - shut down.
> > >
> > > /Svend Jensen
> > >
> > >
> >
> >
>
>
Received on Thu Jun 20 2002 - 04:37:59 CDT
