RE: Database Down, can you help???

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Thu, 08 Jun 2000 08:16:52 -0700
Message-Id: <10522.108230@fatcity.com>

If Stephane's method does not work, and you have verified that Oracle = SID
is set correctly, try rebooting the server after shutting the database down. I've run into a similar situation and that was the only thing = that
cured it.=20

When you first had the problem, did you check for the existence of the$ORACLE_HOME/dbs/sgadef<SID>.dbf file? It should not be there for a shutdown database.=20

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu
-----Original Message-----
From: paquette stephane [mailto:stephane_paquette_at_yahoo.com] Sent: Thursday, June 08, 2000 8:15 AM
To: Multiple recipients of list ORACLE-L Subject: Re: Database Down, can you help???

Try a shutdown abort then a startup.

About support, if it is a production database tell them, it's supposed to be their top priority.

• Steven Monaghan <Steve.Monaghan_at_wcom.com> a =E9crit=A0: > 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], [], [], [], []
  >=20
  > 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:
  >=20
  > 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>
  >=20
  > I have opened a TAR, but have no resolution yet!=20
  > Any ideas would be really
  > appreciated.
  >=20
  > Steve Monaghan
  > Worldcom
  >=20
  > --=20
  > Author: Steven Monaghan
  > INET: Steve.Monaghan_at_wcom.com
  >=20
  > 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).
  

=3D=3D=3D=3D=3D
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50

---

Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
http://photos.yahoo.com
--=20
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D   INET: stephane_paquette_at_yahoo.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 Received on Thu Jun 08 2000 - 10:16:52 CDT