centOS+oracle11gR2的RAC安装
- 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
一.硬件及软件环境
操作系统:centOS
网络环境:节点1:192.168.1.31 私有地址:192.168.0.31 虚拟地址:192.168.1.28 节点2:192.168.1.32 私有地址:192.168.0.32 虚拟地址:192.168.1.19
scanip:192.168.1.200
二.安装操作系统及相关系统配置两节点
1.安装centOS操作系统,相关文档请看centOS安装手册.
2.磁盘分区一个节点
此处将共享盘分为成三个主分区便于后续的asm挂载,(使用fdisk /dev/sdb)分区完后,通过fdisk –l来进行查看.[注:分区只在一台服务器上面执行,另一台服务器执行partprob即可]
三.环境变量配置及内核修改
1. 为oracle用户设置密码两节点
Oracle1:~ # passwd oracle (oracle)
Changing password for oracle.
New Password:
Bad password: too simple
Reenter New Password:
Password changed.
2.修改/etc/hosts 两节点
192.168.1.31 oracle1 #hostname为须配上ip 192.168.1.32 oracle2 #hostname为须配上ip 192.168.0.31 oracle1-priv
192.168.0.32 oracle2-priv
192.168.1.28 oracle1-vip
192.168.1.19 oracle2-vip
192.168.1.200 cluster #此为scanip,11gR2新增的
3.修改内核参数两节点
在安装界面过程中,有一过程会提示检查内核参数失败,然后在/tmp目录下生成一个fixup.sh的脚本,届时运行该修复脚本进行自动修复便可
4. 修改.bash_profile建立用户环境变量两节点
ORACLE_BASE=/oracle_db
ORACLE_HOME=$ORACLE_BASE/product/11.2/db
#节点1为orcl1、节点2为orcl2
ORACLE_SID=orcl1/2
GRID_HOME=/oracle_crs/product/11.2/crs
export ORACLE_BASE ORACLE_HOME ORACLE_SID GRID_HOME
5.建立crs与db的安装目录,两节点
oracle1:~ # mkdir -p /oracle_crs/product/11.2/crs
oracle1:~ # chown -R root:oinstall /oracle_crs/
oracle1:~ # chmod -R 775 /oracle_crs/
oracle1:~ # mkdir -p /oracle_db/product/11.2/db
oracle1:~ # chown -R root:oinstall /oracle_db
oracle1:~ # chmod -R 775 /oracle_db
6 格式化asm磁盘
Oracle ASM 与Oracle 数据库紧密集成在一起,并与Oracle 的数据管理工具套件配合工作。它可以简化数据库存储管理,并提供原始磁盘I/O 的性能。
配置ASMLib。以root 用户身份在两个节点上配置ASMLib。两个节
oracle1:~ # /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in brackets ('[]'). Hitting
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
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: done
Scanning the system for Oracle ASMLib disks: done
oracle1:~ # /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: done
Scanning the system for Oracle ASMLib disks: done
创建ASM 磁盘。以root 用户身份在任何一个节点上创建ASM 磁盘。
oracle1:~ # /etc/init.d/oracleasm createdisk CRS /dev/sdb1
Marking disk "CRS" as an ASM disk: done
oracle1:~ # /etc/init.d/oracleasm createdisk DATA /dev/sdb2
Marking disk "DATA" as an ASM disk: done
oracle1:~ # /etc/init.d/oracleasm createdisk FRA /dev/sdb3
Marking disk "FRA" as an ASM disk: done
oracle1:~ # /etc/init.d/oracleasm scandisks
Scanning the system for Oracle ASMLib disks: done
oracle1:~ # /etc/init.d/oracleasm 列出了oracleasm所有命令Usage: /etc/init.d/oracleasm {start|stop|restart|enable|disable|configure|createdisk|deletedisk|querydisk|listdisks|scandisks|status }
oracle1:~ # /etc/init.d/oracleasm listdisks
CRS
DA TA
FRA
在oracle2上执行
oracle2:~ # /etc/init.d/oracleasm enable
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: done