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
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/31/2002 02:09 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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@radis
ys.com To: Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent by: cc:
[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/31/2002 12:28 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Miller, Jay
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
