三、修改Linux内核参数及oracle参数
1.配置共享内存文件系统
[root@rac1 ~]# umount tmpfs
[root@rac1 ~]# mount -t tmpfsshmfs -o size=1500m /dev/shm
[root@rac1 ~]# vi /etc/fstab
tmpfs /dev/shm tmpfs size=1500m 0 0
2.配置Linux内核参数
1)修改/etc/sysctl.conf
[root@rac1 ~]# vi/etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 681574
kernel.shmall = 2097152
kernel.shmmax = 1054504960
kernel.shmmni = 4096
# semaphores: semmsl, semmns,semopm, semmni
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
执行
[root@rac1 ~]# /sbin/sysctl –p
2)修改/ect/security/limits.conf
[root@rac1 ~]# vi/etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
3)修改/etc/pam.d/login
[root@rac1 ~]# vi/etc/pam.d/login
session required pam_limits.so
4)禁止网络时间服务
[root@rac1 ~]# service ntpd stop
[root@rac1 ~]# chkconfig ntpdoff
[root@rac1 ~]# mv/etc/ntp.conf /etc/ntp.conf.orig
[root@rac1 ~]# rm/var/run/ntpd.pid
3.修改oracle用户的.bash_profile
[oracle@rac1 ~]$ vi .bash_profile
#解决使用上下键乱码,安装rlwrap插件
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=rac1
export ORACLE_UNQNAME=RAC
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID=rac1
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
#解决回退格乱码
stty erase ^h
#sqlplus使vi编辑
export EDITOR=vi
#资源限制
if [ $USER = "oracle" ]||[ $USER = "grid"]; then
if [ $SHELL = "/bin/ksh"]; then
ulimit -p16384
ulimit -n65536
else
ulimit -u16384 -n 65536
fi
umask 022
fi
[oracle@rac2 ~]$ source .bash_profile
#验证配置
[oracle@rac1 ~]$ echo $ORACLE_SID
rac1
[oracle@rac1 ~]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1
[oracle@rac1 ~]$ echo $ORACLE_BASE
/u01/app/oracle
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24626757/viewspace-2121277/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24626757/viewspace-2121277/