Re: ORA-00201 during startup

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