Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Comparison between Oracle 10.2.0.2.0 and Oracle 10.2.0.4

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
Former Member replied

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: SAP on Oracle

Kind regards

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question