-
Errors during recomp PLS-00201
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
-
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
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Aren't you using sys user for recompiling?
-
SQL> select status from dba_objects where owner='SYS' and object_name='DBMS_REGISTRY_SYS';
STATUS
-------
VALID
VALID
SQL> sho user
USER is "SYS"
-
First thing why do you want to recompile the valid objects?
Which scripts are you using to recompile the objects?
-
Please check following packages are valid:
SYS.DBMS_REGISTRY
SYS.DBMS_REGISTRY_SYS
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
-
I would recreate the catalog
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
What do you mean by recreate catalog?do you mean re-run the catalog script
once again.Can you please more specific.
Thanks
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|