Oracle Restart 19 -- Managing a Database Fails with PRCR-1055 : Cluster membership check failed

Problem

When using Oracle Restart, and trying to add, start, stop, or check status of an Oracle Database, you get the errors below:

$ srvctl status database -db <db_unique_name>
PRCD-1024 : Failed to retrieve instance list for database <db_unique_name>
PRCR-1055 : Cluster membership check failed for node <hostname> 

Solution

Most probably the cause of the error is that the HOSTING_MEMBERS attribute is set:

# $GRID_HOME/grid/bin/crsctl stat res ora.<db_unique_name>.db -f | grep HOSTING_MEMBERS

HOSTING_MEMBERS=<some_hostname>

To fix the issue, reset the attribute:

# $GRID_HOME/grid/bin/crsctl modify resource "ora.<db_unique_name>.db" -attr "HOSTING_MEMBERS=" -unsupported