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

From: Howard Latham <howard.latham_at_gmail.com>
Date: Tue, 12 Jul 2011 12:31:15 +0100
Message-ID: <CAPCNhx1f-sMTSEidNXbgZAp5cGWmX6fe69xcGkoyYO9CmbzbAQ_at_mail.gmail.com>

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_at_gmail.com> 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_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
>
>

-- 
Howard A. Latham

Sent from my Nokia N97

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 12 2011 - 06:31:15 CDT