Oracle 在Centos上的安装步骤

1.内存和磁盘空间检查

至少 1.0 GB 的物理内存

grep MemTotal /proc/meminfo

交换分区要求如下

grep SwapTotal /proc/meminfo

/tmp 需求：

 至少1.0 GB大小

2.安装oracle运行需要的软件包

yum -y  install binutils

yum -y install compat*

yum -y install gcc* 

yum -y install glibc*

yum -y install elfutils-libelf 

yum -y install ksh 

yum -y install libgcc*

yum -y install libstdc++*

yum -y install libaio* 

yum -y install make

yum -y install sysstat

yum -y install xhost 

yum -y install xclock

yum -y install unixODBC*

yum -y install mpfr

yum -y install libXi

yum -y install libXtst

yum -y install elfutils-libelf-devel

3.操作系统环境配置

3.1修改hosts文件

vi /etc/hosts

192.168.195.131 ocptest

3.2selinux配置

vi /etc/selinux/config

SELINUX=Permissive  或者 SELINUX=disabled

3.3建立用户

groupadd -g 1001 oinstall

groupadd -g 1002 dba

useradd -u 502 -g oinstall -G dba oracle

passwd oracle

3.4目录建立

mkdir -p /u01/app/oracle/product/11.2.0/db_1

chown -R oracle:oinstall /u01/app/

chmod -R 775 /u01/app/

3.5oracle用户profile文件配置

vi /home/oracle/.bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

         . ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_SID=orcl

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export NLS_LANG=”AMERICAN_AMERICA.ZHS16GBK”

3.6内核参数调整

vi /etc/sysctl.conf

kernel.shmall =2097152

kernel.shmmax = 68719476736

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 6815744

fs.aio-max-nr = 1048576

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 = 1048576

执行如下命令生效：

sysctl -p

3.7limits配置

vi /etc/security/limits.conf

oracle soft nproc 2047 

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536 

oracle soft stack 10240

3.8pam调整

echo “session required pam_limits.so” >>/etc/pam.d/login

3.9关闭防火墙

service iptables stop

chkconfig iptables off

4.开始安装

./runInstaller

yum -y install elfutils-libelf*

登入到root用户执行两个脚本

sh /u01/app/oraInventory/orainstRoot.sh

sh /u01/app/oracle/product/11.2.0/db_1/root.sh

配置监听

dbca创建数据库：