RE: Help, processes won't die

From: O'Neill, Sean <Sean.ONeill_at_organon.ie>
Date: Thu, 02 Aug 2001 22:52:33 -0700
Message-ID: <F001.0035D277.20010802025615@fatcity.com>

>> From: Ivan_Rivera_at_doh.state.fl.us
>> Date: Wed, 1 Aug 2001 12:01:40 -0400
>> Subject: Help, processes won't die
>>
>>I need some assistance ASAP. Our nightly batch process seems to have hung
>>up for some strange reason (ok no biggie my boss says kill it and start it
>>again). The problem is I have killed the processes both in oracle (sid,
>>serial#) and also in unix. Now I can't see the processes in unix but in
>>oracle they have a status of killed but are still holding the resources.
My
>>thinking is telling me the pmon is not waking up or not doing it's job.
How
>>can one manually tell a process to wake up. Any help will be greatly
>>appreciated.
>>
>>OS Solaris 7
>>Oracle 8.0.6.3

FWIW, this was posted to this list in Jan, and I can't tell you if this works or not as I've never had recourse to use it so if you care to roll the dice ;)

to wake up PMON:

SVRMGR>select pid from v$process p, v$bgprocess b where b.paddr = p.addr
and name='PMON';

PID

2
1 row selected

SVRMGR>oradebug wakeup 2

Sean :)

Rookie Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA

-------------------------------- ------------

Organon (Ireland) Ltd.
E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

"Nobody loves me but my mother... and she could be jivin' too." - BB King

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: O'Neill, Sean
  INET: Sean.ONeill_at_organon.ie

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 Fri Aug 03 2001 - 00:52:33 CDT