Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert non-CDB to CDB

1723552Oct 1 2015 — edited Oct 5 2015

Hi ,

I have recently upgraded my 11.2.0.2 test database to 12.1.0.2 . I did using manual method using perl script. I'm in the process of converting non-CDB to CDB. But it's failing with following error.

Can you please guide me where I'm doing mistake ?

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> startup mount exclusive

ORACLE instance started.

Total System Global Area 2684354560 bytes

Fixed Size                  3788008 bytes

Variable Size            1006633752 bytes

Database Buffers         1660944384 bytes

Redo Buffers               12988416 bytes

Database mounted.

SQL> alter database open read only;

Database altered.

SQL> !mkdir -p /oracle/TEST/oradata/noncdb

SQL> exec dbms_pdb.describe(pdb_descr_file=>'/oracle/TEST/oradata/noncdb/noncdbtest12c.xml');

PL/SQL procedure successfully completed.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 2684354560 bytes

Fixed Size                  3788008 bytes

Variable Size            1006633752 bytes

Database Buffers         1660944384 bytes

Redo Buffers               12988416 bytes

Database mounted.

Database opened.

SQL> sho con_name

CON_NAME

------------------------------

test12c

SQL> sho con_id

CON_ID

------------------------------

0

SQL> create pluggable database exnoncdb_test12c

as clone

using '/oracle/TEST/oradata/noncdb/noncdbtest12c.xml'

file_name_convert=('/oracle/TEST/oradata/','/oracle/TEST/oradata/noncdb/')

copy;  2    3    4    5

create pluggable database exnoncdb_test12c

                          *

ERROR at line 1:

ORA-65090: operation only allowed in a container database

cted to:

O

Thanks

Arul

This post has been answered by unknown-7404 on Oct 1 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2015
Added on Oct 1 2015
3 comments
3,066 views