Wednesday, 27 May 2015

ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified ORA-17629: Cannot connect to the remote database server

Getting below error during duplication for standby

Error:
DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE DORECOVER NOFILENAMECHECK;

RMAN-03002: failure of Duplicate Db command at 05/27/2015 12:52:24
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 05/27/2015 12:52:23
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified

ORA-17629: Cannot connect to the remote database server


Solution:

Update the tnsnames.ora of source and target tnsname's alias in both GRID and ORACLE home.

Ex:

GRID_HOME tns = /u01/app/11.2.0/grid/network/admin
ORACLE_HOME tns = /u01/app/oracle/product/11.2.0/db_1/network/admin

Update the entries in both source and target grid and oracle home.

No comments: