1. I installed Oracle 10.2.0.1 client on Sun Solaris 5.9. Is there any patch to upgrade this 10.2.0.1 to 10.2.0.3? If so please provide me with that patch number.
2. I have an x4500 Solaris 64-bit box. There are three instances in that box with Oracle version 10.2.0.2. I have to upgrade this to 10.2.0.3.
a) How to proceed in this scenario?
b) Which patch do I have to apply? Can you provide any patchset number?
c) How to enable opatch utility in this box?
You can upgrade a 10.2.0.1 client on Solaris 9 to 10.2.0.3. The patch number is 5337014 and can be downloaded from Oracle's Metalink Web site. To access MetaLink, you will need a valid Support Identifier (CSI). CSI numbers are unique support identifiers given to each customer with a current support contract.
With reference to your second question, the patch you need to download is the same patch as for the 10.2 client. The 10.2.0.3 patch can be applied to a number of Oracle 10g release 2 installations such as Oracle Database and Oracle Client. Since this is a patch set release (not a one-off patch or CPU), you will use the Oracle Universal Installer and not opatch to perform this upgrade. When you download the patch from Metalink, it is accompanied by a readme file that clearly explains how to apply the patch.
Because you have three databases sharing the same 10.2 ORACLE_HOME, you must either upgrade all three databases at once, or perform a new clean installation of Oracle 10g in a new ORACLE_HOME, upgrade it to 10.2.0.3 and then migrate the three databases (one at a time) to use the new upgraded 10.2.0.3 ORACLE_HOME.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
How many database instances can be created on an Oracle server with an installation drive containing 15 GB free space? Continue Reading