4 Replies Latest reply on Apr 29, 2020 9:25 PM by Arsalan Dehghanisariyarghan

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

    Tim_Hussar

      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