invalid objects in sys

[mkey]

Hi all,
I have some invalid package body in sys user. I tried compiling it with no luck. I suppose I could get the script from another database and run against this database. If so can someone tell me the steps involved. Below are the listed package bodies that has invalid objects in them. The funny thing is the the corresponding package in packages seems to have valid objects. How can this be?

DBMS_ASYNCRPC_PUSH
PACKAGE BODY

DBMS_DEFER_INTERNAL_SYS
PACKAGE BODY

DBMS_DEFER_SYS_PART1
PACKAGE BODY

DBMS_IAS_MT_INST
PACKAGE BODY

DBMS_REPCAT_MIG_INTERNAL
PACKAGE BODY

DBMS_REPCAT_RGT
PACKAGE BODY

Thank you!!

 

[karluk]

If recompiling doesn't make them valid, you probably have real errors that need to be corrected. I would start by finding out what the errors are. The SQL*Plus command to do this is (I may not have the syntax exactly right)

show errors package body DBMS_ASYNCRPC_PUSH

You may need to recreate the packages, but you probably won't need to import a script from another database. Catalog.sql and catproc.sql aren't the only catalog scripts. Most likely these invalid packages are in another script that you didn't run.

I can't do any research right now. If you still need help I'll look into it on Friday.

 

[carp]

If the packages refer to one another and you are doing
ALTER PACKAGE xyz COMPILE;
you are invalidating other packages when you try to compile. This is because the other packages are validated against the package specification; when you recompile the spec, you invalidate the other packages.

Try
ALTER PACKAGE xyz COMPILE BODY;

This will just recompile the body instead of the specification and body. This is the only thing I can think of (assuming nobody has been modifying/dropping SYS' primary objects!).