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
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