Oracle Real Application Clusters Component Showing “OPTION OFF”  

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.