I Have 4 Instances running on server like below
i want to Apply the patch set 220.127.116.11.1 to DEVUAT & DEVREVT Instances , Can someone please help .. i dont want this patch set applied to DEVSTAG Instance .. how to exclude that Instance from getting patched ?
Thanks in advance .. hope my requirement is clear.
just to know what you mean. Did you want to upgrade or to patch? Your ORACLE HOME seems to be 10G databases and your patch is 11.1?
In case you mean a upgrade. Then you can install 11.1 as new clean home on your server and upgrade instance for instance for example with the dbua.
As noted, you are not patching, you are upgrading. You will need to install 11gR1 (18.104.22.168) binaries into a new ORACLE_HOME, apply the 22.214.171.124 patch, and then follow the steps in the Upgrade Guide for 11gR1 to upgrade needed databases to 126.96.36.199.
If you are going to upgrade, you should be upgrading to 11gR2, since 11gR1 is almost desupported
Thanks everyone for responding my post ..i will upgrade the two instances to oracle 11g .. now both upgraded instances will be in new & same 11g oracle Home ...now i want to apply patch for only 1 instance ? can u please explain how to do it .. my question is still not answered.
Which patch are you referring to ? The database patching tool (opatch) generally applies any database patch to an ORACLE_HOME. You will need to follow the instructions in the README of the patch. If you need to only patch one instance, then you will have to create a dedicated ORACLE_HOME for each database (i.e they will not share database executables). If you share ORACLE_HOME amongst multiple instances, then you will have to patch all of them simultaneously.