Re: ORA-00201 during startup

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.

_at_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_at_gmail.com> 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:
>
> > _at_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://www.freelists.org/webpage/oracle-l