COMPATIBLE Parameter (11.2.0.0.0 versus 11.2.0.3.0)
Two simple, high-level question here. We just upgraded a bunch of 10g (10.2.0.5.0) DBs to 11gR2 (11.2.0.3.) as well as created a bunch of new 11gR2 DBs. These DBs are ov various Solaris and RHEL5 OS platforms. I know that by default, Oracle will set teh COMPATIBLE parameter to 11.2.0.0.0 both for upgrades and new installs. One of the reason I beleive for this is allowance for distributed communication between instances or different sub-releases. I also know that is it important to standardize this acroos our various 11gR2 DBs to avoid ORA-23375 errors ("feature incompatible with database version"). So here are