Resolve Oracle Databases ORA-65101 container database set up incorrectly

Source: Internet
Author: User
Tags error code versions oracle database

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.