Re: upgrade from 10.2.0.1 to 10.2.0.2 gives 100s of invalid objects
- From: Ram Srinivasan <srinivasanram2004@xxxxxxxxx>
- To: howard.latham@xxxxxxxxx
- Date: Tue, 12 Jul 2011 20:24:42 -0400
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@xxxxxxxxx>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
Other related posts:
