--安装背景
上次碰到问题,cursor:mutex S导致的load过高,参考原来剖析额过程记录地址:http://blog.csdn.net/mchdba/article/details/51299062 , 有说可以升级到11.2.0.4就能避免这种问题,所以准备重新搭建新版本11.2.0.4。
安装环境是:azure云 linux centos6.5。
2017-11-22 补充:有很多网友留言、发站内消息、以及email,要oracle11.2.0.4下载地址,这里特提供下地址,大家可以下载:链接: https://pan.baidu.com/s/1dEFtcwp 密码: 44yv
2018-09-21 补充:有很多网友留言说,上面的连接失效,特重新生成了分享连接地址,链接: https://pan.baidu.com/s/1S-c_DZcWwARO6-sxRUK3pQ 提取码: w6zu
1,修改内核
1.1 修改sysctl.conf文件
[root@orcltest Downloads]# vim/etc/sysctl.conf
# add by tim.man kernel.shmmax = 277495689510912 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048586 fs.file-max = 6815744
# Controls the maximum number of shared memory segments, in pages kernel.shmall = 4294967296 net.ipv4.tcp_max_tw_buckets = 6000 net.ipv4.ip_local_port_range = 9000 65500 net.ipv4.tcp_tw_recycle = 0 net.ipv4.tcp_tw_reuse = 1 net.core.somaxconn = 262144 net.core.netdev_max_backlog = 262144 net.ipv4.tcp_max_orphans = 262144 net.ipv4.tcp_max_syn_backlog = 262144 net.ipv4.tcp_synack_retries = 2 net.ipv4.tcp_syn_retries = 1 net.ipv4.tcp_fin_timeout = 1 net.ipv4.tcp_keepalive_time = 30 net.ipv4.tcp_keepalive_probes = 6 net.ipv4.tcp_keepalive_intvl = 5 net.ipv4.tcp_timestamps = 0 fs.aio-max-nr = 1048576 |
1.2 使参数生效
[root@orcltest Downloads]# sysctl –p
2,增加用户和组
[root@orcltestDownloads]# groupadd oinstall
[root@orcltestDownloads]# groupadd dba
[root@orcltestDownloads]# groupadd oper
[root@orcltestDownloads]# useradd -g oinstall -G dba,oper oracle
[root@orcltestDownloads]# passwd oracle
3,修改limits.conf限制
[root@orcltestDownloads]# vim /etc/security/limits.conf
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 |
文章blog地址:http://blog.csdn.net/mchdba/article/details/51418063,原作者mchdba(黄杉),谢绝转载。
4,修改/etc/pam.d/login
[root@orcltestDownloads]# vim /etc/pam.d/login
session required/lib64/security/pam_limits.so
5,修改bash_profile文件
(1)修改profile:
[root@orcltest Downloads]# vim /etc/profile # add by tim.man if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi |
(2)修改bash_profile:
[oracle@orcltest ~]$ vim .bash_profile export EDITOR=vi export ORACLE_SID=doea5db export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/produc |