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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 12 Jul 2011 12:12:51 +0100
Message-ID: <CABe10sYOcQ1=Ao3vxVe-_aUdV5OpLQXYMOvJRJ95sqj6x5WiLQ_at_mail.gmail.com>

Who are the objects owned by? You should also query dba_registry for component status

On 12 Jul 2011 12:08, "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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 12 2011 - 06:12:51 CDT