Oracle duplicate出现ORA-17627 ORA-17629

RMAN Duplicate遇见ORA-17627 ORA-17629

RMAN> duplicate target database for standby from active database
Finished backup at 26-OCT-20
contents of Memory Script:
{
   restore clone from service  'pri' standby controlfile;
}
executing Memory Script
Starting restore at 26-OCT-20
using channel ORA_AUX_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/26/2020 16:03:36
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server

排查：
1.主库两节点备库两节点进行tnsping以及sqlplus网络连接都没有问题
[oracle@rac1 ~]$ tnsping sty
TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 16-NOV-2020 14:41:09
Copyright (c) 1997, 2016, Oracle.  All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.60)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.61)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = sty)))
OK (30 msec)

[oracle@rac1 ~]$ tnsping pri
TNS Ping Utility for Linux: Version 12.2.0.1.0 - Production on 16-NOV-2020 14:41:11
Copyright (c) 1997, 2016, Oracle.  All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.55)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.56)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl12c)))
OK (0 msec)


2.主库两节点以及备库两节点检查tnsname.ora：
PRI =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.55)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.56)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl12c)
    )
  )
  
STY =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.60)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.242.61)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = sty)
    )
  )


解决方案:
将其在主库两节点以及备库两节点的grid用户下也进行tnsname.ora配置问题即解决。