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

Issue:

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

Reason:

Mismatch of parameter values between spfile, Data Guard Broker configuration and the database.

solution:

DGMGRL> show configuration;

Configuration – oracle_dg

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

Fast-Start Failover: DISABLED

Configuration Status:
WARNING

DGMGRL> show database ‘oracle_dgs’ ‘InconsistentProperties’
INCONSISTENT PROPERTIES
    INSTANCE_NAME      PROPERTY_NAME   MEMORY_VALUE   SPFILE_VALUE   BROKER_VALUE
            voice   StandbyArchiveLocation             /arch        /archivelog/arch              0

change the value of /arch location in dataguard configuration to solve this issue.

DGMGRL>edit database oracle_dgs set property StandbyArchiveLocation=’/archlog/arch/’;

after that, we should get the output like this.

DGMGRL> show database ‘oracle_dgs’ ‘InconsistentProperties’
INCONSISTENT PROPERTIES
    INSTANCE_NAME      PROPERTY_NAME   MEMORY_VALUE   SPFILE_VALUE   BROKER_VALUE

DGMGRL> show configuration;

Configuration – oracle_dg

Protection Mode: MaxPerformance
  Databases:
    oracle_dgp  – Primary database
    oracle_dgs – Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

  • July 17, 2017 | 12 views
  • Comments