Re: RE: RE: Database hanging on startup

db block size 16384
log buffer 32768

Went thru all init paramters already . Not getting Roll back errors No errors at all Just won't open

ORACLE-L_at_fatcity.com wrote:
>
> 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-----
> johnm9563_at_netscape.net
> Sent: Monday, January 08, 2001 2:34 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> >
> __________________________________________________________________
> 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).