i want to Apply the patch set 188.8.131.52.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.
As noted, you are not patching, you are upgrading. You will need to install 11gR1 (184.108.40.206) binaries into a new ORACLE_HOME, apply the 220.127.116.11 patch, and then follow the steps in the Upgrade Guide for 11gR1 to upgrade needed databases to 18.104.22.168.
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.