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

From: Ram Srinivasan <srinivasanram2004_at_gmail.com>
Date: Tue, 12 Jul 2011 20:24:42 -0400
Message-ID: <CAKgSvf-d15dQz+PZRnyNa=dvio7WsTDB_sJXXmgfkaMac9Gbyw_at_mail.gmail.com>

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

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

Received on Tue Jul 12 2011 - 19:24:42 CDT