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

From: nilesh kumar <nileshkum_at_gmail.com>
Date: Mon, 13 Feb 2012 22:30:55 +0530
Message-ID: <CACzEWSXfHYFLTG5nxX1RUM4vFDD8wuf7bbQGwyvqG-iyCa+EZQ_at_mail.gmail.com>

Yes, once you set the compatible parameter to 11g, you cannot downgrade it back to 10g as control files get updated, i had the same issue hence had to do a complete restore as application team wanted to downgrade the database after upgrade.

On Mon, Feb 13, 2012 at 10:12 PM, Michael Dinh <mdinh_at_xifin.com> wrote:
> 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_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
>
>

-- 
Thanks & Regards
Nilesh
Oracle DBA (sqlplus "/as sysdba" is my world)

"As our circle of knowledge expands, so does the circumference of
darkness surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a
lot by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can
do and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I
may not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then
beat you with experience." - Unknown
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 13 2012 - 11:00:55 CST