RE: pros/cons of setting COMPATIBLE parameter 11.2.0 or 11.2.0.2.4
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: "'sjaffarhussain@xxxxxxxxx'" <sjaffarhussain@xxxxxxxxx>, Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
- 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 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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."
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
