Oracle Patchset query

[former_member759680]

We need to upgrade to Oracle patchset 10.2.0.4 from 10.2.0.2 on 32-bit Windows.

On service market place I found the following files for this :

10204_Patch20_WIN32.zip Size 91436 KB

10204_Patch22_WIN32.zip Size 91849 KB

BIN Patchset_10204_Win32aa.bin Size 358400 KB

BIN Patchset_10204_Win32ab.bin Size 358400 KB

BIN Patchset_10204_Win32ac.bin Size 293572 KB

Could you tell me, if I need the .bin files as well as the .zip files

Note - 1137346 says that only .zip files are needed.

Could you please clarify this doubt?

And Note - 839187 says - To apply the patch set, follow the instructions in the patch set README file.

But there is not readme file on service market place.

Thanks.

Edited by: Gautam Poddar on Aug 27, 2009 10:39 AM

Edited by: Gautam Poddar on Aug 27, 2009 10:41 AM

[Former Member]

Gautam,

Basically to upgrade from 10.2.0.2 to 10.2.0.4 there are centain steps.

1. Upgrade it from 0.2 to 0.4 which you can do through DBUA if you want to upgrade with your existing instance or use RunInstaller for new instance.

2. After that you need to apply Patch collections / Interim patches on top of 10.2.0.4. These Zip files probably talk about this only.

3. Then you need to apply Critical Patch Update (CPU) to bring it at per.

Hope this will help.

Thx

[former_member759680]

OK.

So, to upgrade from 10.2.0.2 to 10.2.0.4 where do I find the necessary patchset.

I thought this is teh patch set to upgrade from 0.2 to 0.4

Is there some document that will guide me through this process?

Thanks.

[Former Member]

Since the scenario changes from case to case basis, you won't get definite standard guidlines. U have to download all files, unzip and then go through readme files only. From there only you can collate and finalise the roadmap. There are 6 files downloadable from service marketplace for your case. Generic file is clear but among other 5 files, please go through readme files.

[Former Member]

Hi Gautam,

Take the zip file only.The readme file you will get after unzip the file.

Regards

Ashok Dalai

[former_member759680]

So, I downloaded the 2 .zip files.

But the README file says -

1 Ensure that your Oracle Database installation is the same release for which you are applying this patch. In other words, only apply the Release 10.2.0.4 Bundle patch to an Oracle Database Release 10.2.0.4

Now, we are at 10.2.0.2.

So to bring us to patch level 10.2.0.4, we are supposed to apply the above 2 .zip files, right?

But the README says you can apply these patches only if you are already at 10.2.0.4

Could you please clarify this?

Thanks.

[Former Member]

Hi Gautam,

You should be at oracle 10.2.0.4 before applying the patch set for 10.2.0.4.

You apply the oracle patch 4 first then the patch sets.

Regards

Ahok Dalai