Re: Shutdown Abort Damages Database!

On Tue, Aug 13, 2002 at 06:13:27AM -0800, Robertson Lee - lerobe wrote:
> Bloody compaq

HP

> Grrrrr !!!
>
> -----Original Message-----
> Sent: 13 August 2002 14:43
> To: Multiple recipients of list ORACLE-L
>
>
> Maybe it's only available on some platforms. I'm on Solaris and its there
> in $ORACLE_HOME/bin from 8.1.5 up.
>
> HTH
> David
>
> > -----Original Message-----
> > From: Robertson Lee - lerobe [mailto:lerobe_at_acxiom.co.uk]
> > Sent: 13 August 2002 13:53
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Shutdown Abort Damages Database!
> >
> >
> > Just going over some old messages.
> >
> > According to the article mentioned below, this utility was
> > introduced at
> > 8.1.5.
> >
> > I have 8.1.7 installed and there is no sign of it. Am I
> > missing something
> > here ??
> >
> > Regards
> >
> > Lee
> >
> >
> >
> > -----Original Message-----
> > Sent: 07 August 2002 23:16
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Brian,
> >
> > The real gem here is sysresv.
> >
> > I've never heard of it til now.
> >
> > It's documented on MetaLink in Note 123322.1, and is
> > the result of an enhancement request stemming
> > from a bug.
> >
> > Thanks!
> >
> > Jared
> >
> >
> >
> >
> >
> > Brian_P_MacLean_at_eFunds.Com
> > Sent by: root_at_fatcity.com
> > 08/06/2002 05:40 PM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: Re: Shutdown Abort Damages Database!
> >
> >
> >
> > In my testing a shutdown abort always cleaned up the IPC resources.
> >
> > I have had situations where the database was completely hung
> > (even svrmgrl
> > hung) and a "kill -9" on all db processes including
> > smon/pmon/etc. was the
> > only resolution, therefore I had to execute the "ipcrm"
> > commands to clean
> > things up.
> >
> > This is a little korn shell jewel called OKILL that will kill all
> > sessions,
> > background processes, and IPC resources selectively. I keep it as a
> > function in my .profile file. The function requires that your Oracle
> > environment be set and that the "OKILL -s ORACLE_SID" option
> > passed be the
> > same. An example run follows the function definition.
> >
> > function OKILL
> > {
> > OPT_s="?"
> > while getopts s:h option
> > do
> > case "${option}"
> > in
> > s) OPT_s="${OPTARG}";;
> > h | \?) echo "usage: OKILL [-h] -s ORACLE_SID";return;;
> > esac
> > done
> > if [ "${OPT_s}" = "?" ]
> > then
> > echo "usage: OKILL [-h] -s ORACLE_SID";return
> > elif [ "${OPT_s}" != "${ORACLE_SID}" ]
> > then
> > echo "Passed -s database (${OPT_s}) must match your current
> > environment
> > database (${ORACLE_SID})"
> > else
> > typeset -u ANS
> > echo "\nAbout to kill all sessions connected to database ${OPT_s}"
> > read ANS?"Do you wish to continue (y/n): "
> > if [ "${ANS}" = "Y" ]
> > then
> > ps -ef | grep oracle${OPT_s} | grep -v grep | awk
> > '{printf ("%s\n",
> > $2)
> > }' | while read v_PID
> > do
> > echo "Killing process ${v_PID}"
> > kill -9 ${v_PID}
> > done
> > echo "All sessions are now terminated"
> > else
> > :
> > fi
> > echo "\nAbout to kill all background processes connected to database
> > ${OPT_s}"
> > read ANS?"Do you wish to continue (y/n): "
> > if [ "${ANS}" = "Y" ]
> > then
> > ps -ef | grep ora_...._${OPT_s} | grep -v grep | awk
> > '{printf ("%s\n",
> > $2) }' | while read v_PID
> > do
> > echo "Killing process ${v_PID}"
> > kill -9 ${v_PID}
> > done
> > echo "All background processes are now terminated"
> > else
> > :
> > fi
> > echo "\nAbout to remove all IPC resources associated with database
> > ${OPT_s}"
> > read ANS?"Do you wish to continue (y/n): "
> > if [ "${ANS}" = "Y" ]
> > then
> > $ORACLE_HOME/bin/sysresv | egrep -v "^$|^ID|^IPC|^Oracle"
> > | while read
> > v_FIELD1 v_FIELD2
> > do
> > if [ "${v_FIELD1}" = "Shared" ]
> > then
> > SW=Shared
> > elif [ "${v_FIELD1}" = "Semaphores:" ]
> > then
> > SW="Semaphores:"
> > elif [ "${SW}" = "Shared" ]
> > then
> > echo "Removing Shared Memory segment ${v_FIELD1}"
> > ipcrm -m ${v_FIELD1}
> > elif [ "${SW}" = "Semaphores:" ]
> > then
> > echo "Removing Semaphore set ${v_FIELD1}"
> > ipcrm -s ${v_FIELD1}
> > else
> > :
> > fi
> > done
> > echo "All IPC resources are now removed"
> > else
> > :
> > fi
> > fi
> > }
> >
> >
> > 11066:oracle7_at_bart> psg SLXT
> > UID PID PPID C STIME TTY TIME CMD
> > oracle7 1190 1189 0 17:57:54 ? 0:00 oracleSLXT (DESCRIPTION
> > =(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
> > oracle7 12716 1 0 23:02:51 ? 0:00 ora_pmon_SLXT
> > oracle7 12718 1 0 23:02:51 ? 0:01 ora_dbw0_SLXT
> > oracle7 12720 1 0 23:02:51 ? 0:01 ora_lgwr_SLXT
> > oracle7 12722 1 0 23:02:51 ? 0:20 ora_ckpt_SLXT
> > oracle7 12724 1 0 23:02:52 ? 0:05 ora_smon_SLXT
> > oracle7 12726 1 0 23:02:52 ? 0:00 ora_reco_SLXT
> >
> > 11066:oracle7_at_bart> sysresv
> > IPC Resources for ORACLE_SID "SLXT" :
> > Shared Memory:
> > ID KEY
> > 17 0xa315f930
> > Semaphores:
> > ID KEY
> > 196722 0x0e1d50f5
> > 115 0x0e1d50f6
> > 116 0x0e1d50f7
> > 117 0x0e1d50f8
> > 118 0x0e1d50f9
> > 119 0x0e1d50fa
> > 120 0x0e1d50fb
> > 121 0x0e1d50fc
> > 122 0x0e1d50fd
> > 123 0x0e1d50fe
> > 124 0x0e1d50ff
> > 125 0x0e1d5100
> > Oracle Instance alive for sid "SLXT"
> >
> > 11066:oracle7_at_bart> OKILL -s SLXT
> >
> > About to kill all sessions connected to database SLXT
> > Do you wish to continue (y/n): y
> > Killing process 1190
> > All sessions are now terminated
> >
> > About to kill all background processes connected to database SLXT
> > Do you wish to continue (y/n): y
> > Killing process 12716
> > Killing process 12722
> > Killing process 12720
> > Killing process 12726
> > Killing process 12724
> > Killing process 12718
> > All background processes are now terminated
> >
> > About to remove all IPC resources associated with database SLXT
> > Do you wish to continue (y/n): y
> > Removing Shared Memory segment 17
> > Removing Semaphore set 196722
> > Removing Semaphore set 115
> > Removing Semaphore set 116
> > Removing Semaphore set 117
> > Removing Semaphore set 118
> > Removing Semaphore set 119
> > Removing Semaphore set 120
> > Removing Semaphore set 121
> > Removing Semaphore set 122
> > Removing Semaphore set 123
> > Removing Semaphore set 124
> > Removing Semaphore set 125
> > All IPC resources are now removed
> > 11066:oracle7_at_bart>
> >
> >
> >
> >
> > "Post, Ethan"
> > <Ethan.Post_at_ps.ne To: Multiple
> > recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > t> cc:
> > Sent by: Subject:
> > Shutdown Abort
> > Damages Database!
> > root_at_fatcity.com
> >
> >
> > 08/06/02 03:08 PM
> > Please respond to
> > ORACLE-L
> >
> >
> >
> >
> >
> >
> > 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).
> >
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Brian_P_MacLean_at_eFunds.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).
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Jared.Still_at_radisys.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).
> >
> >
> > *********************************************************************
> >
> > The information contained in this communication is
> > confidential, is intended only for the use of the recipient
> > named above, and may be legally privileged.
> > If the reader of this message is not the intended
> > recipient, you are hereby notified that any dissemination,
> > distribution, or copying of this communication is strictly
> > prohibited.
> > If you have received this communication in error,
> > please re-send this communication to the sender and
> > delete the original message or any copy of it from your
> > computer system. Thank You.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Robertson Lee - lerobe
> > INET: lerobe_at_acxiom.co.uk
> >
> > 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robertson Lee - lerobe
> INET: lerobe_at_acxiom.co.uk
>
> 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).

-- 
===============================================================
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: stellr_at_cns.vt.edu

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).