This content has been marked as final. Show 5 replies
user8837052 wrote:Pl clarify what you mean by "10.1.3.0", "10.2.3.0", "10.2.4.0" and "10.2.5.0" - there a no such Oracle versions
Hi to all,
a customer asked me to update an Oracle database 10.1.3.0 on Windows 32 platform. THe only patches installed are **5556081** and *5557962*..
I looked for new updated patches and I founded some Oracle Recommended Patches ID 756671.1 and Oracle Patch Bundles ID 1207176.1 for 10.2.3.0.
Honestly I don't know how to proceed in the sense that i don't know if it is better to apply these bundle patches or to go directly to Oracle Patch Set 10.2.4.0 or 10.2.5.0 for a better update.
What is the difference between Oracle Patch Bundle and Oracle Patch Set?? and the difference between Oracle patch Set and Oracle Patch Set Update???
Any help will be well appreciated..I need to do this update asap
Thanks in advance
Susy Paparella OCP 10 G DBA
I believe you mean 10.1.0.3, 10.2.0.3, 10.2.0.4 and 10.2.0.5
If so, all of the above are patch sets on top of the base release (10.1 or 10.2). It is always recommended to update to the latest patch set release.
Pl note that both 10.1 and 10.2 are de-supported - you should be using the latest 11gR2 version.
Patch set updates (PSU) are additional bundled fixes on top of patch sets - see this MOS Doc
Patch Set Updates for Oracle Products [ID 854428.1]
Yes sorry my database is Oracle 10.2.3.0.(I wrote wrongly..because I was hurry..sorry)..so do you suggest me to go directly to 11GR2....?? in that case which Oracle Patch Set should I apply..??
Would you mind also telling me what is the difference between Oracle Patch Set and Oracle Patch Bundle??
Thanks a lot in advance
I do not know the specifics of your situation - so cannot suggest specific solution.
In general, you should be using 11gR2. This will require the following high-level steps
1. Install 11gR2 (220.127.116.11) in a new ORACLE_HOME - see http://www.oracle.com/pls/db112/homepage
2. Apply the latest PSU patch available (18.104.22.168.3) - see this MOS Doc
Quick Reference to Patchset Patch Numbers [ID 753736.1]
3. Perform an upgrade from your current version to 11gR2 - if you are on 10.1.0.5, you can directly upgrade using DBUA ( see http://docs.oracle.com/cd/E11882_01/server.112/e23633/preup.htm#i1007814), else you will first have to apply the 10.1.0.5 patch set first.
"Bundle patch" is a term used only for Windows patches, where patch releases differ from Unix versions
Quick Reference To Patch Numbers For Database PSU, CPU And Bundle Patches [ID 1454618.1]
thank you very much..I still have another question..
May this upgrade have any impact on the applications that run on Oracle 10.2.0.3 database??? that is
may this upgrading actions cause a bad functioning of the underlying applications??
Thank very much in advance for your reply..
It is possible - it is best practice to test the upgrade on a test system and verify that the application continues to function as expected. If this is a application that is provided by a vendor, the vendor typically certifies the application to run against specific database versions1 person found this helpful