Many time's i try to understand Oracle Patch
but i was unable to
what is Oracle Patch?????????????????
Maybe a bird maybe a car
A patch is a part of software that repair some database errors (bugs) and create other news
When we say Oracle Version 188.8.131.52, it means that we have software for the base release 8.1.7 and the patch 184.108.40.206(another piece of software) has to be applied to make it 220.127.116.11. A Patch is released to overcome few bugs to the existing base release which cannot wait to be applied till the next release.
The rule that your apply patch to your database?
when oracle release a new patchset for your version , say, now you have oracle 18.104.22.168 installed on your production, and now the latest patchset has been released.
So, what is the rule that you apply this patchset? If the production is good with current patchset(eg, 22.214.171.124), will you choose to upgrade to 126.96.36.199?
We upgrade the software only when it is required or on a safer front that we dont hit the bugs, we upgrade it. Say ur production is running fine with 188.8.131.52, there might be possibility that the bugs which occured in 184.108.40.206 hits u someday and then anyway u have to upgrade it
Most patchsets contain a large number of security updates. These should be applied as soon as possible to prevent problems. If possible it's best to keep on top of these.
Click Here to Expand Forum to Full Width