Re: Oracle Upgrade Question or Issue?

amerar_at_iwc.net wrote:
> Hi All,
>
> I have a question or concern about our recent upgrade from 9.2.0.4 to
> 9.2.0.7.
>
> Our tech group is running the upgrade. They ran the patchset 4163445,
> which is the upgrade from 9.2.0.4 to 9.2.0.7.
>
> Following that they ran the patches 4533592 & 5049060. The patch
> 5049060 aborted with some error. When the enter SQLPLUS is says it is
> version 9.2.0.5.
>
> So, I have to go into work and look at what the error was. What my
> concern is, is that although I can rollback the patches, can I rollback
> the upgrade? It seems that it was not applied properly if it still
> shows 9.2.0.5. Can I re-run the upgrade again? Will it corrupt
> things if I run the upgrade again? It is like installing Windows on
> top of itself, where you can do it many times?
>
> I'd really appreciate some advice. Does anyone have any ideas?
>
> Thanks!

Amerar, did you backup the database before the upgrade. Or I guess I should ask if your technical group backed it up - JUST IN CASE?

Although I know it happens, I have to say this is new to me. I've NEVER had an Oracle patchset or security patch bomb out on me in several years doing them on both HP-UX and Windows.

I'd be interested to see where this goes and what the other people who have dealt with this have to say.

Whenever I do these things, I always backup everything just in case it bombs out - that way I know I can just do a quick restore. Never had to use 'em, YET.

Charles R. Whealton
Charles Whealton @ pleasedontspam.com Received on Sun Aug 27 2006 - 07:56:37 CDT