Message-Id: <10522.108263@fatcity.com> From: "Elliott, Patrick" Date: Thu, 8 Jun 2000 13:24:22 -0500 Subject: RE: Database Down, can you help??? 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@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 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@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@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@yahoo.com > > spaquette@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@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@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@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@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@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@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L