Wednesday, February 13, 2013

ORA-16792: configurable property value is inconsistent with database setting

[oracle@subhen_PRODdb04 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - 64bit Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
DGMGRL>  connect /
Connected.
DGMGRL> show configuration

Configuration - ORCLdg

  Protection Mode: MaxPerformance
  Databases:
    ORCL - Primary database
    ORCLB - Physical standby database
      Warning: ORA-16792: configurable property value is inconsistent with database setting

Fast-Start Failover: DISABLED

Configuration Status:
WARNING

DGMGRL> show instance verbose 'ORCLB2'

Instance 'ORCLB2' of database 'ORCLB'

  Host Name: orempr2db08.esp.aur.national.com.au
  PFILE:
  Properties:
    SidName                         = 'ORCLB2'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.47)(PORT=1621))(CONNECT_DATA=(SERVICE_NAME=ORCLB_DGMGRL)(INSTANCE_NAME=ORCLB2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '+FRA'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.dbf'
    TopWaitEvents                   = '(monitor)'

  Instance Warning(s):
    ORA-16714: the value of property StandbyArchiveLocation is inconsistent with the database setting
    ORA-16714: the value of property AlternateLocation is inconsistent with the database setting

Instance Status:
WARNING

DGMGRL> edit instance 'ORCLB2' set property StandbyArchiveLocation='+BACKUP';
Error: ORA-16664: unable to receive the result from a database

Failed.



DGMGRL> disable configuration
Disabled.
DGMGRL> remove configuration
Removed configuration
DGMGRL> show configuration
ORA-16532: Data Guard broker configuration does not exist

Configuration details cannot be determined by DGMGRL


-- set dg_broker_start=FALSE in both database(primary and standby) and also remove the broker files from ASM location

SQL> alter system set dg_broker_start=FALSE scope=both sid='*';

-- set dg_broker_start=TRUE and proceed for reconfiguring dgmgrl again

alter system set dg_broker_start=TRUE scope=both sid='*';

DGMGRL> create configuration ORCLDG as primary database is 'ORCL' connect identifier is 'ORCL';
Configuration "ORCLdg" created with primary database "ORCL"
DGMGRL> add database 'ORCLB' as connect identifier is 'ORCLB' maintained as physical;
Database "ORCLB" added
DGMGRL> show configuration

Configuration - ORCLdg

  Protection Mode: MaxPerformance
  Databases:
    ORCL - Primary database
    ORCLB - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
DISABLED

DGMGRL> enable configuration
Enabled.
DGMGRL> show configuration


Configuration - ORCLdg

  Protection Mode: MaxPerformance
  Databases:
    ORCL - Primary database
    ORCLB - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS


--- but i had a little proble from 2nd host of standby site

DGMGRL> connect /
Connected.
DGMGRL> show configuration


Configuration - ORCLdg

  Protection Mode: MaxPerformance
  Databases:
    ORCL - Primary database
    ORCLB - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
ORA-01017: invalid username/password; logon denied
ORA-16625: cannot reach database "ORCL"
DGM-17017: unable to determine configuration status


-- so i had copied the password file from other standby host and replaced(renamed) it and it works fine