I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to data broker configuration and when I'm trying to add standby database following error is getting
DGMGRL> ADD DATABASE 'orcl_standby' AS CONNECT IDENTIFIER IS orcl_standby maintained as physical; ERROR: ORA - 12154 : TNS: could not resolve the connect identifier specified
Tnsping from primary db to standby db and vice-versa is successful. I'm able to connect primary db from standby db using
sqlplus sys/password@orcl as sysdba but when trying to connect to standby db from primary db, error is getting like
ORA - 12154 : TNS: could not resolve the connect identifier specified.
Tried out all possible solutions.
Below is my tnsnames.ora file
ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.25.42)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) (SID = orcl) (UR = A) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL_STANDBY= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.25.44)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl_standby) (SID = orcl_standby) (UR = A) ) )
Any help will be appreciated