Hi,
I have 2 nodes RAC, with ASM fs (+DATA volume)
When I created a CDB database with dbca (an empty container, without PDB) the PDB$SEED data file is not stored in /pdbseed/ directory.
as following
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
+DATA/pdb$seed_system01.dbf
+DATA/pdb$seed_sysaux01.dbf
SQL> select file_name from dba_temp_files;
FILE_NAME
--------------------------------------------------------------------------------
+DATA/pdbseed_temp01.dbf
I have few issue:
1. The PDB$SEED will look nice if it is store in it's own directory for example:
+DATA/pdbseed/system01.dbf
2. When I try to create PDB with the PDB$SEED I can't convert the pdb$seed because I have 2 format pdb$seed for system and sysaux and pdbseed for temp.
SQL> CREATE PLUGGABLE DATABASE pdb3
ADMIN USER pdb3_admin IDENTIFIED BY oracle ROLES=(CONNECT)
FILE_NAME_CONVERT=('+DATA/pdb$seed_', '+DATA/pdb3/'); 2 3
CREATE PLUGGABLE DATABASE pdb3
*
ERROR at line 1:
ORA-65005: missing or invalid file name pattern for file -
+DATA/pdbseed_temp01.dbf
What can I do to resolve above problem, I think if I resolve problem 1 the problem 2 is not applicable.