How to Recreate RAC Oracle Components in Oracle 11gr2 Linux ?
Good morning,
I created the mistaken views of Rac by catclust.sql script in the SYSTEM schema, I am trying to recreate it in the correct schema SYS, but the error is occurring below:
SQL> ? / Rdbms / admin / catclust
Package created.
Package body created.
BEGIN dbms_registry.loading ('RAC', 'Oracle Real Application Clusters', 'dbms_clustdb.validate') END;
*
ERROR at line 1:
ORA-39704: permission to modify component registry entry denied
ORA-06512: at "SYS.DBMS_REGISTRY", line 86
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_REGISTRY", line 408
ORA-06512: at line 1
After running the script gets the component by LOADING status, as follows:
I created the mistaken views of Rac by catclust.sql script in the SYSTEM schema, I am trying to recreate it in the correct schema SYS, but the error is occurring below:
SQL> ? / Rdbms / admin / catclust
Package created.
Package body created.
BEGIN dbms_registry.loading ('RAC', 'Oracle Real Application Clusters', 'dbms_clustdb.validate') END;
*
ERROR at line 1:
ORA-39704: permission to modify component registry entry denied
ORA-06512: at "SYS.DBMS_REGISTRY", line 86
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_REGISTRY", line 408
ORA-06512: at line 1
After running the script gets the component by LOADING status, as follows:
0