SQL>@utlrp.sql
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors
BEGIN dbms_registry_sys.validate_components; END;
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_REGISTRY_SYS"
ORA-06512: at line 1
Solution:
SQL>conn sys as sysdba
SQL>shutdown immediate
SQL>startup upgrade
RUN catalog, catproc and utlrp script from SQL Prompt
SQL>shutdown immediate
SQL>startup
SQL>select comp_name,version,status from dba_registry;
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors
BEGIN dbms_registry_sys.validate_components; END;
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"SYS.DBMS_REGISTRY_SYS"
ORA-06512: at line 1
Solution:
SQL>conn sys as sysdba
SQL>shutdown immediate
SQL>startup upgrade
RUN catalog, catproc and utlrp script from SQL Prompt
SQL>shutdown immediate
SQL>startup
SQL>select comp_name,version,status from dba_registry;