Query in Oracle 10.2.0.2 Patch application

[Former Member]

Hi All,

I need to apply patch for Oracle 10.2.0.2 on HP-Unix IA 64-bit server and when i saw SAP Marketplace, found latest CPU Patch of Janauary 2008 (p6646850_10202_HPUX-IA64) as per note # 1140644.

Along with this i also found 1 note mentioning about Optimizer merge fix patch application as per OSS note # 981875 and so downloaded file p7608184_10202_HPUX-IA64.zip, which is relevant to it.

Now when i read note # 981875 , i found that, it clashes with above mentioned CPU patch and want this to uninstall it and then apply Optimizer patch. And no where then it is mentioning to apply CPU patch again.

So i want to know, do i required now only to apply only Optimizer merger fix patch and not CPU Patch as per 981875 note. Just fyi...CPU patch is of Jan 2008 & Optimizer fix patch is of 01/12/2009?

Please let me know, how to go about it, if anyone has already done this.

Thanks for your answers in advance

[Former Member · Accepted solution]

Hai,

The answer is already in the SAP Note 1140644.

'We recommend that ALL SAP customers import the CPU patch only if it is absolutely necessary'

Risks:

The main risk when you install the CPU is that, as soon as SAP provides a new patch, this patch could clash with the CPU (it may not clash). If a clash occurs, you must decide between the CPU and the new patch.

The reason for the clash is the fixes which you apply from the patch as per SAP Note 981875 are already there in the system after the Installation of the CPU, according to SAP, CPU is a fix for security-related areas.

When you install the CPU patch, you will be informed that this patch is part of the CPU (# are included in the patch currently being installed (6646850). If you continue, they will be rolled back and the new patch (6646850) will be installed ...).

As far as I know, It is better to apply only the Optimizer merge fixes not the CPU once again.

Regards,

Yoganand.V

[Former Member · Accepted solution]

Thanks Yogaanand, this has cleared little bit of my concerns.

Have you applied this and checked the Oracle performance? My main intention is to have Smooth working of Oracle, by applying latest patches of 10.2.0.2....So just by applying Optimizer patches will work?

Also, thanks Fidel for your comments. But as of now i'm not planning to move to 10.2.0.4....as my base SAP Applications all are running on 10.2.0.2.

[Former Member · Accepted solution]

Hai,

No, we dont have any systems on Oracle 10g, still we are in 9i.

I guess it should not be a problem, but it is better to patch a DEV system first and then after analysing the system you can go for the critical systems in the landscape.

Regards,

Yoganand.V

[Former Member]

Hi

Is your problem solved? If yes, what is the method or sequence you have followed.

Please advice as we may have to update 10.2.0.2 to 10.2.0.4 on Unix ia 64.

Regards,

MSR.

[stefan_koehler]

Hello Srinivasa,

just follow the advice of Fidel Vales... this should be the best way.

Regards

Stefan

[fidel_vales]

Hi,

the best option for you can be

1) install patch set 10.2.0.4

2) install all patches from note 1137346

3) apply the CPU for 10.2.0.4

4) adjust the oracle parameters

In 10.2.0.4 the CPUs patches have changed and it is more difficult to get a conflict.

If there is a conflict, only one part of the CPU is not installed.

the CPU January 2009 is released (SAP note 1295141)