| 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 dbms_shared_pool
This happened to me once - when I was mistakenly ran the script as SYSTEM
instead of SYS/internal. Any chance somebody did this on your DB (a long
shot I know)?
-----Original Message-----
Sent: 03 April 2003 00:19
To: Multiple recipients of list ORACLE-L
thanks Rich ,
is is hp-ux 8.1.6. db . I haven't tried alter package .. yet . Only thing
that's differnet is there was no patch or compilation in last few months .
How can the package become invalid one day .
-ak
> You don't say what version, but I've seen many SYS packages go invalid in
> 8.1.x on HP/UX, especially after patching or installing a new
option/feature
> like Oracle Text. I've found that attempting to revalidate them either by
> hand or by running ?/rdbms/admin/utlrp.sql is futile. One gets fixed and
> five others break. Fix those five and three more break. Lather. Rinse.
> Repeat.
>
> For better or worse, the only way I've been able to consistently fix this
is
> to take the brute force approach and rerun the ?/rdbms/admin/whatever.sql
> script that created the packages that are now invalid in the order in
which
> they were originally run when the DB was created. Depending on which
> packages, this may be best left to off-hours.
>
> GL!
>
>
> Rich
>
> Rich Jesse System/Database Administrator
> rich.jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
>
> -----Original Message-----
> Sent: Wednesday, April 02, 2003 3:09 PM
> To: Multiple recipients of list ORACLE-L
>
>
> In one of our db i found that dbms_shared_pool package body is invalid .
Any
> idea why that could happen . It's not causing any problem . It's just
> appearing as one of invalid objects .
> In fact I am able to execute dbms_shared_pool.keep
> with out error . Looks like specification are intact .
>
> there was no package compilation in many days .
>
> Only thing i remeber is , we tried to set keep pool
> and i misspelled keep_pool ,( but does that cause invalidation , i dont
buy
> it )
>
> -ak
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: oramagic_at_hotmail.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions INET: tim.onions_at_speechmachines.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Apr 03 2003 - 05:38:38 CST
 |
 |