Create pluggable database Oracle database 19c failing with ORA-65005: missing or invalid file

 Create pluggable database Oracle database 19c  failing with ORA-65005: missing or invalid file  

SQL> CREATE PLUGGABLE DATABASE TEST1 ADMIN USER PDBADMIN IDENTIFIED BY "pdbadmin_test"
  FILE_NAME_CONVERT=(' /u01/oradata/CDB/','/u01/oradata/PDB/');     2
CREATE PLUGGABLE DATABASE TEST1 ADMIN USER PDBADMIN IDENTIFIED BY "pdbadmin_test"
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file -
/u01/oradata/CDB/pdbseed/system01.dbf

CAUSE:

Issue with FILE_NAME_CONVERT 

Fix:

Check and update FILE_NAME_CONVERT as below example and re-try

CREATE PLUGGABLE DATABASE <NEW_PDB_NAME> ADMIN USER pdb_database_admin_user IDENTIFIED BY pdb_database_admin_user_password  

FILE_NAME_CONVERT = (pdbseed_location, new_pdb_location);

Worklog:

SQL>  CREATE PLUGGABLE DATABASE TEST1 ADMIN USER PDBADMIN IDENTIFIED BY "pdbadmin_test"
  FILE_NAME_CONVERT=(' /u01/oradata/CDB/','/u01/oradata/PDB/');     2
CREATE PLUGGABLE DATABASE TEST1 ADMIN USER PDBADMIN IDENTIFIED BY "pdbadmin_test"
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file -
/u01/oradata/CDB/pdbseed/system01.dbf

        1) Connect to CDB check datafiles location: 

         SQL> select name from v$datafile;

NAME

---------------------------

/u01/oradata/CDB/system01.dbf

/u01/oradata/CDB/pdbseed/system01.dbf

/u01/oradata/CDB/sysaux01.dbf

/u01/oradata/CDB/pdbseed/sysaux01.dbf

/u01/oradata/CDB/undotbs01.dbf

/u01/oradata/CDB/pdbseed/undotbs01.dbf

/u01/oradata/CDB/users01.dbf

7 rows selected.

SQL>

2) update FILE_NAME_CONVERT with above directory path

CREATE PLUGGABLE DATABASE <NEW_PDB_NAME> ADMIN USER pdb_database_admin_user IDENTIFIED BY pdb_database_admin_user_password  

FILE_NAME_CONVERT = (pdbseed_location, new_pdb_location); 

 

SQL>   CREATE PLUGGABLE DATABASE TEST1 ADMIN USER PDBADMIN IDENTIFIED BY "pdbadmin_test"
  FILE_NAME_CONVERT=('/u01/oradata/CDB/pdbseed/','/u01/oradata/PDBTEST1');  

Pluggable database created.

SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         4 TEST1                          MOUNTED

SQL>

SQL> alter pluggable database TEST1 open;

Pluggable database altered.

SQL>

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         4 TEST1                          READ WRITE NO

SQL>  

Happy Learning 👍 Please comment if you need any further details or issues so that I can try my best to answer  👊