本文共 1856 字，大约阅读时间需要 6 分钟。

在oracle 12c上创建PDB的时候报了如下错误:

SQL> show pdbs    CON_ID CON_NAME			  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------	 2 PDB$SEED			  READ ONLY  NOSQL> show con_nameCON_NAME------------------------------CDB$ROOTSQL> create pluggable database salespdb admin user salesadm identified by  oracle;create pluggable database salespdb admin user salesadm identified by  oracle                                                                           *ERROR at line 1:ORA-65016: FILE_NAME_CONVERT must be specified

[oracle@foidndb admin]$ oerr ora 6501665016, 00000, "FILE_NAME_CONVERT must be specified"// *Cause:  Data files, and possibly other files, needed to be copied as a//          part of creating a pluggable database.  However, Oracle Managed //          Files (OMF) was not enabled, PDB_FILE_NAME_CONVERT was not defined,//          and there was a failure to specify the FILE_NAME_CONVERT clause.// *Action: Enable OMF or define PDB_FILE_NAME_CONVERT system parameter before//          issuing CREATE PLUGGABLE DATABASE statement, or specify //          FILE_NAME_CONVERT clause as a part of the statement.//[oracle@foidndb admin]$

如果未指定db_create_file_dest  参数则需要手动在CREATE PLUGGABLE DATABASE时指定FILE_NAME_CONVERT，例如:

SQL> create pluggable database salespdb admin user salesadm identified by  oracle file_name_convert=('/u01/data/ora18c/pdbseed/','/u01/data/ora18c/salespdb/');Pluggable database created.

也可以使用参数db_create_file_dest

SQL> alter system set db_create_file_dest='/u01/data/ora18c';System altered.SQL> create pluggable database salespdb2 admin user salesadm2 identified by oracle;Pluggable database created.SQL> show pdbs    CON_ID CON_NAME			  OPEN MODE  RESTRICTED---------- ------------------------------ ---------- ----------	 2 PDB$SEED			  READ ONLY  NO	 3 SALESPDB			  MOUNTED	 4 SALESPDB2			  MOUNTED

转载地址：http://tchji.baihongyu.com/