Oracle 11g RAC on rhel 6.9 安装

一、安装说明
1、环境说明

2、软件存放位置规划如下：

3、RAC数据库需要共享存储：
CRSDG：3块至少3GB以上的盘，用于存放ocr、voting disk，asm的spfile。
DATADG：至少200GB，用于存放redolog、控制文件、数据库的spfile、数据库的system表空间、undo表空间、temp表空间。根据实际业务需求，增加DATADG的容量。
ARCHDG：至少100GB，用户存放归档日志。根据实际业务需求，增加DATADG的容量。

二、安装步骤
1、依赖包

cpp-4.8.2-16.el7.x86_64glibc-headers-2.17-55.el7.x86_64mpfr-3.1.1-4.el7.x86_64compat-libstdc++-33-3.2.3binutils-2.23.52.0.1-12.el7.x86_64compat-libcap1-1.10-3.el7.x86_64gcc-4.8.2-3.el7.x86_64gcc-c++-4.8.2-3.el7.x86_64glibc-2.17-36.el7.i686glibc-2.17-36.el7.x86_64glibc-devel-2.17-36.el7.i686glibc-devel-2.17-36.el7.x86_64kshlibaio-0.3.109-9.el7.i686libaio-0.3.109-9.el7.x86_64libaio-devel-0.3.109-9.el7.i686libaio-devel-0.3.109-9.el7.x86_64libgcc-4.8.2-3.el7.i686libgcc-4.8.2-3.el7.x86_64libstdc++-4.8.2-3.el7.i686libstdc++-4.8.2-3.el7.x86_64libstdc++-devel-4.8.2-3.el7.i686libstdc++-devel-4.8.2-3.el7.x86_64libXi-1.7.2-1.el7.i686libXi-1.7.2-1.el7.x86_64libXtst-1.2.2-1.el7.i686libXtst-1.2.2-1.el7.x86_64make-3.82-19.el7.x86_64sysstat-10.1.5-1.el7.x86_64

2、系统参数
可参考系统内核参数MOS Doc ID: 169706.1

vi /etc/sysctl.conf:fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 10485760kernel.shmmax = 34359738368kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048586

3、设置oracle用户shell限制：

/etc/security/limits.conforacle  soft  nproc   2047oracle  hard  nproc   16384oracle  soft  nofile  1024oracle  hard  nofile  65536oracle  soft  stack   10240oracle  hard  stack   32768

4、/etc/pam.d/login添加：

session required pam_limits.so/etc/profile添加：if [ $USER = "oracle" ]; then    if [ $SHELL = "/bin/ksh" ]; then       ulimit -u 16384       ulimit -n 65536    else       ulimit -u 16384 -n 65536    fifi

5、hosts

vi /etc/hosts192.168.3.2  tim110.10.10.1  tim1-priv192.168.3.88  tim1-vip192.168.3.3  tim210.10.10.2  tim1-priv192.168.3.99  tim2-vip192.168.3.111  rac-scan

6、用户与组

groupadd -g 200 oinstallgroupadd -g 201 dbagroupadd -g 202 opergroupadd -g 203 asmadmingroupadd -g 204 asmopergroupadd -g 205 asmdbauseradd -u 200 -g oinstall -G dba,asmdba,oper oracleuseradd -u 201 -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid

7、目录

mkdir -p /u01/app/oraInventorychown -R grid:oinstall /u01/appchmod -R 775 /u01/app/oraInventory/mkdir -p /u01/11.2.0/gridchown -R grid:oinstall /u01/11.2.0chmod -R 775 /u01/11.2.0mkdir -p /u01/app/oraclemkdir -p /u01/app/oracle/cfgtoollogsmkdir -p /u01/app/oracle/product/11.2.0/db_1chown -R oracle:oinstall /u01/app/oraclechmod -R 775 /u01/app/oracle

8、环境变量
###注意以下环境变量参数为Node1，与Node2不同之处在于Oracle_sid。
grid用户

export EDITOR=viexport ORACLE_SID=+ASM1export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=/u01/11.2.0/gridexport GRID_HOME=/u01/11.2.0/gridexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport THREADS_FLAG=nativeexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binumask 022

oracle用户

export EDITOR=viexport ORACLE_SID=prod1export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export LD_LIBRARY_PATH=$ORACLE_HOME/libexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/binumask 022

8、udev
###node1，node2都需要配置

[root@tim1 ~]#vi /etc/udev/rules.d/60-raw.rules     按照example编写如下：ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="33",RUN+="/bin/raw /dev/raw/raw1 %M %m"ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="34",RUN+="/bin/raw /dev/raw/raw2 %M %m"ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="35",RUN+="/bin/raw /dev/raw/raw3 %M %m"ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="36",RUN+="/bin/raw /dev/raw/raw4 %M %m"ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="37",RUN+="/bin/raw /dev/raw/raw5 %M %m"ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="38",RUN+="/bin/raw /dev/raw/raw6 %M %m"ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="39",RUN+="/bin/raw /dev/raw/raw7 %M %m"ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="40",RUN+="/bin/raw /dev/raw/raw8 %M %m"ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="41",RUN+="/bin/raw /dev/raw/raw9 %M %m"ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="42",RUN+="/bin/raw /dev/raw/raw10 %M %m"ACTION=="add", ENV{MAJOR}=="8",ENV{MINOR}=="43",RUN+="/bin/raw /dev/raw/raw11 %M %m"KERNEL=="raw[1-9]", OWNER="grid", GROUP="dba", MODE="660"KERNEL=="raw10", OWNER="grid", GROUP="dba", MODE="660"KERNEL=="raw11", OWNER="grid", GROUP="dba", MODE="660"[root@node1 ~]# start_udev[root@node2 ~]# ll /dev/raw/raw*crw-rw---- 1 grid dba 162,  1 Apr 17 21:10 /dev/raw/raw1crw-rw---- 1 grid dba 162, 10 Apr 17 21:10 /dev/raw/raw10crw-rw---- 1 grid dba 162, 11 Apr 17 21:10 /dev/raw/raw11crw-rw---- 1 grid dba 162,  2 Apr 17 21:10 /dev/raw/raw2crw-rw---- 1 grid dba 162,  3 Apr 17 21:10 /dev/raw/raw3crw-rw---- 1 grid dba 162,  4 Apr 17 21:10 /dev/raw/raw4crw-rw---- 1 grid dba 162,  5 Apr 17 21:10 /dev/raw/raw5crw-rw---- 1 grid dba 162,  6 Apr 17 21:10 /dev/raw/raw6crw-rw---- 1 grid dba 162,  7 Apr 17 21:10 /dev/raw/raw7crw-rw---- 1 grid dba 162,  8 Apr 17 21:10 /dev/raw/raw8crw-rw---- 1 grid dba 162,  9 Apr 17 21:10 /dev/raw/raw9

9、启动图形化


10、安装grid




Grid只认出了Node1节点，Node2需要手动添加一下。













11、安装oracle




可将简体中文加上







这是在向node2复制数据，可以在node2的$ORACLE_HOME下，
通过du -sh 查看进度

至此安装结束！！可能有些刚了解oracle 的按此步骤会报错，因为我没有配置两个节点grid、oracle用户互信，其实可以在图形化中操作，努力找一找吧！！
12、检查

查看集群资源        [grid@tim1 ~]$ crsctl status res -t检查ASM状态        [grid@tim1 ~]$ asmcmd -p检查ocr状态        [grid@tim1 ~]$ ocrcheck检查voting disk状态        [grid@tim1 ~]$ crsctl query css votedisk检查节点信息        [grid@tim1 ~]$ srvctl config nodeapps检查数据库信息        [grid@tim1 ~]$ srvctl config database -d prod检查接口状态        [grid@tim1 ~]$ oifcfg iflist -p -n        [grid@tim1 ~]$ oifcfg getif -global检查监听状态        [grid@tim1 ~]$ lsnrctl status