SLES9 with DB 9.2.0.6 startup ORA-27125 unable to create shared memory segment

[Ronald Breuer]

Hi,

I install SLES9 + SP1 + DB 9.2.0.4 + DB patch 9.2.0.6 (software only)

I changed dbca as described in Metalink Note 292278.1

I got
SQL> startup
ORA-27125: unable to create shared memory segment
Linux Error: 1: Operation not permitted

I found Metalink Note 293988.1

With two 'workarounds'

1.
--- Login as root
--- # echo 1 > /proc/sys/vm/disable_cap_mlock

This works for me

2.
--- Login as root
--- Edit /etc/sysctl.conf
Add following lines
# Enable MLOCK?
# If you say yes here, Oracle will able to get require MLOCK priviledge
# for hugetlb memory.
vm.disable_cap_mlock=1
--- Execute the command
/etc/boot.sysctl start
Setting current sysctl status from /etc/sysctl.conf
vm.disable_cap_mlock = 1
--- Dont forget to enable the service.
chkconfig boot.sysctl on

This did not work.
sysctl.conf is in /etc/sysconfig/sysctl.conf
The command an the syntax did not work for me.

How can I make this persistent?

With kind regards
Ronald

[Reinhard Weh]

Hello Roland,

I have created /etc/sysctl.conf with content
vm.disable_cap_mlock=1


The command tell me it ist on.
oraprod:/etc # chkconfig boot.sysctl
boot.sysctl on

In /etc/sysconfig/sysctl the are other configuration (ip-forward...)

After reboot my 9.2.0.6 will work again.

regards
Reinhard Weh

Post by Ronald Breuer
Hi,
I install SLES9 + SP1 + DB 9.2.0.4 + DB patch 9.2.0.6 (software only)
I changed dbca as described in Metalink Note 292278.1
I got
SQL> startup
ORA-27125: unable to create shared memory segment
Linux Error: 1: Operation not permitted
I found Metalink Note 293988.1
With two 'workarounds'
1.
--- Login as root
--- # echo 1 > /proc/sys/vm/disable_cap_mlock
This works for me
2.
--- Login as root
--- Edit /etc/sysctl.conf
Add following lines
# Enable MLOCK?
# If you say yes here, Oracle will able to get require MLOCK priviledge
# for hugetlb memory.
vm.disable_cap_mlock=1
--- Execute the command
/etc/boot.sysctl start
Setting current sysctl status from /etc/sysctl.conf
vm.disable_cap_mlock = 1
--- Dont forget to enable the service.
chkconfig boot.sysctl on
This did not work.
sysctl.conf is in /etc/sysconfig/sysctl.conf
The command an the syntax did not work for me.
How can I make this persistent?
With kind regards
Ronald

[Magni Fabrizio]

It's:

vm/disable_cap_mlock=1

Regards
Fabrizio

-----Original Message-----
Sent: Wednesday, March 30, 2005 2:49 PM
Subject: Re: [suse-oracle] SLES9 with DB 9.2.0.6 startup
ORA-27125 unable to create shared memory segment
Hello Roland,
I have created /etc/sysctl.conf with content
vm.disable_cap_mlock=1
The command tell me it ist on.
oraprod:/etc # chkconfig boot.sysctl
boot.sysctl on
In /etc/sysconfig/sysctl the are other configuration (ip-forward...)
After reboot my 9.2.0.6 will work again.
regards
Reinhard Weh

Post by Ronald Breuer
Hi,
I install SLES9 + SP1 + DB 9.2.0.4 + DB patch 9.2.0.6

(software only)

Post by Ronald Breuer
I changed dbca as described in Metalink Note 292278.1
I got
SQL> startup
ORA-27125: unable to create shared memory segment
Linux Error: 1: Operation not permitted
I found Metalink Note 293988.1
With two 'workarounds'
1.
--- Login as root
--- # echo 1 > /proc/sys/vm/disable_cap_mlock
This works for me
2.
--- Login as root
--- Edit /etc/sysctl.conf
Add following lines
# Enable MLOCK?
# If you say yes here, Oracle will able to get require

MLOCK priviledge

Post by Ronald Breuer
# for hugetlb memory.
vm.disable_cap_mlock=1
--- Execute the command
/etc/boot.sysctl start
Setting current sysctl status from /etc/sysctl.conf
vm.disable_cap_mlock = 1
--- Dont forget to enable the service.
chkconfig boot.sysctl on
This did not work.
sysctl.conf is in /etc/sysconfig/sysctl.conf
The command an the syntax did not work for me.
How can I make this persistent?
With kind regards
Ronald

--
Please see http://www.suse.com/oracle/ before posting