RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of servic
when run rman duplicate from active database, got error as below. Please advice. I followed all required steps such as 1. static Listener, 2. (UR = A) in tnsname entry.
RMAN> connect auxiliary sys/****@nwamprd
connect target sys/****@wamprod
connected to auxiliary database: NWAMPRD (not mounted)
RMAN>
connected to target database: WAMPROD (DBID=4199108311)
RMAN> DUPLICATE DATABASE TO nwamprd FROM ACTIVE DATABASE;
Starting Duplicate Db at 25-JUN-19
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=254 device type=DISK
current log archived
contents of Memory Script:
{
sql clone "create spfile from memory";
}
executing Memory Script