RMAN-04006: error from auxiliary database: ORA-12504: TNS:listener was not given the SERVICE_NAME in

Hello All,

Thanks for your concern.

When I used RMAN that want to duplicate data from target database to auxiliary database, I got a problem as below:

Does anyboby has suggestions? Thanks.

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-04006: error from auxiliary database: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA

Here are my servers' settings:

• Target Server:
  • Oracle version: Oracle 12c
  • OS version: RHEL 7.4
  • Hostname: ERPBK2.domain.com
  • Oracle database SID: ERPBK2
• Auxiliary Server:
  • Oracle version: Oracle 12c
  • OS version: RHEL 7.4
  • Hostname: ERPTAP2.domain.com
  • Oracle database SID:TEST

Target's listener.ora

Target's tnsnames.ora