DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, July 17, 2017

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

No comments: