1

Topic: RMAN duplicate from active database: ORA-17627: ORA-12518: TNS:listener could not hand off

Somebody met such strange situation:
RMAN it is normally connected and to target and auxiliary, but during time duplicate from active database produces a connection error:

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/26/2017 0:01:59 PM
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12518: TNS:listener could not hand off client connection
ORA-17629: Cannot connect to the remote database server

The full broad gull:

> rman target sys/xxxxxx@DBSlive auxiliary sys/xxxxxx
DBSdev
Recovery Manager: Release 11.2.0.2.0 - Production on Tue Sep 26 0:01:43 PM 2017
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: DBSLIVE (DBID=2573738273)
connected to auxiliary database: DBSDEV (not mounted)
RMAN> DUPLICATE TARGET DATABASE TO DBSDEV FROM ACTIVE DATABASE
2> spfile
3> set db_name ='DBSDEV'
4> nofilenamecheck;
Starting Duplicate Db at 26-SEP-17
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=121 device type=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: SID=416 device type=DISK
allocated channel: ORA_AUX_DISK_3
channel ORA_AUX_DISK_3: SID=240 device type=DISK
allocated channel: ORA_AUX_DISK_4
channel ORA_AUX_DISK_4: SID=299 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile ' D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBSLIVE.ORA ' au
xiliary format
' D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEDBSDEV.ORA ';
sql clone "alter system set spfile =" D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABA
SE\SPFILEDBSDEV.ORA "";
}
executing Memory Script
Starting backup at 26-SEP-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=987 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1164 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1342 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=12 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/26/2017 0:01:59 PM
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/26/2017 0:01:59 PM
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12518: TNS:listener could not hand off client connection
ORA-17629: Cannot connect to the remote database server

2

Re: RMAN duplicate from active database: ORA-17627: ORA-12518: TNS:listener could not hand off

Pancake, from a sleep debt a sight ...
Found a problem: did a copy that on other server and there in tnsnames all is correct, but on the fighting server where is DBSLIVE, forgot to change tnsnames for DBSDEV (it now on other server)...