Forum Discussion

knguessan's avatar
knguessan
Level 4
5 years ago

Cluster failover fail due to listener

Hi

I configure two database on two system, one database production and one database test.

Find configuration details on main.cf files attached. Due to two listener entry database can startup on system.

[root@srv-cui-db-01 ~]# hagrp -state
#Group Attribute System Value
ClusterService State srv-cui-db-01 |ONLINE|
ClusterService State srv-cui-db-02 |OFFLINE|
ORACLE-ASM-VXVM State srv-cui-db-01 |ONLINE|
ORACLE-ASM-VXVM State srv-cui-db-02 |OFFLINE|FAULTED|
ORACLE-ASM-VXVM-TEST State srv-cui-db-01 |ONLINE|
ORACLE-ASM-VXVM-TEST State srv-cui-db-02 |OFFLINE|FAULTED|
cvm State srv-cui-db-01 |ONLINE|
cvm State srv-cui-db-02 |ONLINE|

 

 

 

    • CliffordB's avatar
      CliffordB
      Level 4

      At first glance the main.cf looks ok.

       

      Can you attach engine_A.log file?  That is where one finds details on what happens in a cluster.   One common reason for failure is forgetting to register DNS entries for the listener and making sure the IP is valid on both hosts (ie the hosts network card is configured to work on that subnet).