Re: Oracle Upgrade Concerns

From: <art_at_chicagorsvp.com>
Date: 23 Jun 2006 12:04:59 -0700
Message-ID: <1151089499.590494.202370@c74g2000cwc.googlegroups.com>

hpuxrac wrote:
> Greg wrote:
> > I use xml/xdb with my 9.2.0.7 database and have never had an issue with
> > upgrading, and my database started out at 9.2.0.4 and has been upgraded
> > to 9.2.0.5, 9.2.0.6 and 9.2.0.7.
> > So I'd say yes, I exepect patchset to go in cleanly.... you only have
> > to read and follow directions.
> >
> > -greg
>
> Problems appear to have been platform dependent. Maybe some platforms
> were clean.
>
> What platform are you running on?
>
> It would be nice to have the patchsets go in cleanly across all the
> platforms. Isn't that what we pay oracle support to deliver?
>
> But the quality assurance system appears to ... have some challenges
> and opportunities for improvement.

We are running on AIX 64, 5L.......however, this is the first time I have seen this ORA-0600. I do not remember seeing it before during other test upgrades with this patchset. Of course, I could have missed it. We are going to restore the server and try it again and see if the same thing happen.

One thing that is consistant is the INVALID status of all Materialized Views. Any idea why?? Received on Fri Jun 23 2006 - 14:04:59 CDT