| 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
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 servicesto: 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 Wed Apr 02 2003 - 16:28:38 CST
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |