在Solaris 10/OpenSolaris上为Oracle安装设置内核参数

来源:互联网 发布:mac下载软件如何安装 编辑:程序博客网 时间:2024/06/05 03:58

如果使用Solaris系统缺省的内核参数,会导致创建数据库时出现Out of memory错误。

Solaris 10以前的版本是在/etc/system中设置系统参数,这种方式在Solaris 10/OpenSolaris中已经不用。

取而代之的是基于project的配置方式。以下内容节选自http://ebenze.wordpress.com/2008/07/31/step-install-oracle-10g-r2-on-solaris-10-x86/

#projadd oracle [This command will create a new 'resource project']
edit the /etc/user_attr file:
adm::::profiles=Log Management
lp::::profiles=Printer Management
root::::auths=solaris.*,solaris.grant;profiles=Web Console Management,All;lock_after_retries=no

oracle::::project=oracle [add this line]

then:

#su – oracle
$ id -p
$ prctl -n project.max-shm-memory -i project oracle

The display look like this:
project: 100: oracle
NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT
project.max-shm-memory
privileged 126MB – deny -
system 16.0EB max deny -

leaving the oracle user still connected in the original one Then, as root in the new terminal, you can issue this command:

#prctl -n project.max-shm-memory -v 4gb -r -i project oracle [create max memory to 4GB]

As soon as you’ve issued that command, switch back to the oracle user’s session and re-issue the earlier command:

$ prctl -n project.max-shm-memory -i project oracle

Note:
#prctl -n project.max-shm-memory -v 4gb -r -i project oracle [this setting will lost after reboot]
to set permanently, run this: #projmod -s -K "project.max-shm-memory=(priv,4gb,deny)" oracle

D. Performing the Oracle Installation

 4gb对有些系统还是小了些,可根据情况适当增加该值。

原创粉丝点击