and output of utlusts for comparison! aux SYS > @utlusts Enter value for 1: . Oracle Database 10.2 Upgrade Status Utility 07-12-2011 12:37:58 . Component Status Version HH:MM:SS Oracle Database Server INVALID 10.2.0.2.0 00:17:34 JServer JAVA Virtual Machine VALID 10.2.0.2.0 00:01:45 Oracle XDK VALID 10.2.0.2.0 00:00:25 Oracle Database Java Packages VALID 10.2.0.2.0 00:00:20 Oracle Data Mining INVALID 10.2.0.2.0 00:00:16 INVALID 10.2.0.2.0 00:02:56 Oracle Expression Filter VALID 10.2.0.2.0 00:00:14 Oracle Enterprise Manager VALID 10.2.0.2.0 00:00:57 Oracle Rule Manager INVALID 10.2.0.2.0 00:00:04 . Total Upgrade Time: 00:24:36 PL/SQL procedure successfully completed. On 12 July 2011 12:31, Howard Latham <howard.latham@xxxxxxxxx> wrote: > 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 > > -- Howard A. Latham Sent from my Nokia N97