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

Nial funnily enough a query of dba_registry give a better result that
utllusts which is run at the end of the upgrade

COMP_NAME                 STATUS
------------------------- -----------
Oracle Enterprise Manager VALID
Spatial                   VALID
Oracle Expression Filter  VALID
Oracle Rule Manager       INVALID
Oracle Workspace Manager  VALID
Oracle Data Mining        VALID
Oracle Database Catalog V VALID
iews

Oracle Database Packages  VALID
and Types

COMP_NAME                 STATUS
------------------------- -----------

JServer JAVA Virtual Mach VALID
ine

Oracle XDK                VALID
Oracle Database Java Pack VALID
ages

OLAP Analytic Workspace   REMOVED
Oracle OLAP API           REMOVED

I wonder which one I should believe, and why Oacle Tech Support didnt
suggest a query of this instead.


On 12 July 2011 12:12, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:

> 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@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
>
>


-- 
Howard A. Latham

Sent from my Nokia N97

Other related posts: