Upgrading from 10.2.0.2.0 to 10.2.0.4.0

[Former Member]

Hi,

I am planning to upgrade Oracle from 10.2.0.2.0 to 10.2.0.4.0.

Should I need to install Oracle instantclinet 10.2.0.2? If can I apply after applying the 10.2.0.2.0 patches(Database Server Version 10.2.0.2 Patch 17 and Patche 18).

Similarly Can you please tell me when should I apply Generic patches?

Can you please gudie me what sequence should I need to follow?

I have downloaded the following Oracle Patches

10.2.0.2.0(p6731569_10202_MSWIN-x8664,p7213942_10202_MSWIN-x8664), 10.2.0.4.0(p7715057_10204_MSWINx8664, p8307238_10204_MSWINx8664),

generic patches for 10.2.0.2.0

(p4638550_10202_GENERIC

p4773931_10202_GENERIC

p4864648_10202_GENERIC

p5635254_10202_GENERIC

p6005996_10202_GENERIC

p6046043_10202_GENERIC

p6435823_10202_GENERIC

p5635254_10202_classes12 jarfile

p5635254_10202_ojdbc14 jarfile)

& 10.2.0.4.0(p7592030_10204_WIN_GENERIC), Oracle instantclinet(OCL10264.sar) and

Patchset_10204_MSWIN-x86-64aa.bin

Patchset_10204_MSWIN-x86-64ab.bin

Patchset_10204_MSWIN-x86-64ac.bin

Thanks and Regards

Satya

[Former Member · Accepted solution]

Hi,

In addition to above, check below links.

Thanks

Sushil

[Former Member]

Hi,

Please check SAP Note 839187 (Oracle 10.2.0: Applying patch set/patches/patch collection). This note contains important information about applying the current Oracle RDBMS patch sets, the required patches (UNIX), or the patch collection (Windows) and the CPU (UNIX) for Oracle 10.2.0.4.

On Windows, you can apply a patch collection and apply additional generic patches if required. For information about the current patch collection and the generic patches, see SAP Note 1137346 (Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.4).

The installation instructions for the current patch set, patches (UNIX), or the patch collection (Windows) and the CPUs (UNIX) are provided in the relevant README file.

Go through the README file to check whether the Oracle InstantClient needs to be upgraded. I think you will require to uograde the same to 10204 as well.

To use Oracle Release 10.2.0.4 with SAP on Windows platforms, you require at least Oracle patch collection 5. In general, use the most recent patch collection.

On Windows, you can apply a patch collection and additional generic patches if required.

Please go through README.html to find out the sequence of steps you need to follow.

regards,

Subhajit.

[markus_doehr2]

The sequence would be:

- Upgrade the database server to 10.2.0.4

- Install the latest interim patch for 10.2.0.4

- Install the generic patches

- Update your instantclient to 10.2.0.4.x

See

Note 871735 - Current patch set for Oracle 10.2.0

Note 1137346 - Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.4

Markus

[Former Member]

Hi Markus,

Please see the log

Installed Top-level Products (2):

Oracle Database 10g 10.2.0.1.0

Oracle Database 10g Release 2 Patch Set 1 10.2.0.2.0

There are 2 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

-

---

OPatch succeeded.

I known the patches are cumulative. There are no interim patches are applied for 10.2.0.2.0. Can I go ahead and install patches for 10.2.0.4.0 with out applying any patches for 10.2.0.2.0

Please advice on this.

Thanks and Regards

Satya

[markus_doehr2]

> I known the patches are cumulative. There are no interim patches are applied for 10.2.0.2.0. Can I go ahead and install patches for 10.2.0.4.0 with out applying any patches for 10.2.0.2.0

Yes.

Install 10.2.0.4 and then install the latest interim patch for 10.2.0.4.

Markus

[Former Member]

hi,

i installed the last PSU(9352164) but the instance is 10.2.0.4.0. why is not 10.2.0.4.4?

thanks for advance.

ferhan

Edited by: Ferhan Tekin on May 28, 2010 5:22 PM

[fidel_vales]

Hello,

Current PSUs do not change the version number (info in metalink doc)

I has told that Oracle will start doing it in 11gR2 (I'll believe when i see it)