Re: upgrade from 10.2.0.1 to 10.2.0.2 gives 100s of invalid objects

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
> ==============
>
>
> On Tue, Jul 12, 2011 at 7:06 AM, Howard Latham <howard.latham_at_gmail.com>wrote:
>
>> Platform Redhat Linux
>>
>> 3 Databases on 1 box 2 dbs upgraded ok the other one very old - was once
>> v7 has hundreds of invalid objects
>> and status of server component invalid.
>>
>> Can't downgrade as the other 2 are ok.
>>
>> I have logged an SR and we have tried uninstalling and reinstalling
>> components,
>>
>> Ideas seem to have run out.
>>
>> I wonder wherher the 'inavalidity' Matters if all the queries we do work
>> ok.
>>
>> I also wonder whether I should just go ahead and upgrade to 11 which was
>> why we started upgrade in first place.
>>
>> This DB is 500gigs of data.
>>
>>
>> Thoughts ?
>>
>>
>> --
>> Howard A. Latham
>>
>> Sent from my Nokia N97
>>
>>
>
>
> --
> Sincerely
> Ram Srinivasan
>

-- 
Howard A. Latham

Sent from my Nokia N97

--
http://www.freelists.org/webpage/oracle-l