Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Down, can you help???

RE: Database Down, can you help???

From: Cole, Bill <bcole_at_lsfi.com>
Date: Thu, 8 Jun 2000 10:41:58 -0400
Message-Id: <10522.108222@fatcity.com>


You've got one of two things wrong:
1. An sga file left lying around in $ORACLE_HOME/dbs that is = interpreted as
meaning the instance is up
2. There's a shared memory key that hasn't been released.

Do an "ipcs -a" . Do you see anything owned by Oracle? If so, delete = it
(using "ipcrm" and the appropriate keys) -- after you make sure that no other Oracle instances are running. This happens occasionally and is a bugger to find/fix.
HTH,
/Bill

> -----Original Message-----
> From: paquette stephane=20
> Sent: Thursday, June 08, 2000 11:15 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Database Down, can you help???

>=20

> Try a shutdown abort then a startup.
>=20

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

> --- Steven Monaghan <Steve.Monaghan_at_wcom.com> a
> =E9crit : > 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).
>=20
>=20

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

> __________________________________________________
> 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
>=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
Received on Thu Jun 08 2000 - 09:41:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US