温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

centos 6.4下安装oracle 11hg rac 参数

发布时间:2020-07-14 20:31:01 来源:网络 阅读:461 作者:cruisezhao 栏目:关系型数据库

cat /etc/security/limits.conf <<EOF

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

EOF


echo "session required /lib64/security/pam_limits.so"  >> /etc/pam.d/login

echo "options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180    ###  检查hangcheck是否成功启动" >> /etc/modprobe.d/modprobe.conf


/sbin/modprobe hangcheck_timer    ### 启动hangcheck

#grep hangcheck /var/log/messages | tail -2 

禁用 /etc/selinux/config 和iptables


cat /ect/profile <<EOF

if [ \$USER = "oracle" ] || [ \$USER = "grid" ]; then
   if [ \$SHELL = "/bin/ksh" ]; then
     ulimit -p 16384
     ulimit -n 65536
else
    ulimit -u 16384 -n 65536
fi
umask 022
fi

EOF



####Oracle服务器上安装kmod-oracleasm文件:
cd /etc/yum.repos.d/
wget http://public-yum.oracle.com/public-yum-ol6.repo
wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

yum install kmod-oracleasm


###oracle yum 安装:
 yum install -y binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc \
glibc-common glibc-devel gcc gcc-c++ libaio-devel \
libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel \
pdksh numactl-devel glibc-headers


groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 504 asmadmin
groupadd -g 506 asmdba
groupadd -g 507 asmoper


useradd -u 1000 -g oinstall -G dba,asmdba oracle
useradd -u 1006 -g oinstall -G asmadmin,asmdba,asmoper grid

mkdir -p /u01/app
chown -R grid:oinstall /u01/app/
chmod -R 775 /u01/app/


mkdir -p /u01/app/oraInventory
chown -R grid:oinstall /u01/app/oraInventory
chmod -R 775 /u01/app/oraInventory

mkdir -p /u01/app/grid
mkdir -p /u01/app/oracle

chown -R grid:oinstall /u01/app/grid
chown -R oracle:oinstall /u01/app/oracle

chmod -R 775 /u01/app/oracle
chmod -R 775 /u01/app/grid

###asmlib 创建:

/etc/init.d/oracleasm start
/etc/init.d/oracleasm enable


/etc/init.d/oracleasm configure
Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [  OK  ]
Scanning the system for Oracle ASMLib disks: [  OK  ]

[root@rac2 modprobe.d]# .
Marking disk "ocrvdisk1" as an ASM disk: [  OK  ]
[root@rac2 modprobe.d]# /etc/init.d/oracleasm createdisk ocrvdisk2 /dev/sdb1
Marking disk "ocrvdisk2" as an ASM disk: [  OK  ]
[root@rac2 modprobe.d]# /etc/init.d/oracleasm createdisk ocrvdisk3 /dev/sde1
Marking disk "ocrvdisk3" as an ASM disk: [  OK  ]
[root@rac2 modprobe.d]# /etc/init.d/oracleasm createdisk dbfile1 /dev/sdd1
Marking disk "dbfile1" as an ASM disk: [  OK  ]
[root@rac2 modprobe.d]# /etc/init.d/oracleasm createdisk fra1 /dev/sdf1
Marking disk "fra1" as an ASM disk: [  OK  ]


####停止ntpd
service ntpd stop
mv /etc/ntp.conf /etc/ntp.conf.bak
chkconfig ntpd off


cat>> /home/grid/.bash_profile<< EOF

export TMP=/tmp;
export TMPDIR=$TMP;
export ORACLE_HOSTNAME=rac1;
export ORACLE_SID=+ASM1;
export ORACLE_BASE=/u01/app/grid;
export ORACLE_HOME=/u01/app/11.2.0/grid;
export NLS_DATE_FORMAT="yy-mm-dd HH24:MI:SS";
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin

export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH;
export NLS_LANG=american_america.AL32UTF8;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export EDITOR=vi
export LANG=en_US
umask 022

EOF


cat>> /home/oracle/.bash_profile<< EOF

export TMP=/tmp;
export TMPDIR=$TMP;
export ORACLE_HOSTNAME=rac1;
export ORACLE_BASE=/u01/app/oracle;
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1;
export ORACLE_PATH=/u01/app/common/oracle/sql;
export ORACLE_UNQNAME=racdb;
export ORACLE_SID=racdb1;
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;
export NLS_DATE_FORMAT="yy-mm-dd HH24:MI:SS";
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;
export LANG=en_US

EOF


###创建软件安装目录:
mkdir -p /u01/app/11.2.0/grid
chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle
chown -R oracle:oinstall /u01/app/oracle


###检查节点之间是否一致性:
./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -fixup -verbose



### IP SAN硬盘侦测:
iscsiadm -m discovery -t sendtargets -p ip:port

附件:http://down.51cto.com/data/2367361
向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI