Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-65169 ORA-17627 ORA-12154 ORA-17629 on PDB remote clone copy

Tim_HussarJan 29 2020 — edited Apr 29 2020

On a single Exadata cluster, from a 3-node RAC Multitenant DB with TDE at CDB$ROOT level (remote CDB), attempting to copy a PDB that's in the same cluster and is a 2-node RAC Multitenant DB with TDE (source CDB), and getting errors ORA-65169, ORA-17627, ORA-12154, ORA-17629.   Confirmed both CDBs are using the default TNS_ADMIN ($OH/network/admin).  Tried the service/tnsnames setup in two ways - First, used the existing multi-node service for the source CDB; second, created a single-node service for the source CDB - both resulted in the same errors.  For both tests, placed the service connect info for both DBs in the default tnsnames.ora location on all 3 nodes.

SQL> CREATE PLUGGABLE DATABASE qaefctora23 FROM devfctora19@dev01cdb keystore identified by "<pswd>";

CREATE PLUGGABLE DATABASE qaefctora23 FROM devfctora19@dev01cdb keystore identified by "<pswd>"

*

ERROR at line 1:

ORA-65169: error encountered while attempting to copy file +DATAC1/DEV01CDB/<file_dir_hash>/DATAFILE/datafile_indx.<number_hash>

ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified

ORA-17629: Cannot connect to the remote database server

Comments
Post Details
Added on Jan 29 2020
5 comments
3,348 views