ORA-65005
ORA-65005 means that the pattern of file name conversion you specified in CREATE PLUGGABLE DATABASE statement does not match the data files.
SQL> create pluggable database orclpdb2 from orclpdb1 storage unlimited tempfile reuse file_name_convert=('orclpdb1', 'orclpdb2');
create pluggable database orclpdb2 from orclpdb1 storage unlimited tempfile reuse file_name_convert=('orclpdb1', 'orclpdb2')
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file -
/u01/app/oracle/oradata/ORA19C1/ORCLPDB1/system01.dbf
This is usually because you specified an invalid value of FILE_NAME_CONVERT. In this case, Oracle found that the path of system01.dbf cannot be converted into a valid path according to FILE_NAME_CONVERT.
That's right, 'orclpdb1' is different from 'ORCLPDB1'.
Solution
To solve ORA-65005, you should make sure the file name pattern of source PDB you specified in FILE_NAME_CONVERT is valid and case-sensitive.
In this case, we should uppercase the pattern of file name conversion.
SQL> create pluggable database orclpdb2 from orclpdb1 storage unlimited tempfile reuse file_name_convert=('ORCLPDB1', 'ORCLPDB2');
Pluggable database created.