oracle 12c r2 RAC配置手册.doc

1、ORACLE 12C R2 Real Application Cluster Installation Guide朱海清StarTimes Software Technology Co., LtdASM 磁盘空间最低要求12C R2 相比前一版本， OCR 的磁盘占用需求有了明显增长。为了方便操作，设置如下：External: 1 个卷 x40GNormal: 3 个卷 x30GHight: 5 个卷 x25GFlex: 3 个卷 x30GOCR+VOLTING+MGMT 存储通常放到一个磁盘组，且 选择 Normal 的冗余方式，也即最少 3 块 asm 磁盘 80G 空间。操作系统安装操作

2、系统安装时把“Server with GUI“ 和”Compatibility Libraries”勾上，其他都不用 选择。版本采用 CentOS 7、RHEL 7 或者 Oracle Linux 7安装 oracle 预安装包yum install -y oracle-rdbms-server-12cR1-preinstall创建用户和组oracle 用户和 dba、oinstall 组已经在上一步创建完毕。rac 所有节点的 oracle 用户和 grid 用户的 uid 和 gid 必须一致，所以创建的时候最好制定 uid 和 gid。groupadd -gid 54323 asmdba

3、groupadd -gid 54324 asmopergroupadd -gid 54325 asmadmingroupadd -gid 54326 opergroupadd -gid 54327 backupdbagroupadd -gid 54328 dgdbagroupadd -gid 54329 kmdbausermod -uid 54321 -gid oinstall -groups dba,oper,asmdba,asmoper,backupdba,dgdba,kmdba oracleuseradd -uid 54322 -gid oinstall -groups dba,asma

4、dmin,asmdba,asmoper grid安装目录mkdir -p /u01/app/12.2.0/gridmkdir -p /u01/app/gridmkdir -p /u01/app/oraclechown -R grid:oinstall /u01chown oracle:oinstall /u01/app/oraclechmod -R 775 /u01/用户环境变量grid 环境变量cat /home/grid/.bash_profileORACLE_SID=+ASM1ORACLE_HOME=/u01/12.2.0/gridPATH=$ORACLE_HOME/bin:$PATHL

5、D_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport ORACLE_SID CLASSPATH ORACLE_HOME LD_LIBRARY_PATH PATHEOF在节点 2，ORACLE_SID=+ASM2oracle 环境变量cat /home/oracle/.bash_profileORACLE_SID=starboss1ORACLE_HOME=/u01/app/oracle/product/12.2.

6、0/db_1ORACLE_HOSTNAME=rac01PATH=$ORACLE_HOME/bin:$PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libCLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport ORACLE_SID ORACLE_HOME ORACLE_HOSTNAME PATH LD_LIBRARY_PATH CLASSPATHEOF在节点 2，ORACLE_SID=starboss2，ORACLE_HOSTNAME=rac02修改 lo

7、gind.conf# vi /etc/systemd/logind.conf RemoveIPC=no # systemctl daemon-reload # systemctl restart systemcd-logind加载 pam_limits.so 模块echo “session required pam_limits.so“ /etc/pam.d/login禁用 selinuxsetenforce 0vi /etc/sysconfig/selinux禁用防火墙# systemctl stop firewalld thenif $SHELL = “/bin/ksh“ ; thenul

8、imit -u 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifiif $USER = “grid“ ; thenif $SHELL = “/bin/ksh“ ; thenulimit -u 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifiEOF修改共享内存分区大小将如下参数添加到/etc/fstab，具体大小数值根据实际情况调整，因为这个数值和物理内存以及 MEMORY_TARGET 有关。echo “shm /dev/shm tmpfs size=12g 0 0” /etc/fst

9、ab修改后，只需重新对 shm 进行挂载即可：mount -o remount /dev/shm多路径# yum install device-mapper-multipath# cp /usr/share/doc/device-mapper-multipath-0.4.9/multipath.conf /etc/获取 scsi id# /usr/lib/udev/scsi_id -whitelisted -replace-whitespace -device=/dev/sda# vi /etc/multipath.confmultipaths multipath wwid 36000d310

10、012522000000000000000006alias vol01multipath wwid 36000d310012522000000000000000005alias vol02# systemctl start multipathd.service# multipath -ll配置磁盘ASMlib 方式安装 ASMLibOracle Linux 7yum install -y kmod-oracleasmCentOS 7yum install -y http:/mirror.centos.org/centos/7/os/x86_64/Packages/kmod-oracleasm-

11、2.0.8-17.el7.centos.x86_64.rpmyum install -y http:/ install -y http:/public- 磁盘配置12C R2 中对磁盘组空间要求比 12C R1 更大。rootrac01 # /etc/init.d/oracleasm configure -iConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions wil

12、l determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets (). Hitting without typing ananswer will keep that current value. Ctrl-C will abort.Default user to own the driver interface : gridDefault group to own the driver interface

13、: asmadminStart Oracle ASM library driver on boot (y/n) n: yScan for Oracle ASM disks on boot (y/n) y: yWriting Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: OK Scanning the system for Oracle ASMLib disks: OK rootrac01 # reboot用 fdisk 在共享磁盘上创建主分区：rootrac01 # fdi

14、sk /dev/sddWelcome to fdisk (util-linux 2.23.2).Changes will remain in memory only, until you decide to write them.Be careful before using the write command.Device does not contain a recognized partition tableBuilding a new DOS disklabel with disk identifier 0x86f899a0.Command (m for help): nPartition type:p primary (0 primary, 0 extended, 4 free)e extendedSelect (default p): pPartition number (1-4, default 1): First sector (2048-39976959, default 2048): Using default value 2048Last sector, +sectors or +sizeK,M,G (2048-39976959, default 39976959):