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