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

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Sun, 17 Jul 2011 13:19:57 +0200
Message-ID: <CAP50yQ-Tw0-b4uW2hA_h73zkMOP8jE7rW-oJn2CMtp0geOkF3g_at_mail.gmail.com>

If you can afford the downtime, drop and re-create the database using only the options you actually need. There's a nice doc on metalink (733824.1) that shows step-by-step how to do this using TTS, thus minimizing the time needed. I've done this several times, because having this many options really increases the chances of something going wrong during upgrades.

And have you tried to re-start in UPGRADE mode, and simply re-running catupgrd one more time ? That often helps. Make sure you log its output, and if something goes wrong, look at the first couple errors that occur.

And I see you mention your plan is to actually move to 11g -- then why botehr with 10.2.0.2 ? IIRC you can go directly to 11g from anything above 9.2.0.8 (there's a matrix that illustrates this in the upgrade guide of each target release if I'm not mistaken).

Stefan

---

Stefan P Knecht
CEO & Founder
s_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

---

On Tue, Jul 12, 2011 at 1:06 PM, 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
>
>

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

Received on Sun Jul 17 2011 - 06:19:57 CDT