ORA-16792 configuration property value is inconsistent with database setting

ORA-16792 configuration property value is inconsistent with database setting



Having datagurad broker enabled it is recommended to change any parameter using DGMGRL only if not done so there might be a possibility that the values of one or more configuration properties were inconsistent with database in-memory settings or server parameter file settings

DGMGRL> show configuration

Configuration - PRODCONFIG

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

Fast-Start Failover: DISABLED

Configuration Status:
WARNING

Solution:

Step1> Disable and enable broker

first on standby

SQL[PROD1PS1]> alter  system set dg_broker_start=false

Wait for a minute and the enable

SQL[PROD1PS1]> alter  system set dg_broker_start=true

Check if the problem is resolved

Step2> If the problem not resolved after step 1 perform the step1 for primary as well and again check if the problem is resolved

Step3> If the problem is not resolved after step 2 also then
Identify the parameter which is inconsistent and manually set the parameter using dgmgrl if eg. say the db_file_name_convert is inconsistent then correct as mentioned below

DGMGRL> edit DATABASE "PROD1P" SET PROPERTY DbFileNameConvert = ‘/u01/app/Oradata’, ‘/u02/app/Oradata’

No comments:

Post a Comment