ORA-65005: Missing Or Invalid File Name Pattern For File

刘泽宇

现象：
create pluggable database testpdb1 from DBaasRAC1@rem_pdb1 file_name_convert=('/u02/app/oracle/oradata/DBaasRAC1/DBaasRAC1PDB1/','/u02/app/oracle/oradata/DBaasRAC1/KIRANTESTPDB1/') KEYSTORE IDENTIFIED BY "XXXX";

ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file -
/u04/app/oracle/oradata/temp/temp012017-05-02_03-50-48-046-AM.dbf


DB file names
=========
show con_name

CON_NAME
------------------------------
DBaasRAC1

select file_name from dba_data_files;

FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------
/u02/app/oracle/oradata/DBaasRAC1/DBaasRAC1PDB1/sysaux01.dbf
/u02/app/oracle/oradata/DBaasRAC1/DBaasRAC1PDB1/undotbs01.dbf
/u02/app/oracle/oradata/DBaasRAC1/DBaasRAC1PDB1/DBaasRAC1PDB1_users01.dbf
/u02/app/oracle/oradata/DBaasRAC1/DBaasRAC1PDB1/system01.dbf
/u02/app/oracle/oradata/DBaasRAC1/DBaasRAC1PDB1/tbs_data_01.dbf
/u02/app/oracle/oradata/DBaasRAC1/DBaasRAC1PDB1/perfstatpdb1.dbf

select file_name from dba_temp_files;

FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------
/u04/app/oracle/oradata/temp/temp012017-05-02_03-50-48-046-AM.dbf


处理方法：
Add Temp file to the file_name_convert part of the Create Pluggable database statement.

For e.g
CREATE PLUGGABLE DATABASE salespdb1
FILE_NAME_CONVERT = ('/u01/app/oracle/oradata/VIHAAN/salespdb/', '/u01/app/oracle/oradata/VIHAAN/salespdb1/datafile/', '/u01/app/oracle/oradata/VIHAAN/datafile/pdbseed_temp01.dbf', '/u01/app/oracle/oradata/VIHAAN/salespdb1/datafile/pdbseed_temp01.dbf');