oracle security patch 10g

[iris]

hi, iam using oracle 10g rac database on solaris 10.

My question is


Why to apply oracle security patch? Benefits?

when to apply oracle security patch? how frequently? Does application needs to be considered whether is it necessary to apply it?

How to apply these oracle security patch?


thanks,

[vnktummala]

Most of the shops don't prefer to apply CPU patches unless until they hit a bug or any other ORA-600 kind of issues. However, some shops regularly apply the CPU patches every quarter with proper testing in development and qa environments.

opatch is the utility used to apply the patches in Oracle.

Thanks,

[iris]

hi, my application is based on OLTP. Is is advised to apply Security Patch or apply when bug comes.

Which is preferable.


thanks,

[vnktummala]

I prefer not to disturb the production environment.


Thanks,

[iris]

may i know the impact by doing so.


thanks,

[vnktummala]

the impact will be like one CPU patch may lead to other issue, application performance may effect etc.

As I said earlier, If you have production like other environment (including same Oracle & OS patch numbers) then you can test the application by applying new CPU patch. If every thing is normal after testing then you can apply the patch in production.

Please read the patch document carefully which comes along with patch download.

Thanks,

[vnktummala]

Please read the below white paper to know more about oracle security patches. Hope this helps.

http://www.oracle.com/technetwork/to...per-129885.pdf

Thanks,

[iris]

Hi, thanks for the article. Iam having one doublt that is, can we rollback the security patch if there is performance problem after it is applied. If yes How?


Is the rollback method of security patch is same as of interm patch.


thanks,

[vnktummala]

Yes, you can. You can find the rollback process in the README document which comes along with patch download.

Thanks,

[iris]

Excellent, thank you.