COMPATIBLE Parameter - What to set it to on 11gR2 Upgrade?
We are currently going through the process of upgrading our EBS databases from 10.2.0.4 to 11.2.0.3 - a couple of test upgrades have now been completed successfully and testing is underway.
One aspect we are unsure about and have not yet undertaken is the setting of the COMPATIBLE parameter. Initially we were unsure as to when it should be set, but I have found a couple of useful threads on this forum and we are going to set it straight after the upgrade is done, and then test - rather than test, change the parameter and then have to retest.
My question now is what should we set the value of the parameter to? The upgrade documentation specifies the default value is 11.2.0 and that the maximum value it can be is 11.2.0.n.n.