$ sqlplus '/as sysdba'
SQL*Plus: Release 12.1.0.1.0 Production on Tue Jun 23 13:03:06 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT
SQL> create pluggable database yb1 admin user yb1 identified by yb1;
create pluggable database yb1 admin user yb1 identified by yb1
*
ERROR at line 1:
ORA-65016: FILE_NAME_CONVERT must be specified
------------------------------
CDB$ROOT
SQL> create pluggable database yb1 admin user yb1 identified by yb1;
create pluggable database yb1 admin user yb1 identified by yb1
*
ERROR at line 1:
ORA-65016: FILE_NAME_CONVERT must be specified
$ oerr ora 65016
65016, 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.
65016, 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.
如果未指定db_create_file_dest 参数则需要手动在CREATE PLUGGABLE DATABASE时指定FILE_NAME_CONVERT，例如：
SQL> create pluggable database yb1 admin user yb1 identified by yb1 file_name_convert=('/u12/app/oracle/oradata/ora12/pdbseed/','/u12/app/oracle/oradata/ora12/yb1/');
SQL> create pluggable database yb1 admin user yb1 identified by yb1 file_name_convert=('/u12/app/oracle/oradata/ora12/pdbseed/','/u12/app/oracle/oradata/ora12/yb1/');
也可以使用参数db_create_file_dest
SQL> alter system set db_create_file_dest='/u12/app/oracle/oradata';
SQL> alter system set db_create_file_dest='/u12/app/oracle/oradata';
创建成功后查看
SQL> select con_id,name,open_mode,restricted from v$pdbs order by 1;
SQL> select con_id,name,open_mode,restricted from v$pdbs order by 1;
CON_ID NAME OPEN_MODE RES
---------- ------------------------------ ---------- ---
PDB$SEED READ ONLY NO
YB READ WRITE NO
YB1 MOUNTED
---------- ------------------------------ ---------- ---
PDB$SEED READ ONLY NO
YB READ WRITE NO
YB1 MOUNTED
SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/196700/viewspace-2134529/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
