12c RMAN Duplicate With TNS Connection String Fails (Doc ID 2076881.1)

Last updated on MARCH 10, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Error during Active duplicate in 12c :

rman log='/home/oracle/12c_rman_duplicate.txt'
connect target
sys@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=targethostname
.domain.net)(PORT=1592)))(CONNECT_DATA=(SID=target)(SERVER=DEDICATED)))'

connect auxiliary
sys@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=auxiliaryhostname.newdomain.net)(PORT=1596)))(CONNECT_DATA=(SID=aux)(SERVER=DEDICATED)))

.............

Oracle instance shut down
released channel: tgt1
released channel: tgt2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/12/2015 14:27:46
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-19741: 156 exceeds maximum allowable length of 64 for parameter 'service'

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms