RE: pros/cons of setting COMPATIBLE parameter 11.2.0 or

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Mon, 13 Feb 2012 08:42:11 -0800
Message-ID: <>

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

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: [] 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

Good day list,
Very recently we have upgraded our 10gR2 ( databases to 11gr2 and applied latest PSU patch ( However, for some concerns, the COMPATIBLE parameter value was kept to 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 What are the pros and cons do you foresee.

Thanks in advance.

Best Regards,

Syed Jaffar Hussain
Oracle ACE Director
Oracle Certified Master
Co-author Oracle 11gR1/R2 RAC Essentials <>
*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

Advisory & Governance Council for
I blog at  :
LinkedIn :
Follow me on twitter :!/sjaffarhussain
"Winners don't do different things. They do things differently."


Received on Mon Feb 13 2012 - 10:42:11 CST

Original text of this message