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:40:06 +0100
Message-ID: <CAPCNhx0exfmU1OjTYstdnRC-ZVDNMp=sj0PKJBaekB3JTj28EQ_at_mail.gmail.com>

and output of utlusts for comparison!
aux SYS > _at_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_at_gmail.com> 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_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
>
>

-- 
Howard A. Latham

Sent from my Nokia N97

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

Received on Tue Jul 12 2011 - 06:40:06 CDT