Warning: PDB altered with errors.

Warning: PDB altered with errors.---把数据库从non-cdb转换成pdb警告错误的解决

我们在把一个non-cdb的数据库转换成pdb数据库的时候，遇到这样的错误

03:19:13 sys@enmoedu> create database link test connect to system identified by oracle using 'test';

Database link created.
03:19:45 sys@enmoedu> select sysdate from dual@test;

SYSDATE
-------------------
2015-10-23 03:19:57
03:23:33 sys@enmoedu> create pluggable database prod5 from non$cdb@test
03:25:38   2  file_name_convert=('test','enmoedu/prod5');

Pluggable database created.

Elapsed: 00:00:23.59
03:26:06 sys@enmoedu> show pdbs

       CON_ID CON_NAME                       OPEN MODE  RESTRICTED
------------- ------------------------------ ---------- ----------
            2 PDB$SEED                       READ ONLY  NO
            3 PROD4                          READ WRITE NO
            4 PROD5                          MOUNTED
03:28:13 sys@enmoedu> alter pluggable database prod5 open;

Warning: PDB altered with errors.

Elapsed: 00:00:02.12
03:28:29 sys@enmoedu> show pdbs;

       CON_ID CON_NAME                       OPEN MODE  RESTRICTED
------------- ------------------------------ ---------- ----------
            2 PDB$SEED                       READ ONLY  NO
            3 PROD4                          READ WRITE NO
            4 PROD5                          READ WRITE YES

可以看到，转换成的pdb数据库有报警的错误，所以只能以restricted的模式打开我们的数据库，对于这样的问题，我们如何的查看她的错误，oralce提供了视图方便我们去查看pdb的问题

03:42:23 sys@enmoedu> select name,cause,type,message,status from PDB_PLUG_IN_VIOLATIONs order by name;

NAME                           CAUSE                          TYPE      MESSAGE                                            STATUS
------------------------------ ------------------------------ --------- -------------------------------------------------- ---------
PROD5                          Non-CDB to PDB                 ERROR     PDB plugged in is a non-CDB, requires noncdb_to_pd PENDING
                                                                        b.sql be run.

PROD5                          Parameter                      WARNING   CDB parameter memory_target mismatch: Previous 400 RESOLVED
                                                                        M Current 1488M

从这儿，我们可以看到，我们在转换完成以后，还需要执行一个脚本noncdb_to_pdb.sql

@?/rdbms/admin/noncdb_to_pdb.sql

等待一个较长时间脚本执行完成以后，在启动pdb的时候我们发现就没有报错了

04:03:59 sys@enmoedu> show pdbs

       CON_ID CON_NAME                       OPEN MODE  RESTRICTED
------------- ------------------------------ ---------- ----------
            2 PDB$SEED                       READ ONLY  NO
            3 PROD4                          READ WRITE NO
            4 PROD5                          READ WRITE YES
04:05:54 sys@enmoedu> alter pluggable database prod5 close;

Pluggable database altered.

Elapsed: 00:00:00.46
04:06:06 sys@enmoedu>  alter pluggable database prod5 open;

Pluggable database altered.