ORA-65016: FILE_NAME_CONVERT must be specified
I just started working on 12C version of oracle database.It's new to me and facing many problems.
Error code: ORA-65016: FILE_NAME_CONVERT must be specified
Description:"ORA-65016: FILE_NAME_CONVERT must be specified" normally occurs when you create a PDB.I will explain later what is a PDB.
Cause and solution :
ORA-65016: FILE_NAME_CONVERT must be specified caused when Data files, and possibly other files, needed to be copied as a part of creating a pluggable database.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 and make sure the path you are giving to convert the file exists.
I think if you are creating the PDB's using GUI then you will not face this error "ORA-65016: FILE_NAME_CONVERT must be specified". If you creating ODB using script and you have gave a wrong path then may you face "ORA-65016: FILE_NAME_CONVERT must be specified".
Syntax to create PDB:-
create pluggable database TEST admin user TEST identified by TEST file_name_convert = ('lcoation/', '/lcoation/');
Please write in comment box if you think there is better explanation on this error "ORA-65016: FILE_NAME_CONVERT must be specified".