RE: pros/cons of setting COMPATIBLE parameter 11.2.0 or 184.108.40.206.4
Date: Mon, 13 Feb 2012 08:42:11 -0800
From my understanding, once you set compatible, there's no undo.
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 220.127.116.11.4
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
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 18.104.22.168.4
Good day list,
Very recently we have upgraded our 10gR2 (10.2.0.4) databases to 11gr2 and applied latest PSU patch (22.214.171.124.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 126.96.36.199.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-lReceived on Mon Feb 13 2012 - 10:42:11 CST