SEO

#1 (**permalink**) 02-25-2008, 06:37 AM

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!

#2 (**permalink**) 02-25-2008, 06:37 AM

What are the errors you get? What platforms are you working on? OS
level etc?

#3 (**permalink**) 02-25-2008, 06:37 AM

amerar@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

#4 (**permalink**) 02-25-2008, 06:37 AM

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

After applying this patch, did they run the catpatch script? This is
fully docuemented in the patch instructions.

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

Care to elaborate on "some error"? It could be just about anything....

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

Have you read the documentation that came with the patchset? In it is a
set of instructions on how to roll things back. Additionally, one should
not apply any patch or patchset without having a good backup of the
database *and* the $ORACLE_HOME directory. That way, you can revert your
database *and* the Oracle software to a known "good" point.

HTH,
Brian

--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.

"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Oracle Upgrade Question or Issue?