oracle 12c non-cdb升级成cdb模式

oracle 12c non-cdb升级成cdb模式 相同主机下，有一个non-cdb数据库，再创建一个cdb的实例。 SQL> select name,cdb from v$database; NAME                        CDB --------------------------- --------- EID                         NO 1 row selected. 关闭数据库并以read only模式打开 16:50:58 SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. 16:51:39 SQL> startup open read only; ORACLE instance started. Total System Global Area 1426063360 bytes Fixed Size                  8620704 bytes Variable Size             486540640 bytes Database Buffers          922746880 bytes Redo Buffers                8155136 bytes Database mounted. Database opened. SQL> select name,open_mode,cdb from v$database; NAME                        OPEN_MODE                                                    CDB --------------------------- ------------------------------------------------------------ --------- EID                         READ ONLY                                                    NO 1 row selected. 生成xml格式的数据库描述文件 SQL> BEGIN   2    DBMS_PDB.DESCRIBE(pdb_descr_file => '/home/oracle/EID.xml');   3  END;   4  / PL/SQL procedure successfully completed. 关闭数据库 SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. 连接到cdb数据库 SQL> CREATE PLUGGABLE DATABASE mpdb01 USING '/home/oracle/EID.xml'   2  COPY   3  FILE_NAME_CONVERT = ('/u02/app/oracle/oradata/EID/', '/u02/app/oracle/oradata/mcdb/mpdb01/'); Pluggable database created. SQL> show pdbs       CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 MPDB01                         MOUNTED SQL> alter session set container=MPDB01; Session altered. 执行如下命令。注意该命令会清空shared pool，所以生产环境要注意。 sql> @$ORACLE_HOME/rdbms/admin/noncdb_to_pdb.sql SQL> alter pluggable database MPDB01 open; Pluggable database altered.