Comparison between Oracle 10.2.0.2.0 and Oracle 10.2.0.4

[Former Member]

Hello Gurus,

Our client is using ECC 5.0, HP-UX B.11.00 A 9000/800 ,Oracle 10.2.0.2.0

i want to know if we upgrade their oracle database to patchset 10.2.0.4

1) What benefits (performance, security, stability) client will get?

2) What is the drawback if we don't upgrade system to 10.2.0.4 ?

3) What are the issues which has been covered in Oracle release 10.2.0.4 over 10.2.0.2

4) which one SAP recommends ?

Can someone please help me to answer these questions ?

Thanks in advance!

With Regards,

kuldeep Tanwar

[Former Member · Accepted solution]

1) What benefits (performance, security, stability) client will get?

A new patchset includes the latest bug fixes and fixes for performance issues (if you take care about the correct parameters for the DB as well). Therefore an update of Oracle is recommended as soon as it is supported by SAP.

2) What is the drawback if we don't upgrade system to 10.2.0.4 ?

Maybe you will face issues with bugs or performance problems due to missing Oracle patches.

3) What are the issues which has been covered in Oracle release 10.2.0.4 over 10.2.0.2

Check the corresponding SAP Notes in the OSS - the notes contain quite a lot of information. Check for example note 1165319 regarding fix information for 10.2.0.4.

4) which one SAP recommends ?

SAP recommends to use the latest available and supported patch set. Check the Oracle SDN site for further information:

Kind regards

[markus_doehr2]

> Our client is using ECC 5.0, HP-UX B.11.00 A 9000/800 ,Oracle 10.2.0.2.0

Just to add:

ECC 5.0 is out of maintenance, you should request your customer to upgrade.

HP-UX 11.0 is also out of support (quite a few years now already: Note 939891 - HP-UX: End of Support Dates)

Markus