AIX+HA+双机互备ORACLE.doc

步骤简述1：安装AIX操作系统2：安装ORACLE和HA的基础软件3：升级操作系统4：安装HA软件5：打HA补丁6：重启7：主机名8：IP9：vi /etc/hosts-所有的NODENAME和HOSTNAME都要用小写TOP#310:创建集群CLUSTER11:添加节点ADD NODE12:discover 抓取节点信息，创建心跳磁盘-这个如果正确抓取就会有百分比出现-smit mkvg创建心跳磁盘13：创建网络TCP/IP，和心跳网络14：添加网络接口，和心跳接口#这里就可以同步一次验证一下，并且启动HA，使server_ip15. 创建Resource ,SERVER_IP,APP,SCRIPTS这时候要验证你的开机和关机启动脚本16:创建资源组RGA. Rg运行在哪些节点上B. 节点优先级顺序C. Rg启动策略D. 切换策略E. 回切策略17：修改资源组属性，将资源加入到资源组18:检查配置是否正确19：同步到其他节点20：启动集群服务21：测试 HA ORACLE 双机互备1：首先配置IP,2边数据软件安装结构一致# ifconfig -aen0: flags=1e080863,c0 inet 192.168.1.206 netmask 0xffffff00 broadcast 192.168.1.255 tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0en1: flags=1e080863,c0 inet 10.10.10.206 netmask 0xffffff00 broadcast 10.10.10.255 inet 172.16.0.68 netmask 0xffffff00 broadcast 172.16.0.255 inet 172.16.0.206 netmask 0xffffff00 broadcast 172.16.0.255 tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0lo0: flags=e08084b,c0 inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255 inet6 :1%1/0 tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 12：查看/etc/hosts文件,2边要求一致192.168.1.206 aix206_boot110.10.10.206 aix206_boot2 172.16.0.206 aix206192.168.1.208 aix208_boot110.10.10.208 aix208_boot2172.16.0.208 aix208172.16.0.68 srvyssh172.16.0.86 srvcinms3：配置HA,创建HA CLUSTER#smit hacmp4：添加节点5：发现扩谱图6：添加网络7：网络接口选择所有节点8：添加管理IP9 SERVER_IP9：添加资源11：配置SERVER_IP12：创建资源组13：将资源加入资源组14:验证HA15：启动HA16: 确认VG情况# lspv | grep cinmshdisk3 00ce9f6ad8f74bf9 cinmsvg activehdisk4 00ce9f6aff0292c1 cinmsvg active# lspv | grep ysshhdisk1 00ce9f6ad767447d ysshvg active17：测试卷组并且测试脚本启动关闭及监听脚本如下,记住更改权限# cat startcinmsbanner startcinms | wall su - oracle -c export ORACLE_SID=cinmssqlplus /nolog EOFconn / as sysdbastartupexitEOFsu - oracle -c lsnrctl start lsnrcinms exit 0# cat stopcinms#!/usr/bin/kshbanner stoptcinms | wall su - oracle -clsnrctl stop lsnrcinmssleep 5kill -9 ps -ef | grep cinms | grep LOCAL=NO |awk print $2 su - oracle -cexport ORACLE_SID=cinmssqlplus /nolog EOFconn / as sysdbashutdown immediateexitEOFexit 0# cat startysshbanner startyssh | wall su - oracle -c export ORACLE_SID=yssh sqlplus /nolog EOFconn / as sysdbastartupexitEOFsu - oracle -c lsnrctl start lsnryssh exit 0# cat stopyssh#!/usr/bin/kshbanner stoptyssh | wall su - oracle -clsnrctl stop lsnrysshsleep 5kill -9 ps -ef | grep yssh | grep LOCAL=NO |awk print $2 su - oracle -cexport ORACLE_SID=ysshsqlplus /nolog select instance_name from v$instance;INSTANCE_NAME-Yssh$ export ORACLE_SID=cinms$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 16 01:27:06 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL select instance_name from v$instance;INSTANCE_NAME-Cinms25：开始迁移成功后验证$ export ORACLE_SID=yssh$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 16 01:32:00 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL select instance_name from v$instance;INSTANCE_NAME-ysshSQL exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options$ hostnameaix20826：心跳盘功能验证AIX206数据库启动$ export ORACLE_SID=yssh$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sat Aug 16 15:39:06 2014Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL select instance_name from v$instance;INSTANCE_NAME-Yssh停止EN0发现service_ip迁移# hostnameaix206# ifconfig -aen0: flags=1e080862,c0 inet 192.168.1.206 netmask 0xffffff00 broadcast 192.168.1.255 tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0en1: flags=1e080863,c0 inet 10.10.10.206 netmask 0xffffff00 broadcast 10.10.10.255 inet 172.16.0.206 netmask 0xffffff00 broadcast 172.16.0.255 inet 172.16.0.68 netmask 0xffffff00 broadcast 172.16.0.255 tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0lo0: flags=e08084b,c0 inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255 inet6 :1%1/0 tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1再停止EN1，AIX206自动停止数据库然后发现AIX208接管AIX206的数据库# ifconfig -aen0: flags=1e080863,c0 inet 192.168.1.208 netmask 0xffffff00 broadcast 192.168.1.255 inet 172.16.0.86 netmask 0xffffff00 broadcast 172.16.0.255 inet 172.16.0.68 netmask 0xffffff00 broadcast 172.16.0.255 tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0en1: flags=1e080863,c0 inet 10.10.10.208 netmask 0xffffff00 broadcast 10.10.10.255 inet