Problem: When shutting down and restarting the Oracle database (11.2.0.3), the following error occurs:
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 594288640 bytes Fixed Size 1386120 bytes Variable Size 411044216 bytes Database Buffers 167772160 bytes Redo Buffers 14086144 bytes ORA-00201: control file version 11.2.0.0.0 incompatible with ORACLE version 10.1.0.0.0 ORA-00202: control file: 'D:\ORACLE\PROD\PRODDB\ORADATA\PROD\CNTRL01.DBF' SQL>
Solution: The startup command is using the SPFILE by default. The old SPFILE is being used. Need to create new SPFILE when the database is up and running. In this case, the fastest way to restart the database is to use the Services panel and restart the OracleServicePROD service, then recreate the spfile:
SQL> create spfile from pfile; File created. SQL>
0 Comments.