Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Database hanging on startup
So you decreased it and it isn't working? Or is it now working. Did you
check to ensure that the log_buffer is a multiple of the block size? If
that doesn't work, whoo, one of these other brains will have to answer this
one.
Kev
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of
johnm9563_at_netscape.net
Sent: Monday, January 08, 2001 2:34 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: Database hanging on startup
Platform SGI irix 6.5.5
Oracle EE 8.1.5 64bit
Decreased amount of SGA from 40mb to 20mb
ORACLE-L_at_fatcity.com wrote:
>
> What platform and what version? Did you check your calculations for the
SGA
> in the init.ora file, if they are off it probably will hang, happened to
me
> once.
> Kev
>
> -----Original Message-----
> johnm9563_at_netscape.net
> Sent: Monday, January 08, 2001 1:20 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi:
>
> We have a dev instance that upon issuing a alter database open ; command
> the process just hangs . There is no messages in the alert log; no Trace
> files in bdump, udump or cdump. Metalink has been no help!!. We have
tried
> starting this db from a backup controlfile, startup force, recover
database,
> startup restrict everything We try hangs.
> We are running in noarchive log mode.
> We appear to have enough memory as we are not paging.
> I would open Tar with Oracle but development databases are pushed back
days.
>
> any ideas would be greatly appreciated
>
> Thanks
>
> John McCabe
>
>
>
> __________________________________________________________________
> Get your own FREE, personal Netscape Webmail account today at
> http://webmail.netscape.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: johnm9563_at_netscape.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
> INET: kevin_at_dulcian.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: johnm9563_at_netscape.net Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Mon Jan 08 2001 - 13:43:16 CST