(转)Redhat Linux安装Oracle 11g R2数据库

Oracle目前最新的版本是11g R2版本，网上不少安装介绍都是9i或者10g的，我按照介绍RHEL5.5上安装Oracle 11gR2总是有问题，之后看官方文档介绍了，在光盘的doc目录下有。

Oracle 11g R2数据库安装硬件配置要求：

最小内存 1 GB of RAM

虚拟内存容量

Available RAM Swap Space Required

Between 1 GB and 2 GB	1.5 times the size of RAM
Between 2 GB and 16 GB	Equal to the size of RAM
More than 16 GB	16 GB

硬盘空间要求

?

Oracle 11g R2数据库支持的操作系统

Oracle Database 11g Release 2 (11.2) for Linux x86:

Asianux 2.0

Asianux 3.0

Oracle Enterprise Linux 4.0 Update 7 or later

Oracle Enterprise Linux 5.0

Red Hat Enterprise Linux 4.0 Update 7 or later

Red Hat Enterprise Linux 5.0

SUSE Linux Enterprise Server 10.0

SUSE Linux Enterprise Server 11.0

需要的软件包支持：

这里只列出Asianux 3, Oracle Enterprise Linux 5.0, and Red Hat Enterprise Linux 5.0的要求，检查一下系统是否安装过这些包，没有的话在Redhat的光盘上都有。

binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
elfutils-libelf-devel-static-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-common-2.5
glibc-devel-2.5
glibc-headers-2.5
kernel-headers-2.6.18
ksh-20060214
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.2
libgomp-4.1.2
libstdc++-4.1.2
libstdc++-devel-4.1.2
make-3.81
sysstat-7.0.2
unixODBC-2.2.11
unixODBC-devel-2.2.11

创建Oracle用户

The Oracle Inventory group (typically, oinstall)

The OSDBA group (typically, dba)

The Oracle software owner (typically, oracle)

The OSOPER group (optional. Typically, oper)

# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -g oinstall -G dba oracle
# passwd oracle

修改内核参数

修改?/etc/sysctl.conf 文件，加上如下参数

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

应用配置

# /sbin/sysctl -p

修改用户限制

修改?/etc/security/limits.conf 文件，加上下面的参数

oracle?????????? soft??? nproc?? 2047
oracle?????????? hard??? nproc?? 16384
oracle?????????? soft??? nofile? 1024
oracle?????????? hard??? nofile? 65536

修改用户验证选项

修改/etc/pam.d/login文件加上如下参数

session??? required???? pam_limits.so

修改用户配置文件

修改/etc/profile文件加入如下参数：

if [ $USER = "oracle" ]; then
??????? if [ $SHELL = "/bin/ksh" ]; then
????????????? ulimit -p 16384
????????????? ulimit -n 65536
??????? else
????????????? ulimit -u 16384 -n 65536<