Forum Stats

  • 3,840,358 Users
  • 2,262,592 Discussions
  • 7,901,239 Comments

Discussions

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

Tim_Hussar
Tim_Hussar Member Posts: 1 Red Ribbon
edited Apr 29, 2020 5:25PM in Multitenant

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 [email protected] keystore identified by "<pswd>";

CREATE PLUGGABLE DATABASE qaefctora23 FROM [email protected] 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

Answers