Sunday, June 12, 2011

How to fix invalid "oracle database packages and types" ?

1)  exec dbms_registry.valid('CATPROC');
2)  @utlrp.sql
3)  SHUTDOWN IMEMDIATE
4)  STARTUP UPGRADE
5)  @catalog.sql
6)  @catproc.sql
7)  @utlrp.sql
8)  SHUTDOWN IMMEDIATE
9)  STARTUP
10) exec dbms_registry.valid('CATPROC');

OR

10)

set serverout on feedback on

BEGIN
dbms_registry.update_schema_list('CATPROC',   dbms_registry.schema_list_t('SYSTEM', 'OUTLN', 'DBSNMP'));
dbms_registry.loaded('CATPROC');
dbms_registry_sys.validate_catproc;
dbms_registry_sys.validate_catalog;
END;
/


No comments:

Post a Comment