ORA-16792 Broker configuration "configurable property value is inconsistent with database setting"

Problèeme avec la configuration DataGuard Broker et un des paramètres de la BD

Symptôme :

            L’OEM a détecté ce message d’erreur

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

Cause:

            Une différence entre une valeur compris dans le spfile et le broker

Solution:

Le nom de la BD ci-dessous est juste un exemple, il faudrait s’assurer de travailler sur la bonne BD.

export ORACLE_SID=«NOMINSTANCE»

# dgmgrl

DGMGRL for Solaris: Version 12.1.0.2.0 - 64bit Production

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

Welcome to DGMGRL, type "help" for information.

DGMGRL> connect sys@«NOMINSTANCE»

Connected.

DGMGRL> SHOW CONFIGURATION;

Configuration - xxxxCONF

  Protection Mode: MaxPerformance

  Members:

  «NOMBDPRIM» - Primary database

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

  «NOMBDSTB»  - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

WARNING   (status updated 11 seconds ago)

DGMGRL> SHOW DATABASE VERBOSE '«NOMBDPRIM»' ;

Database - «NOMBDPRIM»

  Enterprise Manager Name: «NOMBDPRIM».xxxxxx.yy

  Role:                    PRIMARY

  Intended State:          TRANSPORT-ON

  Instance(s):

    «NOMINSTANCE»

      Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting

  Properties:

    DGConnectIdentifier             = '«NomBdPrim»'

    ObserverConnectIdentifier       = ''

    LogXptMode                      = 'ASYNC'

    RedoRoutes                      = ''

    DelayMins                       = '0'

    Binding                         = 'optional'

    MaxFailure                      = '0'

    MaxConnections                  = '1'

    ReopenSecs                      = '300'

    NetTimeout                      = '30'

    RedoCompression                 = 'DISABLE'

    LogShipping                     = 'ON'

    PreferredApplyInstance          = ''

    ApplyInstanceTimeout            = '0'

    ApplyLagThreshold               = '0'

    TransportLagThreshold           = '0'

    TransportDisconnectedThreshold  = '30'

    ApplyParallel                   = 'AUTO'

    StandbyFileManagement           = 'AUTO'

    ArchiveLagTarget                = '0'

    LogArchiveMaxProcesses          = '5'

…

    InconsistentLogXptProps         = '(monitor)'

    SendQEntries                    = '(monitor)'

    LogXptStatus                    = '(monitor)'

    RecvQEntries                    = '(monitor)'

…

    AlternateLocation               = ''

    LogArchiveTrace                 = '0'

    LogArchiveFormat                = '%t_%s_%r.dbf'

    TopWaitEvents                   = '(monitor)'

Database Status:

WARNING

DGMGRL> SHOW DATABASE '«NOMBDPRIM»' 'StatusReport';

STATUS REPORT

     INSTANCE_NAME   SEVERITY ERROR_TEXT

«NOMINSTANCE»    WARNING ORA-16714: the value of property ArchiveLagTarget is inconsistent with the database setting

                     

                     

DGMGRL> SHOW DATABASE '«NOMBDPRIM»' 'InconsistentProperties';

INCONSISTENT PROPERTIES

   INSTANCE_NAME     PROPERTY_NAME         MEMORY_VALUE         SPFILE_VALUE         BROKER_VALUE

   «NOMINSTANCE»     ArchiveLagTarget              3600                 3600                    0

DGMGRL> EDIT DATABASE '«NOMBDPRIM»' SET PROPERTY 'ArchiveLagTarget'=3600;

Property "ArchiveLagTarget" updated

DGMGRL> SHOW DATABASE '«NOMBDPRIM»' 'InconsistentLogXptProps';

DGMGRL> SHOW DATABASE VERBOSE '«NOMBDPRIM»';

Cela devrait être correct maintenant