Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> When trying to configure data guard broker I'm getting Error: ORA-16606: unable to find property
Joe Valiyaveetti...
post Aug 25 2017, 09:27 AM
Post #1


Newbie
*

Group: Members
Posts: 7
Joined: 25-April 17
Member No.: 51,933



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

CODE
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.

CODE
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.
Go to the top of the page
 
+Quote Post
burleson
post Aug 25 2017, 12:34 PM
Post #2


Advanced Member
***

Group: Members
Posts: 13,532
Joined: 26-January 04
Member No.: 13



Hi Joe,

Check log_archive_dest_state2.

Also note several MOSC notes on this error:

Bug 10130767 : ORA-16606 TRYING TO VIEW DATA GUARD ARCHIVE GAP STATUS IN GRID CONTROL


--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Joe Valiyaveetti...
post Aug 26 2017, 01:38 AM
Post #3


Newbie
*

Group: Members
Posts: 7
Joined: 25-April 17
Member No.: 51,933



QUOTE (burleson @ Aug 25 2017, 11:04 PM) *
Hi Joe,

Check log_archive_dest_state2.

Also note several MOSC notes on this error:

Bug 10130767 : ORA-16606 TRYING TO VIEW DATA GUARD ARCHIVE GAP STATUS IN GRID CONTROL


Hi Burleson,

I have checked log_archive_dest_state2 and its showing as 'enable'


CODE
SQL> show parameter log_archive_dest_state_2;

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------
log_archive_dest_state_2             string      enable
log_archive_dest_state_20            string      enable
log_archive_dest_state_21            string      enable
log_archive_dest_state_22            string      enable
log_archive_dest_state_23            string      enable
log_archive_dest_state_24            string      enable
log_archive_dest_state_25            string      enable
log_archive_dest_state_26            string      enable
log_archive_dest_state_27            string      enable
log_archive_dest_state_28            string      enable
log_archive_dest_state_29            string      enable
SQL>



and I have checked log_archive_dest_2 also, which is empty.

CODE
SQL> show parameter log_archive_dest_2;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2                   string
log_archive_dest_20                  string


Can you please suggest what should I do which this.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 23rd September 2017 - 10:10 PM