The original problem is that packages go invalid in the middle of the day with no upgrading going on, no physical changes happening in the database, nothing happening except the normal day-to-day operation of the system.
We have seen this happening since 8i. We recently upgraded to 92040 and I have seen it once in the last week where it produced a dump - I dont know how many times it happened where no dump was produced. In 92021 we could see it multiple times in a day. There is a problem out there that Oracle can't seem to recreate. -----Original Message----- Mladen Gogala Sent: Tuesday, November 25, 2003 1:44 PM To: Multiple recipients of list ORACLE-L NOT - Found word(s) to be removed remove home list error e-mail in the Text body. Victoria, there is a whole slew of bugs with upgrade and patch application. Here are two of them: Patch 3099699 Description REPCA: CATPATCH LEAVES RDBMS UNUSABLE (INVALID OBJECTS IN, LBACSYS [OLS]) Patch 2949941 Description RULES ENGINE OBJECTS BECOME INVALID AFTER UPGRADE There are quie a few others, not listed here. There was probably a SYS-owned object left invalid during upgrade, which caused dependency problems. Solution is to upgrade to 9.2.0.4 now that you've already upgraded to 9.2.0.1 and run $ORALCE_HOME/rdbms/utlirp to recompile all invalid objects in the database. It's always advised to so after any upgrade or patching of the database. On 11/25/2003 02:34:29 PM, [EMAIL PROTECTED] wrote: > We had a weird situation yesterday on a database that had been upgraded > from 8.1.6 to 9.2.0.1 over the weekend. Suddenly at 10:30 am, after being > in production for a day and a half, 93 previously VALID packages, package > bodies, triggers and procedures went INVALID. We have not been able to > figure out what made them go invalid (they were all in the same > application schema). Anyway, we recompiled all objects and all were then > marked as VALID. However, some of the code still failed to work; (as an > aside, we narrowed it down to those packages that contained ref cursors). > Since the packages were apparently VALID, we did not recompile them again > until after we bounced the database and generally chased our tails for a > couple of hours. In a last-ditch effort, we recompiled all the objects > again and the code started working. > > Do any of you know of a bug in 9i that would cause an INVALID package to > be marked VALID? Or, when is a VALID package really INVALID? > > Thanks for your input. > > Vicki Pierce > Database Administration > x2401 Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Tony Johnson INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).