1

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 my 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-16606: unable to find property ""
Error: ORA-16554: translation not valid

Failed.

I think it is the issue with the connect identifier I have given. But I'm not able to troubleshoot that. Below is my tnsnames.ora of standby database.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.19)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (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.80.16)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = orcl_standby)
      (SERVICE_NAME = orcl_standby)
      (UR = A)
    )
  )

Please help to troubleshoot this issue.

atokpas
  • 8,680
  • 1
  • 18
  • 27
Kenny
  • 377
  • 3
  • 8
  • 24

0 Answers0