Old friends asked me for help, said they copied the database from the notebook to the client server, unable to start, let me see.
Launch Report ORA-00211 ORA-00202 error
C:\users\administrator>sqlplus/as SYSDBA
Sql*plus:release 12.1.0.1.0 Production on Tuesday October 13 21:35:45 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connect to:
Oracle Database 12c Enterprise Edition release 12.1.0.1.0-64bit Production
With the partitioning, OLAP, Advanced Analytics and real application testing opt
Ions
Sql> select Open_mode from V$database;
Select Open_mode from V$database
*
Line 1th Error:
ORA-01507:??????
Sql> ALTER DATABASE Mount;
ALTER DATABASE Mount
*
Line 1th Error:
Ora-00211:control file does not match previous control files
Ora-00202:control file:
"D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL12C\CONTROL02." CTL '
Control file versions do not match
This error is obviously inconsistent with multiple control file versions in the database.
Sql> show parameter control;
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
Control_file_record_keep_time integer
7
Control_files string
D:\APP\ADMINISTRATOR\ORADATA\O
Rcl12c\control01. CTL, D:\APP\A
Dministrator\fast_recovery_are
A\orcl12c\control02. Ctl
Control_management_pack_access string
Diagnostic+tuning
Sql> alter system set control_files= ' D:\app\administrator\oradata\orcl12c\contro
L01.ctl ' Scope=spfile;
The system has changed.
sql> Shutdown Abort
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.
Total System Global area 1703624704 bytes
Fixed Size 2403448 bytes
Variable Size 1090519944 bytes
Database buffers 603979776 bytes
Redo buffers 6721536 bytes
Ora-65101:container database Set up incorrectly
The database reports ORA-65101 error, official explanation
The explanation is clear, using a CDB control file to start a CDB library, resulting in a ORA-65101 error. Official solution: Rebuilding the control file, but this database is copied with the data file and control file, it should not be changed.
Error code:ora-65101
Description:container database Set up incorrectly
Cause:
An attempt is made to use a non container database
Control file to startup a container database (CDB).
Action:
Create a new control file for the CDB.
Check enable_pluggable_database parameters
Sure enough, this parameter is set to CDB mode and does not match the no CDB of the control file, so this problem occurs
Sql> Show Parameter Enable_pluggable_database
NAME TYPE
------------------------------------ ----------------------
VALUE
------------------------------
Enable_pluggable_database Boolean
TRUE
Sql>
Sql> alter system set ENABLE_PLUGGABLE_DATABASE=FALSE Scope=spfile;
The system has changed.
sql> Shutdown Abort
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has started.
Total System Global area 1703624704 bytes
Fixed Size 2403448 bytes
Variable Size 1090519944 bytes
Database buffers 603979776 bytes
Redo buffers 6721536 bytes
Database loading complete.
The database is already open.
Contact: Mobile Phone (13429648788) QQ (107644445) QQ Advisory Cherish Division fly
Source: http://www.xifenfei.com/2015/10/ora-65101-container-database-set-up-incorrectly.html