| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Invalid Package under SYS
It is not that unusual to find invalid objects under the SYS ID. Generally
the objects fail into one of the following:
1- objects created by an optional dbms* script that is not ran as part of the catalog/catproc installation and upgrade scripts and for which the feature was either not installed or all the necessary optional scripts were not ran. Advanced Replication often fails into this category.
2- Left over but now obsolete objects from prior versions.
3- User created objects under the SYS schema that reference a v$, x$, or dba view that has been changed.
In all cases try to manually compile the invalid object and check the error messages. The messages should help clue you in to if you have a real problem or one of the above situations. For the above you can normally drop the object though in case 3 you might want to go ahead and fix the code. For case 2 you can scan the $ORACLE_HOME/rdbms/admin directory and the .bsq file for the object. Failure to find the object is a pretty good indication it is not valid anymore.
You can post a list of the objects and ask if people recognize what feature they are associated with.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Juan Cachito Reyes
Pacheco
Sent: Monday, April 26, 2004 6:31 PM
To: oracle-l_at_freelists.org
Subject: Re: Invalid Package under SYS
Hi, You MUST connect as SYS (or similar privileges) to recompile sys objects :)
Juan Carlos Reyes Pacheco
OCP
Database 9.2 Standard Edition
----- Original Message -----
From: "Jacques Kilchoer" <Jacques.Kilchoer_at_quest.com>
To: <oracle-l_at_freelists.org>
Sent: Monday, April 26, 2004 6:07 PM
Subject: RE: Invalid Package under SYS
Then refer to the first part of my answer. Do you really need these = packages to be valid? Are you getting errors in a portion of your = application? If not, let them (un)happily live as invalid packages. In = the 8.1.7 database on my local PC I have about 5 (five) invalid SYS = packages and it doesn't prevent me from doing whatever I want to do in = it.
Does dba_errors show anything for these invalid packages?
> -----Original Message-----
> Hamid Alavi
>=20
>=20
>=20
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Apr 27 2004 - 08:25:05 CDT
 |
 |