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.