My Oracle Support Banner

ORA-65005: Missing Or Invalid File Name Pattern For File (Doc ID 2426376.1)

Last updated on FEBRUARY 16, 2020

Applies to:

Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

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

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.