Before upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below .
SQL> select comp_name,version,status from dba_registry;
…
Oracle Real Application Clusters
11.2.0.3.0 INVALID
select value from v$option where parameter = ‘Real Application Clusters’;
VALUE
——
FALSE
Now please rerun $ORACLE_HOME/rdbms/admin/catclust.sql to recreate RAC associated views and validates the Oracle Real Application Clusters registry.
If still the issue continue please perform the following
EXECUTE dbms_registry.loading(‘RAC’,’Oracle Real Application Clusters’,’dbms_clustdb.validate’);
BEGIN
dbms_registry.loaded(‘RAC’);
dbms_clustdb.validate;
END;
Now Check the result, it should show VALID status now
SQL> select comp_name,version,status from dba_registry;
…
Oracle Real Application Clusters
11.2.0.3.0 VALID