Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01033

Re: ORA-01033

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 20 Jun 2002 18:58:12 +1000
Message-ID: <aes5g1$1p5$1@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 - 03:58:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US