Errors during recomp PLS-00201
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: Errors during recomp PLS-00201

  1. #1
    Join Date
    Jul 2005
    Posts
    87

    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

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Aren't you using sys user for recompiling?

  4. #4
    Join Date
    Jul 2005
    Posts
    87
    SQL> select status from dba_objects where owner='SYS' and object_name='DBMS_REGISTRY_SYS';

    STATUS
    -------
    VALID
    VALID

    SQL> sho user
    USER is "SYS"

  5. #5
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    First thing why do you want to recompile the valid objects?

    Which scripts are you using to recompile the objects?

  6. #6
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  7. #7
    Join Date
    Jul 2005
    Posts
    87
    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

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  9. #9
    Join Date
    Jul 2005
    Posts
    87
    What do you mean by recreate catalog?do you mean re-run the catalog script
    once again.Can you please more specific.

    Thanks

  10. #10
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Exactly

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width