Parameters.. sittings

There is only two /etc/system parameters that are going to keep you sga
from allocating: shmmax and semmns. In this case you're hitting
semphore issues. Do this:

# ipcs -o

This will list your shared memory segements and semaphores. You always
have at least one shared memory segment owned by root .... you are
interested in the stuff owned by oracle. With all databases on the
server down, you should not see anything owned by oracle. this is a
good place to start ... make sure you don't have any shared memory
segments or semaphores hanging around.

Next,

cat the /etc/system file and look at the lines that have semmns and
shmmax on them .... what are they set to? A good place to start with
shmmax is the default recommended in the install guide ... 4 GB ....
don't set this in hex .... it is impossible to calculate by mere mortals
and I've seen cases where it doesn't work. You can set semmns as high
as 64 K, but I've helped customers with F25Ks and no sane person usually
goes beyone 24,000 without a darned good technical reason .... start
with 1, 2 or 4 K and you should be fine.

Lastly,

# sysdef | grep -i shm
# sysdef | grep -i sem

This will print out what the system actually has set in the kernel ....
/etc/system had better match. Here's what I have:

* Oracle parameters
set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10

and it works fine on an E450 with 2 GB of RAM and 2 CPUs ... I have
9.2.0.6 and 10.1.0.2 running.

Thanks!
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值