PLS-00201: identifier 'DBMS_REGISTRY' must be declared
报错信息:
SQL> @?/rdbms/admin/catclust.sql
Package created.
Warning: Package Body created with compilation errors.
BEGIN dbms_registry.loading('RAC','Oracle Real Application Clusters','dbms_clustdb.validate'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_REGISTRY' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
场景:
11g,通过rman使单实例迁移到rac,恢复节点二,执行
SQL> @?/rdbms/admin/catclust.sql
命令时报错
解决:
后来发现执行SQL> @?/rdbms/admin/catclust.sql命令的用户并不是管理员用户,退出使用管理员登录即可解决;
SQL> exit
SQL> sqlplus / as sysdba
SQL> @?/rdbms/admin/catclust.sql