Re: Funny one - Crash!

From: Howard Latham <howard.latham_at_gmail.com>
Date: Thu, 14 Nov 2013 16:21:57 +0000
Message-ID: <CAPCNhx2EK6XxW_3hGeKJgopO+RGpXABB4bDQiTNUHSfT9Vwu9Q_at_mail.gmail.com>

Follow up. We had OOM (Out Memory Killer ) disabled as it was killing vital oracle processes. With this enabled it kicked in and kill a process rather than the box crashing. This made some experimentation easy. The crash only happens on one file system if the file is more than 18g After a bit of rejigging DB is running fine on alternative FS and the culprit FS is doing a grand job as a scratch pad. Not a solution exactly but a happy end!

On 25 October 2013 17:38, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> Or are you just reaching the bad sectors on your eight year old drives at
> somewhere over 12 g and below 16 g, and perhaps the OS version does not do
> well with i/o failures?
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Powell, Mark
> Sent: Friday, October 25, 2013 11:42 AM
> To: howard.latham_at_gmail.com; ORACLE-L
> Subject: RE: Funny one - Crash!
>
> Howard, what version of Redhat? What kind of disk are the data files
> assigned to? Is an LVM in use? Have you verified the file definitions in
> the LVM?
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Howard Latham
> Sent: Friday, October 25, 2013 11:24 AM
> To: ORACLE-L
> Subject: Funny one - Crash!
>
> Oracle 11.2
> Redhat enterprise Linux
> One of My 8 Year old Redhat LInux Servers keeps crashing every time I add
> an
> 18gig datafile to a tablespace. It 'goes' away and has to be powered off
> and
> on to get it back.
> And when I tried adding 4 gig files it crashed on the 4th! Its probably
> going to be a hardware investigation but I just wondered if any internals
> gurus thought it might be Disk or Memory that is going pop or something
> else?
> - Is a datafile create working the disk control hard?
> or Working memory hard? - less likely?
>
>
> --
> Howard A. Latham
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Howard A. Latham

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 14 2013 - 17:21:57 CET