ORA-65101: container database set up incorrectly

Cause:

If the database is considered as CDB and controlfile from non CDB database is restored in CDB database,then we get ora-65101

SQL> startup mount;
ORACLE instance started.

Total System Global Area 1509949440 bytes
Fixed Size                  2924640 bytes
Variable Size             956305312 bytes
Database Buffers          536870912 bytes
Redo Buffers               13848576 bytes
ORA-65101: container database set up incorrectly

Workaround:

Check the parameter enable_pluggable_database

SQL> show parameter pluggable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
enable_pluggable_database            boolean     TRUE


SQL> alter system set enable_pluggable_database=false scope=spfile;

System altered.

Set the parameter to false

SQL> show parameter pluggable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
enable_pluggable_database            boolean     FALSE

Bounce the database

SQL> shu immediate;
ORA-01507: database not mounted


ORACLE instance shut down.

Now you should be able to startup successfully

SQL> startup;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s