ORA-65005: Missing Or Invalid File Name Pattern For File
(Doc ID 2426376.1)
Last updated on AUGUST 30, 2023
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 |