Re: 11.2 compatible parameter setting

  • From: Taral Desai <taral.desai@xxxxxxxxx>
  • To: daniel.fink@xxxxxxxxxxxxxx
  • Date: Mon, 27 Dec 2010 10:12:19 -0600

On my windows box i recently(new) install 11.2.0.2 and default compatible
setting are 11.2.0.0.0. Why one extra zero i don't know.

On Mon, Dec 27, 2010 at 8:21 AM, Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>wrote:

> A client recently upgraded one of their databases from 10gR2 to 11gR2, but
> have left the compatible parameter to 10.2.0 in case they needed to
> downgrade. They will be bouncing the system in January and are looking to
> change the parameter to 11.2.<something>. The question they have (and I
> have) is what should that <something> be?
>
> What is the appropriate setting for the COMPATIBLE parameter?
> Just the major release (11.2.0) or the patch set (11.2.0.1)?
> Are there any implications of setting it to a patch set instead of release?
> or vice versa?
> If they set it to 11.2.0 (current install is 11.2.0.1) and update to
> 11.2.0.2, would they have any issues backing out the patch if necessary?
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


-- 
Thanks & Regards,
Taral Desai

Other related posts: