aix hacmp oracle 双机集群实施步骤,AIX+HACMP+Oracle双机集群项目

(13)测试B801单机双实例是否能正常手工启停

B801# varyonvg datavg801

B801# varyonvg datavg802

B801# /etc/801dbstart

B801#/etc/802dbstart

B801#ps -ef | grep ora

B801#set | grep SID

B801#sqlplus sys/vvk as sysdba

SQL>shutdown immediate;

B801#ps -ef | grep ora

B801#export Oracle_SID=ora102

B801#set | grep SID

B801#sqlplus sys/vvk as sysdba

SQL>shutdown immediate;

B801#ps -ef | grep ora

B801#varyoffvg datavg801

B801#varyoffvg datavg802

(14)测试B802单机双实例是否能正常手工启停

B801# varyonvg datavg801

B801# varyonvg datavg802

B801# /etc/801dbstart

B801#/etc/802dbstart

B801#ps -ef | grep ora

B801#set | grep SID

B801#sqlplus sys/vvk as sysdba

SQL>shutdown immediate;

B801#ps -ef | grep ora

B801#export ORACLE_SID=ora101

B801#set | grep SID

B801#sqlplus sys/vvk as sysdba

SQL>shutdown immediate;

B801#ps -ef | grep ora

B801#varyoffvg datavg801

B801#varyoffvg datavg802

(15)启用HA接管数据库资源，并再次进行HA测试，测试HA切换时能否正常接管和启停数据库。

B801# smit clstart(now)

B801#ifconfig -a

B801#lsvg -o

B801#ps -ef | grep ora

B801#lsnrctl status listener_ora101

B802# smit clstart(now)

B802#ifconfig -a

B802#lsvg -o

B802#ps -ef | grep ora

B802#lsnrctl status listener_ora102

B802#smit clstop

B801#ifconfig -a

B801#lsvg -o

B801#ps -ef | grep ora

B801#lsnrctl status listener_ora101

B801#lsnrctl status listener_ora102

B802#smit clstart(now)

B802#ifconfig -a

B802#lsvg -o

B802#ps -ef | grep ora

B802#lsnrctl status listener_ora102

B801#ifconfig -a

B801#lsvg -o

B801#ps -ef | grep ora

B801#lsnrctl status listener_ora101

B801#smit clstop(takeover)

B802#ifconfig -a

B802#lsvg -o

B802#ps -ef | grep ora

B802#lsnrctl status listener_ora101

B802#lsnrctl status listener_ora102\