Oracle在HP RX6600小機上實現HA後的測試方法

使用的命令：
cmviewcl：檢視節點狀態
cmrunnode：執行節點
cmhaltnode -f：掛起節點
cmrunpkg：執行package
cmruncl -f：執行叢集
ps -ef|grep ora_：檢視當前Oracle是否執行

步驟：
1、使用cmviewcl檢視節點狀態和Oracle在哪個節點上執行，下面顯示2個節點zjop01和zjop02都為up狀態，zjoppkg執行在zjop01節點上，即Oracle執行在zjop01節點上。
zjop01#[/]cmviewcl

CLUSTER        STATUS
cluster_zjop   up

NODE           STATUS       STATE
zjop01         up           running

    PACKAGE        STATUS        STATE         AUTO_RUN     NODE
    zjoppkg        up            running       enabled      zjop01

NODE           STATUS       STATE
zjop02         up           running

2、檢視Oracle當前在zjop01節點上是否正常執行，結果顯示正常。
zjop01#[/]ps -ef|grep ora_
oracle 21457     1 0 13:55:30 ?         0:00 ora_q001_zjdb
oracle 21455     1 0 13:55:30 ?         0:00 ora_q000_zjdb
oracle 21390     1 0 13:55:14 ?         0:00 ora_dbw0_zjdb
oracle 21384     1 0 13:55:14 ?         0:00 ora_pmon_zjdb
oracle 22991     1 0 14:35:24 ?         0:00 ora_j000_zjdb
    root 23002 14155 0 14:36:20 pts/0     0:00 grep ora_
oracle 21392     1 0 13:55:15 ?         0:00 ora_lgwr_zjdb
oracle 21398     1 0 13:55:15 ?         0:00 ora_reco_zjdb
oracle 21404     1 0 13:55:15 ?         0:00 ora_cjq0_zjdb
oracle 21406     1 0 13:55:15 ?         0:00 ora_mmon_zjdb
oracle 21394     1 0 13:55:15 ?         0:00 ora_ckpt_zjdb
oracle 21386     1 0 13:55:14 ?         0:00 ora_psp0_zjdb
oracle 21408     1 0 13:55:15 ?         0:00 ora_mmnl_zjdb
oracle 21388     1 0 13:55:14 ?         0:01 ora_mman_zjdb
oracle 21414     1 0 13:55:20 ?         0:00 ora_qmnc_zjdb
oracle 21396     1 0 13:55:15 ?         0:00 ora_smon_zjdb

3、使用cmhaltnode命令掛起zjop01節點，紅色為一次出錯的輸出資訊，透過shutdown -ry 0重啟zjop01，然後cmruncl -f再啟動叢集的方法解決了問題，出現問題的原因暫時未知。藍色為執行正常的資訊。
zjop01#[/]cmhaltnode -f zjop01
Disabling all packages from starting on nodes to be halted.
Warning: Do not modify or enable packages until the halt operation is completed.
Disabling automatic failover for failover packages to be halted.
Halting package zjoppkg
The package script. for zjoppkg failed with no restart. zjoppkg should not be restarted
Unable to halt package zjoppkg
Check the syslog and pkg log files for more detailed information

zjop01#[/]cmhaltnode -f zjop01
Disabling all packages from starting on nodes to be halted.
Warning: Do not modify or enable packages until the halt operation is completed.
Disabling automatic failover for failover packages to be halted.
Halting package zjoppkg
Successfully halted package zjoppkg
Waiting for nodes to halt ..... done
Successfully halted all nodes specified.
Halt operation complete.

4、使用cmviewcl檢視當前節點狀態，顯示zjop01節點已經掛起，zjoppkg在zjop02上執行起來，即資料庫已經在zjop02上執行。
zjop01#[/]cmviewcl

CLUSTER        STATUS
cluster_zjop   up

NODE           STATUS       STATE
zjop01         down         halted
zjop02         up           running

    PACKAGE        STATUS        STATE         AUTO_RUN     NODE
    zjoppkg        up            running       enabled      zjop02

5、rlogin到zjop02，ps -ef|grep ora_檢視oracle程式，以下顯示Oracle程式正常，到此實現HA切換成功。
zjop02#[/]ps -ef|grep ora_
oracle 25829     1 0 17:03:57 ?         0:00 ora_reco_zjdb
oracle 25815     1 0 17:03:57 ?         0:00 ora_pmon_zjdb
oracle 25835     1 0 17:03:57 ?         0:00 ora_mmnl_zjdb
oracle 25833     1 0 17:03:57 ?         0:00 ora_mmon_zjdb
oracle 25897     1 0 17:04:14 ?         0:00 ora_q001_zjdb
oracle 25819     1 0 17:03:57 ?         0:01 ora_mman_zjdb
    root 26083 26067 1 17:09:38 pts/1     0:00 grep ora_
oracle 25831     1 0 17:03:57 ?         0:00 ora_cjq0_zjdb
oracle 25825     1 0 17:03:57 ?         0:00 ora_ckpt_zjdb
oracle 26023     1 0 17:09:05 ?         0:00 ora_j000_zjdb
oracle 25823     1 0 17:03:57 ?         0:00 ora_lgwr_zjdb
oracle 25817     1 0 17:03:57 ?         0:00 ora_psp0_zjdb
oracle 25827     1 0 17:03:57 ?         0:00 ora_smon_zjdb
oracle 25821     1 0 17:03:57 ?         0:00 ora_dbw0_zjdb
oracle 25895     1 0 17:04:14 ?         0:00 ora_q000_zjdb
oracle 25883     1 0 17:04:04 ?         0:00 ora_qmnc_zjdb

6、使用cmrunnode zjop01，啟動節點zjop01，然後使用cmviewcl檢視，顯示zjop01節點已經執行，zjoppkg執行在zjop02上。
zjop02#[/]cmrunnode zjop01
cmrunnode: Validating network configuration...
cmrunnode: Network validation complete
cmrunnode: Validating cluster lock disk .... Done
Waiting for nodes to join ..... done
Cluster successfully formed.
Check the syslog files on all nodes in the cluster to verify that no warnings occurred during startup.
zjop02#[/]cmviewcl

CLUSTER        STATUS
cluster_zjop   up

NODE           STATUS       STATE
zjop01         up           running
zjop02         up           running

    PACKAGE        STATUS        STATE         AUTO_RUN     NODE
    zjoppkg        up            running       enabled      zjop02

7、使用cmhaltnode -f zjop02掛起zjop02節點，使得zjop01節點接管Oracle程式，然後再cmrunnode zjop02啟動zjop02節點，恢復到測試前的狀態。
zjop02#[/]cmhaltnode -f zjop02
Disabling all packages from starting on nodes to be halted.
Warning: Do not modify or enable packages until the halt operation is completed.
Disabling automatic failover for failover packages to be halted.
Halting package zjoppkg
Successfully halted package zjoppkg
Waiting for nodes to halt ... done
Successfully halted all nodes specified.
Halt operation complete.
zjop02#[/]cmviewcl

CLUSTER        STATUS
cluster_zjop   up

NODE           STATUS       STATE
zjop01         up           running

    PACKAGE        STATUS        STATE         AUTO_RUN     NODE
    zjoppkg        starting      starting      enabled      zjop01

NODE           STATUS       STATE
zjop02         down         halted
zjop02#[/]cmrunnode zjop02
cmrunnode: Validating network configuration...
cmrunnode: Network validation complete
cmrunnode: Validating cluster lock disk .... Done
Waiting for nodes to join ..... done
Cluster successfully formed.
Check the syslog files on all nodes in the cluster to verify that no warnings occurred during startup.
zjop02#[/]cmviewcl

CLUSTER        STATUS
cluster_zjop   up

NODE           STATUS       STATE
zjop01         up           running

    PACKAGE        STATUS        STATE         AUTO_RUN     NODE
    zjoppkg        up            running       enabled      zjop01

NODE           STATUS       STATE
zjop02         up           running