AIX Oracle RAC 实施.docx
《AIX Oracle RAC 实施.docx》由会员分享,可在线阅读,更多相关《AIX Oracle RAC 实施.docx(31页珍藏版)》请在冰豆网上搜索。
AIXOracleRAC实施
1项目名称XX项目Oracle10GRAC实施文档项目编号文档编号
文档版本V1.00
XX项目Oracle10GRAC实施文档
ai
xc
hi
na
文件修订记录:
版本号生成日期作者修订内容
V1.002010-12-28风影子QQ:
14814937
博客:
文件审批记录:
拟制:
日期:
审核:
日期:
批准:
日期:
ai
xc
hi
na
目录
1客户环境规划............................................................................................................................................................5
2说明............................................................................................................................................................................6
3是否使用HACMP.....................................................................................................................................................64
操作系统要求............................................................................................................................................................74.1创建ROOTVG的镜像.................................................................................................................................74.2操作系统的补丁要求....................................................................................................................................74.3操作系统网络及核心要求.........................................................................................................................75
安装CRS的准备工作..............................................................................................................................................85.1在每个节点上检查网络配置(公共ip,私有ip,虚拟ip....................................................................85.2在每个节点上都确保是64位的操作系统版本..........................................................................................85.3在每个节点上都修改文件系统大小............................................................................................................95.4在每个节点上建立dba,hagsuser,oinstall组和oracle用户...................................................................95.5在每个节点上配置root和oracle用户的rcp............................................................................................115.6为每个节点建立相同的Oracle软件主目录.............................................................................................125.7在每个节点上创建/oracle文件系统..........................................................................................................125.8在两个节点上设置共享设备的属性..........................................................................................................135.9为每个节点设置Oracle用户的环境变量.................................................................................................155.10检查安装环境..........................................................................................................................................166
开始安装OracleCRS软件.....................................................................................................................................216.1下载相关的Oracle软件.............................................................................................................................216.2进入欢迎界面..............................................................................................................................................216.3选择安装记录路径......................................................................................................................................236.4指定oracleCRS软件的安装路径.............................................................................................................246.5OracleCRS进行预检查..............................................................................................................................256.6配置crs名称及对应的ip地址和/etc/hosts内容一样..............................................................................266.7指定网卡的private/public的属性..............................................................................................................276.8配置OCR的文件路径................................................................................................................................286.9配置Vote的文件路径.................................................................................................................................296.10安装进行中界面......................................................................................................................................306.11结束时分别在两个节点上顺序运行提示脚本..........................................................................................316.12完成OracleCRS的安装.........................................................................................................................336.13检查CRS是否正常................................................................................................................................347
升级CRS主目录10204.........................................................................................................................................347.1下载相关的升级patch及解压...................................................................................................................347.2选择要升级的CRS主目录........................................................................................................................357.3升级的CRS的过程....................................................................................................................................377.4完成安装......................................................................................................................................................388配置VIP..................................................................................................................................................................409
安装数据库软件10201...........................................................................................................................................439.1下载数据库软件..........................................................................................................................................439.2开始安装,进入欢迎界面..........................................................................................................................449.3选择企业版..................................................................................................................................................459.4选择DB的路径..........................................................................................................................................469.5选择所有的节点..........................................................................................................................................479.6忽略检查警告..............................................................................................................................................479.7选择只安装软件,不创建数据库..(48
ai
xc
hi
na
9.8完成安装后提示在两个节点上执行root..sh脚本....................................................................................5010
升级oracle主目录10204...................................................................................................................................5010.1下载相关的升级patch及解压...............................................................................................................5010.2选择要升级的oracle主目录..................................................................................................................5210.3升级的oracle过程..................................................................................................................................5311创建数据库..........................................................................................................................................................5411.1创建监听......................................................................................................................................................5412
配置ASM磁盘并创建AFC数据库实例..........................................................................................................5612.1用DBCA配置ASM磁盘......................................................................................................................5612.2创建AFC数据库实例............................................................................................................................6012.3检查数据库状态......................................................................................................................................6913解决RAC时断时续问题....................................................................................................................................7014配置并测试节点故障自动切换..........................................................................................................................7015内存调优..............................................................................................................................................................7116增加在线重做日志组..........................................................................................................................................7117在线重做日志文件多路复用..............................................................................................................................7118控制文件多路复用..............................................................................................................................................7219
RAC相关的管理命令........................................................................................................................................7319.1关闭RAC并重启AIX服务器...............................................................................................................7319.2重启AIX服务器后开启CRS服务.......................................................................................................7319.3查看CRS状态.................................................................................................