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: Svend Jensen <Svend_at_OracleCare.Com>
Date: Tue, 18 Jun 2002 21:46:38 +0200
Message-ID: <3D0F8E1E.8090007@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 Tue Jun 18 2002 - 14:46:38 CDT

Original text of this message

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