Errors during recomp PLS-00201

[areeb]

Hi,
After an full import when trying to recompile objects i am getting the following error .VERSION 10202 hpux-11.23
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_REGISTRY_SYS.VALIDATE_COMPONENTS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Thanks

[PAVB]

1- Check if Oracle package SYS.DBMS_REGISTRY_SYS is there and, if it's valid.

2- Check if the owner of the offending object has EXECUTE privilege granted on package SYS.DBMS_REGISTRY_SYS

[dbasan]

Aren't you using sys user for recompiling?

[areeb]

SQL> select status from dba_objects where owner='SYS' and object_name='DBMS_REGISTRY_SYS';

STATUS
-------
VALID
VALID

SQL> sho user
USER is "SYS"

[dbasan]

First thing why do you want to recompile the valid objects?

Which scripts are you using to recompile the objects?

[PAVB]

Please check following packages are valid:

SYS.DBMS_REGISTRY
SYS.DBMS_REGISTRY_SYS

[areeb]

I am trying to recompile the objects after doing migration from 9204 to 10202

SQL> select object_type ,status from dba_objects where owner='SYS' and object_name='DBMS_REGISTRY';

OBJECT_TYPE STATUS
------------------- -------
PACKAGE VALID
PACKAGE BODY VALID

SQL> select object_type ,status from dba_objects where owner='SYS' and object_name='DBMS_REGISTRY_SYS';

OBJECT_TYPE STATUS
------------------- -------
PACKAGE VALID
PACKAGE BODY VALID

[PAVB]

I would recreate the catalog

[areeb]

What do you mean by recreate catalog?do you mean re-run the catalog script
once again.Can you please more specific.

Thanks

[Bore]

Exactly