基于天翼云ECS搭建Oracle RAC集群 [root@p19c02 ~] [root@p19c02 ~] [root@p19c02 ~] cat /etc/udev/rules.d/99oracleasmdevices.rules KERNEL"vd",ATTR{serial}"965fcbe94f9c4aa09",SYMLINK+"asmocr",OWNER"grid",GROUP"asmadmin",MODE"0660" KERNEL"vd",ATTR{serial}"9367ac9eccf14e9d8",SYMLINK+"asmdata",OWNER"grid",GROUP"asmadmin",MODE"0660" [root@p19c02 ~] 注意:两个节点均需执行。 3. avahidaemon 配置。 yum install y avahi systemctl disable avahidaemon.service 注意:两个节点均需执行。 4. 系统参数配置。 配置参数文件如下所示: memTotal$(grep MemTotal /proc/meminfo awk '{print $2}') totalMemory$((memTotal / 2048)) shmall$((memTotal / 4)) if [ $shmall lt 2097152 ]; then shmall2097152 fi shmmax$((memTotal 1024 1)) if [ "$shmmax" lt 4294967295 ]; then shmmax4294967295 fi cat >/etc/sysctl.conf fs.aiomaxnr 1048576 fs.filemax 6815744 kernel.shmall $shmall kernel.shmmax $shmmax kernel.shmmni 4096 kernel.sem 250 32000 100 128 net.ipv4.iplocalportrange 9000 65500 net.core.rmemdefault 262144 net.core.rmemmax 4194304 net.core.wmemdefault 262144 net.core.wmemmax 1048576 net.ipv4.conf.eth0.rpfilter 1 net.ipv4.conf.eth1.rpfilter 2 EOF 生效系统参数: sysctl p 5. 系统资源限制配置。 配置limits.conf: cat >/etc/security/limits.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 32768 oracle soft nproc 2047 oracle hard nproc 16384 oracle hard memlock 134217728 oracle soft memlock 134217728 grid soft nofile 1024 grid hard nofile 65536 grid soft stack 10240 grid hard stack 32768 grid soft nproc 2047 grid hard nproc 16384 EOF 配置pam.d/login: cat >/etc/pam.d/login session required pamlimits.so session required /lib64/security/pamlimits.so EOF 6. 用户及组、目录创建。 用户组创建: /usr/sbin/groupadd g 54321 oinstall /usr/sbin/groupadd g 54322 dba /usr/sbin/groupadd g 54323 oper /usr/sbin/groupadd g 54324 backupdba /usr/sbin/groupadd g 54325 dgdba /usr/sbin/groupadd g 54326 kmdba /usr/sbin/groupadd g 54327 asmdba /usr/sbin/groupadd g 54328 asmoper /usr/sbin/groupadd g 54329 asmadmin /usr/sbin/groupadd g 54330 racdba 用户grid/oracle创建: /usr/sbin/useradd u 11012 g oinstall G asmadmin,asmdba,asmoper,dba,racdba,oper grid /usr/sbin/useradd u 54321 g oinstall G asmdba,dba,backupdba,dgdba,kmdba,racdba,oper oracle echo "oracle" passwd oracle stdin echo "oracle" passwd grid stdin id grid id oracle udevadm control reloadrules udevadm trigger ll /dev grep asm 创建软件目录: mkdir p /u01/app/19.3.0/grid mkdir p /u01/app/grid mkdir p /u01/app/oracle/product/19.3.0/db mkdir p /u01/app/oraInventory mkdir p /backup mkdir p /home/oracle/scripts chown R oracle:oinstall /backup chown R oracle:oinstall /home/oracle/scripts chown R grid:oinstall /u01 chown R grid:oinstall /u01/app/grid chown R grid:oinstall /u01/app/19.3.0/grid chown R grid:oinstall /u01/app/oraInventory chown R oracle:oinstall /u01/app/oracle chmod R 775 /u01 注意:两个节点均需执行。 7. 环境变量配置。 用户grid环境变量: cat >/home/grid/.bashprofile