| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database Down, can you help???
--0-846930886-960480319=:23954
Content-Type: text/plain; charset=us-ascii
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.
--
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!
--0-846930886-960480319=:23954
Content-Type: text/html; charset=us-ascii
<P> 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.</P>
<P>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.<BR></P>
<P> <BR><B><I>paquette stephane <STEPHANE_PAQUETTE_at_YAHOO.COM></I></B>wrote: <BR>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><BR>Try a shutdown abort then a startup.<BR><BR>About support, if it is a production database tell<BR>them, it's supposed to be their top priority.<BR><BR><BR><BR>--- Steven Monaghan <STEVE.MONAGHAN_at_WCOM.COM>a<BR>écrit : > I have this error in the alert log<BR>(7.3.2.1.0 on<BR>> AIX):<BR>> ORA-00600: internal error code, arguments: [3382],<BR>> [1], [134231590],<BR>> [134235708], [], [], [], []<BR>> <BR>> After that, there are other errors and my instance<BR>> has shut down. ps -ef<BR>> shows no processes for the database instance<BR>> running. When I open svrmgr I<BR>> get the following:<BR>> <BR>> SVRMGR> connect internal<BR>> Connected to an idle instance.<BR>> SVRMGR> shutdown immediate<BR>> ORA-01012: not logged on<BR>> SVRMGR> startup<BR>> ORA-01081: cannot start already-running ORACLE -<BR>> shut it down first<BR>!
> SVRMGR><BR>> <BR>> I have opened a TAR, but have no resolution yet! <BR>> Any ideas would be really<BR>> appreciated.<BR>> <BR>> Steve Monaghan<BR>> Worldcom<BR>> <BR>> -- <BR>> Author: Steven Monaghan<BR>> INET: Steve.Monaghan_at_wcom.com<BR>> <BR>> Fat City Network Services -- (858) 538-5051 FAX:<BR>> (858) 538-5051<BR>> San Diego, California -- Public Internet<BR>> access / Mailing Lists<BR>><BR>--------------------------------------------------------------------<BR>> To REMOVE yourself from this mailing list, send an<BR>> E-Mail message<BR>> to: ListGuru_at_fatcity.com (note EXACT spelling of<BR>> 'ListGuru') and in<BR>> the message BODY, include a line containing: UNSUB<BR>> ORACLE-L<BR>> (or the name of mailing list you want to be removed<BR>> from). You may<BR>> also send the HELP command for other information<BR>> (like subscribing).<BR><BR><BR>=====<BR>Stephane Paquette<BR>DBA Oracle<BR!
>stephane_paquette@yahoo.com<BR>spaquette@houra.fr<BR>(33) 01 53 93 06 50<BR><BR>__________________________________________________<BR>Do You Yahoo!?<BR>Yahoo! Photos -- now, 100 FREE prints!<BR>http://photos.yahoo.com<BR>-- <BR>Author: =?iso-8859-1?q?paquette=20stephane?=<BR>INET: stephane_paquette@yahoo.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing). <BR></BLOCKQUOTE><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://photos.yahoo.com/">Yahoo! Photos</a> -- now, 100 FREE prints!
Received on Thu Jun 08 2000 - 11:05:19 CDT
 |
 |