ORA-65005: missing or invalid file name pattern for file - +DATA/CDB01/TEMPFILE/temp.1667.989251537

<<Back to DB Administration Main Page

ORA-65005: missing or invalid file name pattern for file - +DATA/CDB01/TEMPFILE/temp.1667.989251537

CDB011> create pluggable database PDB01 using '/u01/stage/UNPLUG_DEF_PDB01.xml'
SOURCE_FILE_NAME_CONVERT=('+DATA/CDB01/DATAFILE/','/u01/stage/')
MOVE
FILE_NAME_CONVERT = ('/u01/stage/', '+DATA_TEST');
create pluggable database PDB01 using '/u01/stage/UNPLUG_DEF_PDB01.xml'
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file - +DATA/CDB01/TEMPFILE/temp.1667.989251537
Solution
To resolve the issue I modified the UNPLUG_DEF_PDB01.xml manually. Identified and removed the temp file creation clause from XML definition file.
Remove the following portion from XMIL file and re-run the create PDB clause.

$ diff UNPLUG_DEF_PDB01.xml UNPLUG_DEF_PDB01_tmp.xml
<     <name>TEMP</name>
<     <type>1</type>
<     <tsn>2</tsn>
<     <status>1</status>
<     <issft>0</issft>
<     <bmunitsize>128</bmunitsize>
<     <file>
<       <path>+DATA/CDB01/TEMPFILE/temp.1667.989251537</path>
<       <afn>42</afn>
<       <rfn>1</rfn>
<       <createscnbas>259862536</createscnbas>
<       <createscnwrp>11</createscnwrp>
<       <status>0</status>
<       <fileblocks>2560</fileblocks>
<       <blocksize>8192</blocksize>
<       <vsn>2589488569</vsn>
<       <autoext>1</autoext>
<       <maxsize>4194302</maxsize>
<       <incsize>80</incsize>
<     </file>
<   </tablespace>
<   <tablespace>