Thursday, July 31, 2014

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

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

When we are editing the init parameter's which is effecting the DB broker then we need to change the property value in the db broker also .. 
when we changed the property in of the SQL> alter system set log_archive_max_processes=10 scope=both sid='*'; then we need to change the same property in the db broker configuration file also by following method 
you can find what are the int parameter's used by the db broker by using the show database verbose <database_name>
Step 1 Check the status in the dgmgrl When we get the error in Db broker config  then we need to check the  particular database


Step 2 check the two database's configuration
For checking the configuration of the each database we need to type the command as show configuration <database_name>
As when we are checking the Stand by database We are getting the inconsistent property error for the LogArchiveMaxProcesses .. because we had changed the process  in the standby database by using the alter system command
Step 3 check the inconsistent properties

For checking the Inconsistent Properties we need to give the command show database<database name> InconsistentProperties
it will show what are the process are inconsistent in the below example we have two process because we are using the two node rac as the stadnby database
Legends
Instance_name:=Name of the instance where the inconsistent properties are located
Property_Name :=  Name of the inconsistent  Property 
Memory_value:=  10[the value which is located in the memory of the database]
Spfile_value:=     10[the value which is specified in the spfile]
db broker_value:=4[the value which is specified in the db broker ]

INCONSISTENT PROPERTIES
   INSTANCE_NAME      PROPERTY_NAME            MEMORY_VALUE  SPFILE_VALUE    BROKER_VALUE
   OMDRDB1            LogArchiveMaxProcesses                               10               10              4
   OMDRDB2            LogArchiveMaxProcesses                               10               10              4

Step 4 Set the Properties which had been change and set the correct value

Once we had identified the wrong propery value we need to edit the property of the database 
for editing the property of the database
edit database <db_name> SET PROPERTY property_name=value
Here in the below example we are editing the database to have max of 10 processes

Once you changed the property they you will not able to find the values when you query for inconsistent property then no values are displayed
  Finally check the configuration again and check now both the configuration are successful

No comments:

Post a Comment