Re: Oracle 10g on Linux kernel 2.6

From: Steve <ThisOne_at_Aint.valid>
Date: Fri, 14 May 2004 08:07:33 +1200
Message-ID: <c80ki5$28t$1@lust.ihug.co.nz>

David Giles wrote:
> Hi,
>
> I'm wondering if anyone can assist...
>
> I've just installed SuSE 9.1 (kernel 2.6.4-52) on a new box and have
> installed Oracle 10g (10.1.0.2). The installation was fine... however...
>
> Every time I try creating a database (only tried through DBCA so far) the db
> startup fails with an Ora-27125 (unable to create shared memory segment).
>
> I've set the kernel params as per the install documentation, these being the
> additional parameters I've set through the sysctl.conf:
>
> kernel.shmall = 2097152
> kernel.shmmax = 2147483648
> kernel.shmmni = 4096
> kernel.sem = 250 32000 100 128
> fs.file-max = 65536
> net.ipv4.ip_local_port_range = 1024 65000
>
> Has anyone got this working yet..? Is it a kernel issue?
>
> Many thanks

Works fine for me on RedHat Fedora/2.6.4 with 1GB memory.

You may want to use ipcs to investigate/clean your available memory???

Here's the relevant bit from sysctl.conf

# Oracle stuff...

kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.sem = 256 32000 100 142

fs.file-max = 131072
net.ipv4.ip_local_port_range = 1024 65000

# Oracle 10g stuff

kernel.msgmax = 8192
kernel.msgmnb = 65535
kernel.msgmni = 2878

Good Luck,

Steve.
PS. Anyone got Enterprise Manager to start installing??? Mine fails 'Checking Operating System Certification', saying I have 0MB of RAM available! Something changed in /proc/meminfo??? Received on Thu May 13 2004 - 15:07:33 CDT