Re: Database Down, can you help???

Take a look in $ORACLE_HOME/dbs and see if there is an .sga file leftover. Sometimes when a database crahes that gets left behind and consequently at startup it gets confused. Let me know if that works.

OK BYE Chris Royce

Steven Monaghan wrote:

> 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 - 10:20:58 CDT