Hi!
You should try accessing 11.2.0.3 database from 11.2.0.3, reset the
"compatible" parameter to 11.2.0.3 and all should be well. The only way
to utilize 11.2.0.4 software would be to upgrade. As far as I am aware
of, there is "dbua" utility in 11.2.0.4 home.
Regards
On 5/26/21 5:21 PM, Abdellah DANY wrote:
Hi all,--
Recreating control file didn't help as well: ORA-01130: version 11.2.0.4.0 of datafile incompatible with version 11.2.0.3.0 ORACLE ORA-01110: datafile 1 : '/data/oracle/../datafile/system.dbf'
This is odd how this propagated to datafiles.
Since this is not a production environment and we haven't much time to try all the suggested solutions, we restore the latest available backup.
@Mladen, this how this happened, we have two oracle homes (11.2.0.3 & 11.2.0.4) with 2 init files for the same instance name (everyone with the correct compatible parameter) and the server contains multiple database instances. Forgot to set the correct environment variables led to this.
I will try to reproduce the problem in my home lab and try to figure out the easiest solution for this issue (upgrade, check file headers...)
Thanks all for your help.
Regards;
Le mer. 26 mai 2021 à 20:20, Sayan Malakshinov <xt.and.r@xxxxxxxxx <mailto:xt.and.r@xxxxxxxxx>> a écrit :
Mladen,
>Sayan, my understanding is that the situation is actually
vice versa: database software is 11.2.0.3 and somebody has set
compatible parameter to 11.2.0.4. Re-creating the control file
or restoring from backup seem like the best options in that case.
Abdellah already confirmed my suspicions:
> @Sayan, the database is 11.2.0.3 and was started with
11.2.0.4 binaries with compatible=11.2.0.4 in the init file;
Moreover, as I said before, Oracle can't start with "compatible"
higher than current software version.
Simple test case:
Oracle version: 19.9:
SQL> alter system set compatible='19.10.0' scope=spfile;
System altered.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
*/ORA-00401: the value for parameter compatible is not supported
by this release/*
-- Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org ;<http://orasql.org>