1.1. 配置主机IP 地址

DEVICE=eth0

BOOTPROTO=static

BROADCAST=192.168.40.255

HWADDR=50:E5:49:87:71:11

IPADDR=192.168.1.120

NETMASK=255.255.255.0

NETWORK=192.168.1.0

ONBOOT=yes

1.2. 修改主机名并增加主机IP

# vim /etc/hosts

192.168.1.120 oracle.localdomain

1.3. 检查系统支持库文件

# rpm -q gcc make binutils setarch compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel unixODBC unixODBC-devel libaio-devel sysstat

gcc-4.1.2-48.el5

make-3.81-3.el5

binutils-2.17.50.0.6-14.el5

setarch-2.0-1.1

package compat-db is not installed

package compat-gcc is not installed

package compat-gcc-c++ is not installed

package compat-libstdc++ is not installed

package compat-libstdc++-devel is not installed

package unixODBC is not installed

package unixODBC-devel is not installed

package libaio-devel is not installed

package sysstat is not installed

1.4. 检查依赖包

可以使用通配符*,如:rpm -qa|grep binutils-*

rpm -qa|grep binutils-2.17.50.0.6-2.el5 centos 5.5系统安装时会装好

rpm -qa|grep compat-libstdc++-33-3.2.3-61 centos 5.5系统安装时会装好

rpm -qa|grep elfutils-libelf-0.125-3.el5 centos 5.5系统安装时会装好

rpm -qa|grep elfutils-libelf-devel-0.125-3.el5centos 5.5系统安装时会装好

rpm -qa|grep glibc-2.5-12 centos 5.5系统安装时会装好

rpm -qa|grep glibc-devel-2.5-12 centos 5.5系统安装时会装好

rpm -qa|grep glibc-common-2.5-12 centos 5.5系统安装时会装好

rpm -qa|grep gcc-4.1.1-52.el5 centos 5.5系统安装时会装好

rpm -qa|grep gcc-c++-4.1.1-52.el5 centos 5.5系统安装时会装好

rpm -qa|grep libgcc-4.1.1-52.el5 centos 5.5系统安装时会装好

rpm -qa|grep libaio-0.3.106-3.2 centos 5.5系统安装时会装好

rpm -qa|grep libaio-devel-0.3.106-3.2

rpm -qa|grep libstdc++-4.1.1-52.el5 centos 5.5系统安装时会装好

rpm -qa|grep libstdc++-devel-4.1.1-52.el5 centos 5.5系统安装时会装好

rpm -qa|grep make-3.81-1.1 centos 5.5系统安装时会装好

rpm -qa|grep pdksh-5.2.14-36.el5.i386.rpm

rpm -qa|grep sysstat-7.0.0-3.el5

rpm -qa|grep unixODBC-2.2.11-7.1

rpm -qa|grep unixODBC-devel-2.2.11-7.1

1.5. 安装缺少库文件

使用YUM进行安装

#Yum install gcc make binutils setarch compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel unixODBC unixODBC-devel libaio-devel sysstat

1.6. 创建用户与组

#groupadd dba

#groupadd oinstall

#useradd oracle -g oinstall -G dba

#passwd oracle

2. 修改系统内核与参数

2.1. 参数说明

/etc/sysctl.conf (修改内核参数)

/etc/security/limits.conf (shell对oracle用户的限制)

/etc/profile (系统相关的环境变量)

2.2. 修改内核

vim /etc/sysctl.conf

修改与添加如下内容:

# Kernel Oracle 11g R2

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

保存退出,执行以下命令,使设置的内核参数生效

sysctl –p

2.3. shell对oracle用户的限制

vim /etc/security/limits.conf 
在文件的末尾加入以下内容:

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

2.4. 修改/etc/pam.d/login

Session required pam_limits.so

2.5. 修改/etc/profile

vim /etc/profile

在文件的末尾加入以下内容:

修改完成后使用source /etc/profiel生效

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

fi