Re: Oracle 9.2.0 Gentoo Linux - ORA 3113 on DB startup

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 11 Feb 2003 08:54:25 +1100
Message-Id: <pan.2003.02.10.21.54.25.384358@yahoo.com.au>

On Mon, 10 Feb 2003 22:13:12 +0100, Jasper wrote:

> Thanks for the answers guys.
>
> My answers :
>
> I've checked <all> kernel parameters. Rebooting would not be necessary
> because I
> can write the new params in /proc/sys/kernel and they will be effective
> immediately.
>
> Also tried the orarun9i script, no luck either.
>
> I've fiddled around with my init.ora, increasing/decreasing sga size,
> processes, etc, no luck.
>
> I'm using kernel 2.4.20 btw, what kernel version are you guys using ?
>

It works fine (sort of... see posts elsewhere for minor niggles) with 2.4.18 (Red Hat 8.0) and 2.4.19 (Mandrake). Certainly no 3113's.

With Red Hat, I had to make a minor adjustment that I'd never come across before (but that's only because I was a Windows user until the weekend!): namely, edit /etc/sysctl.conf and add the lines

# Shared memory limit
kernel.shmmax = 1073741824

I know you're not using Red Hat, but you might find http://thomasfly.com/Oranux/Oracle9i.htm helpful... I did on Mandrake, for example. And it's where I got the sysctl.conf tip from, which made a difference.

Regards
HJR Received on Mon Feb 10 2003 - 15:54:25 CST