Tag:tab read oss manage copy options ons line base
$ Sqlplus '/as sysdba ' sql*plus:release 12.1.0.1.0 Production on Tue June 13:03:06 2015Copyright (c) 1982, Oracle. All rights reserved. Connected to:oracle Database 12c Enterprise Edition Release 12.1.0.1.0-64bit productionwith The partitioning, OLAP, Adva nced Analytics and Real application testing optionssql> show Con_name; Con_name------------------------------cdb$rootsql> 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 is specified$ oerr ORA 6501665016, 00000, "File_name_convert must be s Pecified "//*cause:data files, and possibly other files, needed to being copied as a//part of creating a pluggabl E database. However, Oracle Managed//Files (OMF) is not enabled, Pdb_file_name_convert is not defined,//and the Re is a failure to specify the File_name_cOnvert clause.//*action:enable OMF or define Pdb_file_name_convert system parameter before//issuing CREATE PLU Ggable DATABASE statement, or specify//File_name_convert clause as a part of the statement. If no db_create_file_ is specified The Dest parameter requires you to manually specify File_name_convert when you create pluggable database, for example: sql> Create pluggable Database yb1 Admin user yb1 ident Ified by Yb1 file_name_convert= ('/u12/app/oracle/oradata/ora12/pdbseed/', '/u12/app/oracle/oradata/ora12/yb1/'); You can also use the parameter Db_create_file_dest sql> alter system set db_create_file_dest= '/u12/app/oracle/oradata '; view sql> after successful creation Select con_id,name,open_mode,restricted from V$pdbs order by 1; con_id NAME open_mode RES-----------------------------------------------------2 PDB $SEED Read Only No 3 YB READ WRITE No 4 YB1 Mountedsql>
Oracle 12C-Create a new PDB using the seed PDB