Re: upgrade from 10.2.0.1 to 10.2.0.2 gives 100s of invalid objects
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Sat, 16 Jul 2011 13:10:37 +0200
Message-ID: <CALH8A90zUMSzU-HTZTKcyPVNFsVn17_SDWGUexkWWGAfJoa_7A_at_mail.gmail.com>
Maybe you want to check
http://blogs.oracle.com/UPGRADE/entry/database_registry_component_dependencies and decide which components you can remove.
Date: Sat, 16 Jul 2011 13:10:37 +0200
Message-ID: <CALH8A90zUMSzU-HTZTKcyPVNFsVn17_SDWGUexkWWGAfJoa_7A_at_mail.gmail.com>
Maybe you want to check
http://blogs.oracle.com/UPGRADE/entry/database_registry_component_dependencies and decide which components you can remove.
Less objects might lead to less invalid objects? (and faster upgrade to 11.2 afterwards?)
hth,
Martin
On Wed, Jul 13, 2011 at 09:16, Howard Latham <howard.latham_at_gmail.com> wrote:
> this is after several runs of utlrp
>
> On 13 July 2011 01:24, Ram Srinivasan <srinivasanram2004_at_gmail.com> wrote:
>>
>> Howard:
>> Run the utlrp.sql from the $ORACLE_HOME/rdbms/admin/ directory. This
>> will recompile all the invalid objects. Check the invalid objects owned by
>> SYS, SYSTEM, and DBSNMP.
>> Ram Srinivasan
>> ==============
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jul 16 2011 - 06:10:37 CDT