RE: Database Down, can you help???

That is what we did. Thanks for the quick response. Then, I killed the 1850 oracle user processes that were no longer attached to the database, and we are now OK.

Oracle has the log and trc files and owes me some explanation as to why this happened and what that ORA-00600 means.

Thanks again for the help. As always, the list comes through!

Steve Monaghan

> -----Original Message-----
> From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
> Sent: Thursday, June 08, 2000 9:56 AM
> To: Steve.Monaghan_at_wcom.com
> Subject: Re: Database Down, can you help???
>
>
> I am sending this directly because it will be faster.
> Try a shutdown abort, the startup exclusive, shutdown normal or immediate,
> followed by a startup. If any of your processes crashed it may have left
> the database in a mount or nomount state. Using this sequence
> should get it
> going again.
>
> If you need more, just let me know!
> Ruth B. Gramolini
> ORACLE DBA
> VT Dept. of Taxes
> ph# 802.828.5708
> fax# 802.828..3754
> rgramolini_at_tax.state.vt.us
> ----- Original Message -----
> From: Steven Monaghan <Steve.Monaghan_at_wcom.com>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent: Thursday, June 08, 2000 10:08 AM
> Subject: Database Down, can you help???
>
>
> > I have this error in the alert log (7.3.2.1.0 on AIX):
> > ORA-00600: internal error code, arguments: [3382], [1], [134231590],
> > [134235708], [], [], [], []
> >
> > After that, there are other errors and my instance has shut
> down. ps -ef
> > shows no processes for the database instance running. When I
> open svrmgr
> I
> > get the following:
> >
> > SVRMGR> connect internal
> > Connected to an idle instance.
> > SVRMGR> shutdown immediate
> > ORA-01012: not logged on
> > SVRMGR> startup
> > ORA-01081: cannot start already-running ORACLE - shut it down first
> > SVRMGR>
> >
> > I have opened a TAR, but have no resolution yet! Any ideas would be
> really
> > appreciated.
> >
> > Steve Monaghan
> > Worldcom
> >
> > --
> > Author: Steven Monaghan
> > INET: Steve.Monaghan_at_wcom.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).
Received on Thu Jun 08 2000 - 09:07:55 CDT