ORA-00401: the value for parameter compatible is not supported by this release

Posted by Vasudev Seeram on September 26, 2013 Leave a comment (0) Go to comments

Problem: After laying down R12 filesystem and starting up the database, the following error occurs:

SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size                  1352100 bytes
Variable Size             427822684 bytes
Database Buffers          629145600 bytes
Redo Buffers               13012992 bytes
ORA-00205: error in identifying control file, check alert log for more info
SQL> startup pfile=D:\ORACLE\MFGP\mfgpdb\11.2.0\database\initMFGP.ora
ORA-00401: the value for parameter compatible is not supported by this release

Solution: Oracle Database 11.1.0 comes bundled with R12 and the Oracle Service was created using the 11.1.0 Oracle Home. However, the database was upgraded to 11.2.0. Delete the Oracle service (OracleServiceMFGP) using oradim, and recreate using the oradim in the 11.2.0 Oracle home.