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

From: Subodh Deshpande <deshpande.subodh_at_gmail.com>
Date: Tue, 12 Jul 2011 17:26:24 +0530
Message-ID: <CAJsOtB4JOLp-TUjuYxh7XZS4ffGV_kj=k7xsSMdLPPDLEZw4ag_at_mail.gmail.com>

I think at this moment what is the registry status and object status. Compare both list with pre upgrade registry status and object status. Did you used dbua or manual scripts. Check logs.

On 12 Jul 2011 17:11, "Howard Latham" <howard.latham_at_gmail.com> wrote:

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 ...

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

Received on Tue Jul 12 2011 - 06:56:24 CDT