Re: invalid dbms_shared_pool

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

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, April 02, 2003 2:28 PM

> 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).