After Oracle database migrated from Non-RAC to RAC environment, the oracle component “Oracle Real Application Clusters” shows “OPTION OFF”.
SQL> select COMP_NAME, VERSION,STATUS,SCHEMA from dba_registry;
COMP_NAME VERSION STATUS SCHEMA
---------------------------------------- ------------------------------ -------------------------------------------- --------------------
...
..
.
Oracle Database Catalog Views 12.1.0.2.0 VALID SYS
Oracle Database Packages and Types 12.1.0.2.0 VALID SYS
JServer JAVA Virtual Machine 12.1.0.2.0 VALID SYS
Oracle XDK 12.1.0.2.0 VALID SYS
Oracle Database Java Packages 12.1.0.2.0 VALID SYS
OLAP Analytic Workspace 12.1.0.2.0 VALID SYS
Oracle OLAP API 12.1.0.2.0 VALID SYS
Oracle Real Application Clusters 12.1.0.2.0 OPTION OFF SYS
15 rows selected.
SOLUTION
Verify Real Application Clusters enabled at binary level
$ ar -t $ORACLE_HOME/rdbms/lib/libknlopt.a|grep kcsm.o kcsm.o
Returning “kcsm.o” indicates RAC binary has been enabled.
run script to recreate RAC associated views and validates rac registry
SQL> @?/rdbms/admin/catclust.sql
Verify the component status by executing the query on dba_registry
SQL> select COMP_NAME, VERSION,STATUS,SCHEMA from dba_registry;
COMP_NAME VERSION STATUS SCHEMA
---------------------------------------- ------------------------------ -------------------------------------------- --------------------
...
..
.
Oracle Database Catalog Views 12.1.0.2.0 VALID SYS
Oracle Database Packages and Types 12.1.0.2.0 VALID SYS
JServer JAVA Virtual Machine 12.1.0.2.0 VALID SYS
Oracle XDK 12.1.0.2.0 VALID SYS
Oracle Database Java Packages 12.1.0.2.0 VALID SYS
OLAP Analytic Workspace 12.1.0.2.0 VALID SYS
Oracle OLAP API 12.1.0.2.0 VALID SYS
Oracle Real Application Clusters 12.1.0.2.0 VALID SYS
15 rows selected.
Make DBA Life Easy 