create PDB using dblink with encryption enable resulting in ORA-15001 (Doc ID 2542003.1)

Last updated on OCTOBER 16, 2019

Applies to:

Symptoms

DATAC4 is from source
DATAC3 is in target

SQL> sho parameter pdb_file_name_convert

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pdb_file_name_convert string +DATAC4, +DATAC3

SQL> create pluggable database <TARGET PDB NAME> from <SOURCE PDB NAME>@clone_link FILE_NAME_CONVERT=('+DATAC4','+DATAC3') KEYSTORE IDENTIFIED BY "<PASSWORD>";
create pluggable database <TARGET PDB NAME> from <SOURCE PDB NAME>@clone_link FILE_NAME_CONVERT=('+DATAC4','+DATAC3') KEYSTORE IDENTIFIED BY "<PASSWORD>"
*
ERROR at line 1:
ORA-19505: failed to identify file
"+DATAC4/<CDB NAME>/5D4C9344C5A079D4E05336076F13D866/DATAFILE/<ASM FILE NAME>"
ORA-15001: diskgroup "DATAC4" does not exist or is not mounted
ORA-15001: diskgroup "DATAC4" does not exist or is not mounted

SQL> create pluggable database <TARGET PDB NAME> from <SOURCE PDB NAME>@clone_link CREATE_FILE_DEST='+DATAC3' KEYSTORE IDENTIFIED BY "<PASSWORD>";
create pluggable database <TARGET PDB NAME> from <SOURCE PDB NAME>@clone_link CREATE_FILE_DEST='+DATAC3' KEYSTORE IDENTIFIED BY "<PASSWORD>"
*
ERROR at line 1:
ORA-19505: failed to identify file
"+DATAC4/<CDB NAME>/5D4C9344C5A079D4E05336076F13D866/DATAFILE/ford_audit.1252.992107019"
ORA-15001: diskgroup "DATAC4" does not exist or is not mounted
ORA-15001: diskgroup "DATAC4" does not exist or is not mounted

Cause

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