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

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

Other related posts: