OPatch Upgrade 10.2.0.1.0 from 10.2.0.2.0

[Former Member]

Hi Experts !

As in our System have the Patch of 10.2.0.1.0 and Upgrade to 10.2.0.2.0. but unable to do facing an error.

Followed Steps :- 1. Shut down the DB 2. Oracle Services Stoped 3. Licenser stoped

Downloaded the MO Patch p7213942_10202_MSWIN-x8664.zip from SMP. Placed in Oracle Home directory . Before pasting Unzipped . and run the below command getting error.

F:\oracle\RES\102\OPatch\7213942>F:\oracle\RES\102\OPatch\OPatch apply

Invoking OPatch 10.2.0.1.0

Oracle interim Patch Installer version 10.2.0.1.0

Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home : F:\oracle\RES\102

Central Inventory : n/a

from : C:\Program Files\Oracle\Inventory

OPatch version : 10.2.0.1.0

OUI version : 10.2.0.1.0

OUI location : F:\oracle\RES\102\oui

Log file location : F:\oracle\RES\102\cfgtoollogs\opatch\opatch-30_May_22_20-08-

38-GMT+05_Sun.log

ApplySession applying interim patch '7213942' to OH 'F:\oracle\RES\102'

Apply Session failed: ApplySession failed to prepare the system. ApplySession: R

equired component(s) [ oracle.rdbms.rsf, 10.2.0.2.0 ] not present in the Oracle

Home or a higher version found.

System intact, OPatch will not attempt to restore the system

**OPatch failed with error code = 73**

**Please advise on above issue and do needful. What steps I need to follow to Upgrade the Patch of 10.2.0.2.0 .**

**Note :- As we do not want to Upgarde the patch of 10.2.0.4.0**

Please do needful.

Many Thanks !

Mai

[fidel_vales]

hi,

it looks you have a little issue with the concepts.

10.2.0.2 is a PATCHSET, it is NOT installed with OPatch.

10.2.0.2 contains a README.HTML file with the instructions to install it, please,read it (as its name indicates)

[Former Member]

Dear Fidel / Experts !

Thanks for your reply , As we have Oracle 10.2.0.1.0 and we want to upgrade to 10.2.0.2.0 As i checked readme file as well but it confusing could you pls send steps to upgrade the patch to 10.2.0.2.0.

Many Thanks !

Mai.

[Former Member]

<removed_by_moderator>

Do not copy & paste, always quote the source if relevant

Read the "Rules of Engagement"

Edited by: Juan Reyes on May 25, 2011 12:21 PM

[Former Member]

deeptss,

instead of doing a cut&paste job from section 6.1 of http://www.seas.ucla.edu/temp/oracle_upgrade.htm you had better provided a link.

And by the way, did you realize that your answer is for Unix, whereas mairajyounus is on Windows?

mairajyounus,

do a search like deeptss, and you should be able to find a more suitable guide yourself!

But, as already mentioned, start with the readme file.

hope this helps

[fidel_vales]

Dear Fidel / Experts !
> 
> Thanks for your reply , As we have Oracle 10.2.0.1.0 and we want to upgrade to 10.2.0.2.0 As i checked readme file as well but it confusing could you pls send steps to upgrade the patch to 10.2.0.2.0. 
> 
> Many Thanks !
> Mai.

Hi,

You do not have to "check" the README, you have to read it carefully and follow its instructions.

There you have a step by step.

Of course, if

1.- You do not have clear concepts

2.- You want someone to do it for you

3.- You want a guide with nice screen shots so you do not have to think, only "copy+paste"

Then you are in little of a problem.

My advise again

1.- READ the file

2.- Get some training

(I do not think that executing setup.exe and click "next" several times is so difficut