Saturday, July 9, 2011

ORA-04063: package body "SYS.DBMS_REGISTRY_SYS" has errors while running utlrp...

SELECT dbms_registry_sys.time_stamp('utlrp_end') as timestamp from dual
*
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:
1.shutdown immediate
2.startup upgrade
3.run catalog and catproc scritp
4.run utlrp
5.shutdown immediate
6.startup
7.select comp_name,version,status from dba_registry;

3 comments:

Unknown said...

Thank you for posting this tip. It helped me resolve the ORA-04063 error I had encountered in my test system recently.

Best Regards,
JC

Amod Singh Gehlot said...
This comment has been removed by the author.
Amod Singh Gehlot said...

Is startup upgrade is important. Can't startup works directly?