Re: upgrade from to gives 100s of invalid objects

  • From: Howard Latham <howard.latham@xxxxxxxxx>
  • To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • Date: Tue, 12 Jul 2011 12:31:15 +0100

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

Oracle Database Packages  VALID
and Types

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

JServer JAVA Virtual Mach VALID

Oracle XDK                VALID
Oracle Database Java Pack VALID

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: