Re: pros/cons of setting COMPATIBLE parameter 11.2.0 or 11.2.0.2.4
- From: nilesh kumar <nileshkum@xxxxxxxxx>
- To: mdinh@xxxxxxxxx
- Date: Mon, 13 Feb 2012 22:30:55 +0530
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@xxxxxxxxx> 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@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
>
>
--
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
