Oracle12.1.0.2 RAC for Centos7

1.vi /etc/hosts

172.18.19.108  oracle-node3 172.18.19.109  oracle-node4 172.18.19.118  oracle-node3-vip 172.18.19.119  oracle-node4-vip 10.1.1.3  oracle-node3-priv 10.1.1.4  oracle-node4-priv 172.18.19.200  orcl-scanip 更改主机名： vi /etc/hostname [root@oracle-node3 ~]# hostnamectl set-hostname oracle-node3

2.防火墙

[root@oracle_node1 ~]# vi /etc/selinux/config SELINUX=disabled [root@oracle-node3 ~]# chkconfig NetworkManager off [root@oracle-node3 ~]# systemctl stop firewalld.service [root@oracle-node3 ~]# systemctl disable firewalld.service [root@oracle-node3 ~]# setenforce 0

2. 软件包

rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat [root@oracle_node1 ~]# rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libXi libXtst make sysstat binutils-2.25.1-22.base.el7.x86_64 compat-libcap1-1.10-7.el7.x86_64 compat-libstdc++-33-3.2.3-72.el7.x86_64 gcc-4.8.5-11.el7.x86_64 gcc-c++-4.8.5-11.el7.x86_64 glibc-2.17-157.el7.x86_64 glibc-devel-2.17-157.el7.x86_64 ksh-20120801-26.el7.x86_64 libaio-0.3.109-13.el7.x86_64 libaio-devel-0.3.109-13.el7.x86_64 libgcc-4.8.5-11.el7.x86_64 libstdc++-4.8.5-11.el7.x86_64 libstdc++-devel-4.8.5-11.el7.x86_64 libXi-1.7.4-2.el7.x86_64 libXtst-1.2.2-2.1.el7.x86_64 make-3.82-23.el7.x86_64 sysstat-10.1.5-11.el7.x86_64

3. 创建用户，组

[root@oracle_node1 ~]# /usr/sbin/groupadd -g 501 oinstall [root@oracle_node1 ~]# /usr/sbin/groupadd -g 502 dba [root@oracle_node1 ~]# /usr/sbin/groupadd -g 503 oper [root@oracle_node1 ~]# /usr/sbin/groupadd -g 504 asmadmin [root@oracle_node1 ~]# /usr/sbin/groupadd -g 505 asmdba [root@oracle_node1 ~]# /usr/sbin/groupadd -g 506 asmoper [root@oracle_node1 ~]# /usr/sbin/useradd -u 501 -g oinstall -G dba,asmdba,oper oracle [root@oracle_node1 ~]# /usr/sbin/useradd -u 502 -g oinstall -G asmadmin,asmdba,asmoper,dba grid [root@oracle_node1 ~]# passwd oracle [root@oracle_node1 ~]# passwd grid [root@oracle_node1 ~]# mkdir -p /u01/app/oracle [root@oracle_node1 ~]# mkdir -p /u01/app/oracle/product/12.1.0/db_1 [root@oracle_node1 product]# mkdir -p /u01/app/grid [root@oracle_node1 product]# mkdir -p /u01/app/12.1.0/grid [root@oracle_node1 product]# mkdir -p /u01/app/oraInventory [root@oracle_node1 product]# chown -R oracle:oinstall /u01/app/oracle [root@oracle_node1 product]# chown -R grid:oinstall /u01/app/grid [root@oracle_node1 product]# chown -R grid:oinstall /u01/app/oraInventory [root@oracle_node1 app]# chown -R grid:oinstall /u01/app/12.1.0/

4. 环境变量

[oracle@oracle_node1 ~]$ vi .bash_profile PATH=$PATH:$HOME/bin export PATH export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1 export ORACLE_UNQNAME=orcl export ORACLE_SID=orcl1 export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH:$ORACLE_BASE/scripts12c stty erase ^H [grid@oracle_node1 ~]$ vi .bash_profile PATH=$PATH:$HOME/bin export PATH export ORACLE_BASE=/u01/app/grid export ORACLE_HOME=/u01/app/12.1.0/grid export ORACLE_SID=+ASM1 export PATH=$ORACLE_HOME/bin:$PATH umask 022

5. 资源限制

[root@oracle_node1 ~]# vi /etc/security/limits.conf root  soft  nofile  65536 root  hard  nofile  65536 * soft memlock unlimited * hard memlock unlimited grid  soft  nproc  65536 grid  hard  nproc  65536 grid  soft  nofile 65536 grid  hard  nofile 65536 oracle soft nproc  65536 oracle hard nproc  65536 oracle soft nofile 65536 oracle hard nofile 65536 #Oracle recommended value for stack is set to 10240 for user grid grid  soft  stack  10240 #Oracle recommended value for stack is set to 10240 for user oracle oracle  soft  stack  10240

6. 配置ssh互信 Oracle_123

oracle,grid都要执行 ./sshUserSetup.sh -user grid -hosts "oracle-node3 oracle-node4" -advanced –noPromptPassphrase ./sshUserSetup.sh -user oracle -hosts "oracle-node3 oracle-node4" -advanced –noPromptPassphrase Oracle_123

7. 配置共享存储

--磁盘分区 fdisk /dev/sdd >u>n>p>1>default>default>w --编译rules文件 --查看scsi_id [root@oracle-node3 ~]# /usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sdd1   3600144f0593d8f320000598134750007 touch /etc/udev/rules.d/99-oracle-asmdevices.rules [root@oracle-node3 ~]# vi /etc/udev/rules.d/99-Oracle-asmdevices.rules KERNEL=="sd*", ENV{ID_SERIAL}=="3600144f0593d8f320000598134750007",SYMLINK+="asm_data", OWNER="grid", GROUP="asmadmin", MODE="0660" --使udev生效 [root@oracle-node3 ~]# udevadm control --reload-rules   [root@oracle-node3 ~]# udevadm trigger