Usually a shutdown abort will take care of cleaning up
all the semaphores/shared memory segments. I have only
seen one case where it has not, and that was due to
someone killing the file where it stashes the
semaphore/shared memory ids. Without them, an abort
will not clean things up.
If your database crashes it may not have a chance to
clean up after itself. In these instances, a shutdown
abort if the simple way to clean everything up before
restarting.
Bill
- "Lord, David - CSG" <David.Lord_at_hayscsg.com>
wrote:
> Occasionally, on some of our 8.1.6 dev instances, we
> get masses of ORA 600's
> and 7445's that lead to pmon crashing and the
> database hanging - mainly due
> to one bug or another. I may be having a senior
> moment, but I think I have
> had to do a shutdown abort on at least one of these
> occasions.
>
> Sometimes, this leaves shared memory and semaphores
> hanging around. ipcs
> will show you the resources, but if there are a
> number of instances on the
> box, it is difficult to identify the right ones to
> kill. sysresv (in
> $ORACLE_HOME/bin) on the other hand will show you
> the resources for the
> instance set in your oracle environment. As others
> have said, you can then
> use ipcrm to remove the offending resources.
>
> Regards
> David Lord
>
> > -----Original Message-----
> > From: Post, Ethan [mailto:Ethan.Post_at_ps.net]
> > Sent: 06 August 2002 23:09
> > To: Multiple recipients of list ORACLE-L
> > Subject: Shutdown Abort Damages Database!
> >
> >
> > OK, that was bait, I admit it.
> >
> > So we all know that shutdown abort doesn't damage
> the
> > database. However, do
> > we have to ever worry about any UNIX shared memory
> segments
> > hanging out
> > there? I know we do if we end up having to kill
> the
> > background procs but is
> > this ever a case with shutdown abort?
> >
> > Also does anyone have some good step by step
> instructions for
> > cleaning up a
> > UNIX box after you kill the background procs?
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Post, Ethan
> > INET: Ethan.Post_at_ps.net
> >
> > 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).
> >
>
>
>
> This message (including any attachments) is
> confidential and may be
> legally privileged. If you are not the intended
> recipient, you should
> not disclose, copy or use any part of it - please
> delete all copies
> immediately and notify the Hays Group Email Helpdesk
> at
> email.helpdesk_at_hays.plc.uk
> Any information, statements or opinions contained in
> this message
> (including any attachments) are given by the author.
> They are not
> given on behalf of Hays unless subsequently
> confirmed by an individual
> other than the author who is duly authorised to
> represent Hays.
>
> A member of the Hays plc group of companies.
> Hays plc is registered in England and Wales number
> 2150950.
> Registered Office Hays House Millmead Guildford
> Surrey GU2 4HJ.
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Lord, David - CSG
> INET: David.Lord_at_hayscsg.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! Health - Feel better, live better
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bill Pass
INET: wbpass_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).
Received on Wed Aug 07 2002 - 17:15:57 CDT
