RE: pros/cons of setting COMPATIBLE parameter 11.2.0 or 11.2.0.2.4

Hence, if you have multiple databases, I would think setting compatible to the lowest version.

If you are 110% sure the database will be isolated, then safe to set compatible to 11.2.0.2.4

Michael Dinh
Disparity Breaks Automation (DBA)

Great minds discuss ideas; average minds discuss events; small minds discuss people - Eleanor Roosevelt  Confidence comes not from always being right but from not fearing to be wrong - Peter T Mcintyre  
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain Sent: Sunday, February 12, 2012 11:06 PM To: Oracle-L Freelists
Subject: pros/cons of setting COMPATIBLE parameter 11.2.0 or 11.2.0.2.4

Good day list,
Very recently we have upgraded our 10gR2 (10.2.0.4) databases to 11gr2 and applied latest PSU patch (11.2.0.2.4). However, for some concerns, the COMPATIBLE parameter value was kept to 10.2.0.4. Now we need to change the COMPATIBLE parameter value reflecting to 11gR2. Therefore, I need an advice over setting the parameter to 11.2.0 OR 11.2.0.2.4? What are the pros and cons do you foresee.

Thanks in advance.

-- 
Best Regards,

Syed Jaffar Hussain
Oracle ACE Director
<http://apex.oracle.com/pls/otn/f?p=19297:4:4640302666204919::NO:4:P4_ID:186>
Oracle Certified Master
(10g)<http://education.oracle.com/education/otn/shussain.html>
Co-author Oracle 11gR1/R2 RAC Essentials <http://link.packtpub.com/yNZicz>
*Oracle Magazine DBA of year (2011)*
OCP 8i,9i,10g & 11g DBA
RAC Certified Expert
ITIL V3 foundation certified
Oracle RAC SIG Representative for Saudi Arabian
region<http://www.oracleracsig.org>

Advisory & Governance Council for
VirtaThon<http://www.brainsurface.com/virtathon/advisorygovernancecouncil/>
I blog at  : http://jaffardba.blogspot.com/
LinkedIn : http://www.linkedin.com/in/sjaffarhussain
Follow me on twitter : http://twitter.com/#!/sjaffarhussain
--------------------
"Winners don't do different things. They do things differently."


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l