CentOS5上安装Oracle11g(二)

2014-11-24 16:54:00 · 作者: · 浏览: 1
vel-0.137-3.el5.i386.rpm rm -rf elfutils-libelf-devel-0.137-3.el5.x86_64.rpm rm -rf elfutils-libelf-devel-static-0.137-3.el5.i386.rpm rm -rf elfutils-libelf-devel-static-0.137-3.el5.x86_64.rpm rm -rf gcc-4.1.2-50.el5.x86_64.rpm rm -rf gcc-c++-4.1.2-50.el5.x86_64.rpm rm -rf glibc-2.5-58.i686.rpm rm -rf glibc-2.5-58.x86_64.rpm rm -rf glibc-common-2.5-58.x86_64.rpm rm -rf glibc-devel-2.5-58.i386.rpm rm -rf glibc-devel-2.5-58.x86_64.rpm rm -rf glibc-headers-2.5-58.x86_64.rpm rm -rf libaio-0.3.106-5.i386.rpm rm -rf libaio-0.3.106-5.x86_64.rpm rm -rf libaio-devel-0.3.106-5.i386.rpm rm -rf libaio-devel-0.3.106-5.x86_64.rpm rm -rf libao-0.8.6-7.i386.rpm rm -rf libao-0.8.6-7.x86_64.rpm rm -rf libgcc-4.1.2-50.el5.i386.rpm rm -rf libgcc-4.1.2-50.el5.x86_64.rpm rm -rf libstdc++-4.1.2-50.el5.i386.rpm rm -rf libstdc++-4.1.2-50.el5.x86_64.rpm rm -rf libstdc++-devel-4.1.2-50.el5.i386.rpm rm -rf libstdc++-devel-4.1.2-50.el5.x86_64.rpm rm -rf make-3.81-3.el5.x86_64.rpm rm -rf numactl-0.9.8-11.el5.i386.rpm rm -rf numactl-0.9.8-11.el5.x86_64.rpm rm -rf pdksh-5.2.14-36.el5.x86_64.rpm rm -rf sysstat-7.0.2-3.el5_5.1.x86_64.rpm rpm -qa|grep binutils >> queryrpm.log 2>&1 rpm -qa|grep compat-libstdc >> queryrpm.log 2>&1 rpm -qa|grep elfutils >> queryrpm.log 2>&1 rpm -qa|grep gcc >> queryrpm.log 2>&1 rpm -qa|grep glibc >> queryrpm.log 2>&1 rpm -qa|grep kernel >> queryrpm.log 2>&1 rpm -qa|grep ksh >> queryrpm.log 2>&1 rpm -qa|grep libaio >> queryrpm.log 2>&1 rpm -qa|grep libgcc >> queryrpm.log 2>&1 rpm -qa|grep libgomp >> queryrpm.log 2>&1 rpm -qa|grep libstdc++- >> queryrpm.log 2>&1 rpm -qa|grep make >> queryrpm.log 2>&1 rpm -qa|grep sysstat >> queryrpm.log 2>&1

3. 创建用户、组、目录

# groupadd oinstall

# groupadd dba

# useradd -g oinstall -G dba oracle

# passwd oracle

Changing password for user oracle.

New UNIX password:oracle

BAD PASSWORD: it is based on a dictionary word

Retype new UNIX password:oracle

passwd: all authentication tokens updated successfully.

# id oracle

uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)

# mkdir -p /home/u01/app/oracle

# mkdir -p /home/u01/app/oraInventory

# chown -R oracle:oinstall /home/u01/app

# chmod -R 775 /home/u01/app

4. 配置内核参数、修改环境变量

# vi /etc/sysctl.conf

添加:

kernel.shmall = 4294967296

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65500

net.core.rmem_default = 4194304

net.core.wmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_max = 262144

~

# sysctl -p

--使内核参数生效

# su - oracle

$ vi .bash_profile

--修改oracle用户的环境配置文件

--执行:su - oracle切换到oracle用户环境,然后编辑 .bash_profile文件,更改PATH的配置,同时在环境变量中增加NLS_LANG的配置

ORACLE_BASE=/home/u01/app/oracle

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

ORACLE_SID=hyl

PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH

5. 设置shell限制

--添加以下参数

# vi /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

# vi /etc/pam.d/login

--添加以下参数

session required /lib/security/pam_limits.so

session required pam_limits.so

# vi /etc/profile

--添加以下参数

if [ $USER = "oracle" ]; then

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

ulimit -p 16384

ulimit -n 65536

el