RE: Database hanging on startup

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Mon, 8 Jan 2001 13:46:02 -0500
Message-Id: <10735.126020@fatcity.com>

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-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of johnm9563_at_netscape.net
Sent: Monday, January 08, 2001 1:20 PM
To: Multiple recipients of list ORACLE-L Subject: Database hanging on startup

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). Received on Mon Jan 08 2001 - 12:46:02 CST