Oracle-L: RE: Unkillable Background process "SHUTDOWN ABORT LEAVES UNKILLAB

From: Miller, Jay <JayMiller_at_TDWaterhouse.com>
Date: Fri, 01 Nov 2002 12:21:28 -0800
Message-ID: <F001.004FA4E3.20021101122128@fatcity.com>

I had a similar problem once and it ended up being that a disk was in the process of starting to fail but hadn't completely failed (and therefore didn't fail over to the mirror).

This didn't show up in any Solaris logs until *after* the server had been rebooted, the database had been restarted and then the database was shut down again. We did see some aiowait errors in the alert log though.

Jay Miller

-----Original Message-----
Sent: Thursday, October 31, 2002 10:04 PM To: Multiple recipients of list ORACLE-L UNKILLABLE Hi all,

Jared you are right...

kill -9 #### successful but ps -ef |grep ora_ said the processes are still there (only LGWR and CKPT, the rest are die) when I try to startup again lk<SID> refuse to mount my database I guest Oracle not finished the housekeeping job.

when I try to "sync" the session hung (init will sync automatically therefore it hung too)
I have to POWER OFF and POWER ON my SUN BOX to release the mount point My sun clustering fail to fail over because of this

there is jargon in unix call zombie process (what is this ?) What is tampered process, and when it happen ?

Oracle Support said if shutdown abort can't kill the process is your OS problem not Oracle.
Why Oracle PMON and SMON never do anything about this ?

Sinardy

-----Original Message-----
Sent: 01 November 2002 06:40
To: Multiple recipients of list ORACLE-L UNKILLABLE I'm not new to Solaris or unix in general.

Rebooting to get rid of an unkillable process is not unheard of in unix land.

Jared

Brian_P_MacLean_at_eFunds.Com
Sent by: root_at_fatcity.com
10/31/2002 02:09 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Unkillable Background process "SHUTDOWN ABORT

LEAVES UNKILLABLE Reboot, Yeah-Right. This is Solaris, not Windoze.

I would try having the root user do the "kill -9" after doing a "truss" on the process it see what it's looking at. Doing a "ipcrm" on the shared memory segment and semaphores may also help.

Brian

                      Jared.Still_at_radis   
                      ys.com                   To:       Multiple 
recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 
                      Sent by:                 cc:    
                      root_at_fatcity.com         Subject:  RE: Unkillable

Background process "SHUTDOWN ABORT LEAVES UNKILLABLE

                      10/31/02 12:44 PM   
                      Please respond to   
                      ORACLE-L

Reboot and open a TAR.

Jared

"Sinardy Xing" <SinardyXing_at_bkgcomsvc.com> Sent by: root_at_fatcity.com
10/31/2002 12:28 AM
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

        cc:
        Subject:        RE: Unkillable Background process "SHUTDOWN ABORT

LEAVES UNKILLABLE
PROCESSES" Hi,

I am using solaris 8

Sinardy

-----Original Message-----
Sent: 31 October 2002 15:43
To: Multiple recipients of list ORACLE-L PROCESSES" Hi all,

When I do shutdown abort my LGWR and CKPT still around and also kill -9 cannot get rid of them anyone know why ?

because of this my cluster fail to failover

Thanks

Sinardy

--

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 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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: Sinardy Xing
INET: SinardyXing_at_bkgcomsvc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------