Re: Database Down, can you help???

Absolutely correct solution !!

• Chuck Hamilton <chuck_hamilton_at_yahoo.com> wrote:
  >
  > Sounds like the shared memory segment didn't get
  > deleted. As Stephane said, the first thing to try
  > and do is a shutdown abort. 9 out of 10 times
  > that'll delete it. If it doesn't, find the shared
  > memory segment with "ipcs -ma" and look for segments
  > owned by oracle. If you only have one instance you
  > should only have one shared memory segment. You can
  > delete it with "ipcrm -m shmid". If you have more
  > than one instance it's a little more difficult. You
  > can determine the shmid of the other instances that
  > are still running by going into svrmgrl, connecting
  > internal, and entering "oradebug ipc". Look for the
  > Shmid in the output (on the screen for 7.x, in a
  > tracefile for 8i) and right down that number. Do the
  > same for each running instance then go back to the
  > ipcs -ma listing and delete the shared memory
  > segment that doesn't belong to any of the other
  > instances.
  >
  > If you still can't start the database, and it's a
  > 7.x instance, look in $ORACLE_HOME/dbs for a file
  > named sgadef${ORACLE_SID}.dbf and delete it. Then
  > try again.
  >
  >
  >
  > paquette stephane wrote:
  >
  > 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 a
  > écrit : > 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).
  >
  >
  > =====
  > 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
  > --
  > Author: =?iso-8859-1?q?paquette=20stephane?=
  > 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
  > also send the HELP command for other information
  > (like subscribing).
  >
  >
  >
  >
  > ---------------------------------
  > Do You Yahoo!?
  > Yahoo! Photos -- now, 100 FREE prints!
  

  ---