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

Share this post
Recent Posts

Leave a Comment

Start typing and press Enter to search