Don't mess with shared memory or the sgadef.ora file. Just issue a =
shutdown
abort. =20
> -----Original Message-----
> From: Sandeep Dubey [SMTP:sandeep.dubey_at_induscorp.com]
> Sent: Thursday, June 08, 2000 12:03 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Database Down, can you help???
>=20
> You should be having a file sgadef.ora. Remove better rename this =
file and
> start the instance. Let me know if it works.
> It worked for me once.
>=20
> Sandeep
>=20
> -----Original Message-----
> Sent: Thursday, June 08, 2000 11:57 AM
> To: Multiple recipients of list ORACLE-L
>=20
>=20
> 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.
>=20
> 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
>=20
> > -----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
> > also send the HELP command for other information (like =
subscribing).
> --=20
> Author: Cole, Bill
> INET: bcole_at_lsfi.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
> Author: Sandeep Dubey
> INET: sandeep.dubey_at_induscorp.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
Received on Thu Jun 08 2000 - 13:24:22 CDT
