Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
do
echo "Killing process ${v_PID}" kill -9 ${v_PID}
do
echo "Killing process ${v_PID}" kill -9 ${v_PID}
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
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
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).Received on Tue Aug 13 2002 - 07:53:23 CDT