Re: 11.2 compatible parameter setting

  • From: LS Cheng <exriscer@xxxxxxxxx>
  • To: daniel.fink@xxxxxxxxxxxxxx
  • Date: Tue, 28 Dec 2010 08:56:53 +0100

I always set to patchset because sometimes they introduce features between
them.

The extra zero is probably for PSU, looks like they can do the samething
with them, introduce new features


On Mon, Dec 27, 2010 at 3:21 PM, 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
>
>
>

Other related posts: