Hello,
I'm trying to upgrade a 10.2.0.5 database to a 12.1.0 version. ( Note : this version is able to upgrade directly in 12.1.0).
I ran dbupgrd.sql and one error exists :
1) Check Tag: COMPATIBLE_PARAMETER
Check Summary: Verify compatible parameter value is valid
Fixup Summary:
""compatible" parameter must be increased manually prior to upgrade."
+++ Source Database Manual Action Required +++
You MUST resolve the above error prior to upgrade
---> The detailed log :
**********************************************************************
[Pre-Upgrade Checks]
**********************************************************************
ERROR: --> Compatible set too low
"compatible" currently set at 10.2.0.0.0 and must
be set to at least 11.0.0 prior to upgrading the database.
Do not make this change until you are ready to upgrade
because a downgrade back to 10.2 is not possible once compatible
has been raised.
Update your init.ora or spfile to make this change.
The database is started with a pfile ( and compatible=10.2.0). I cannot start this database with compatible=11.0.0. ( ORA-00401: the value for parameter compatible is not supported by this release).
So, i'm blocked with this compatible parameter.
May be, i forgot something ?
Many thanks for your help.