Oracle-L: RE: Valid Packages/Procedures/Triggers that are NOT

From: Tony Johnson <Tony_Johnson_at_trimble.com>
Date: Tue, 25 Nov 2003 12:09:34 -0800
Message-ID: <F001.005D7CAD.20031125120934@fatcity.com>

We have been seeing this ever since we went to 9i and in multiple calls to Oracle support they have not been of much help.

Most of the time we get an error dump in udumo and things go on there merry way. A couple of times the packages go invalid and wont work but when looking at them thru OEM or other ways they all appear to be vaild. We do a complete recompile of everything and we are back up and running.

-----Original Message-----
VICTORIA_PIERCE_at_rsausa.com
Sent: Tuesday, November 25, 2003 12:34 PM To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Tony Johnson
INET: Tony_Johnson_at_Trimble.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 Tue Nov 25 2003 - 14:09:34 CST