Re: Database Down, can you help???

From: Rocky Welch <rockyw_99_at_yahoo.com>
Date: Thu, 8 Jun 2000 11:48:08 -0700 (PDT)
Message-Id: <10522.108268@fatcity.com>

Good point, Rachel (as always). Also check for an entry in the oratab file to see if it is correct/exists.

• Rachel Carmichael <carmichr_at_hotmail.com> wrote:
  > also make sure your ORACLE_SID is set...the 1012 on the connect internal
  >
  > looks like it does not know what sid you are trying to connect to
  >
  > Rachel
  >
  >
  > >From: paquette stephane <stephane_paquette_at_yahoo.com>
  > >Reply-To: ORACLE-L_at_fatcity.com
  > >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
  > >Subject: Re: Database Down, can you help???
  > >Date: Thu, 08 Jun 2000 07:14:36 -0800
  > >
  > >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
  > >é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).
  >
  > ________________________________________________________________________
  > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
  >
  > --
  > Author: Rachel Carmichael
  > INET: carmichr_at_hotmail.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).
  

  ---

Rocky Welch
Oracle DBA Consultant

rockyw_99_at_yahoo.com

---

Received on Thu Jun 08 2000 - 13:48:08 CDT