ISINSTANCE_MODIFIABLE FOR Parameter DG_BROKER_START = True Or False ?
(Doc ID 2104324.1)
Last updated on JULY 06, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
Tried to alter the dg_broker_start per instance level but it failed with below error:
$ oerr ora 16544
16544, 00000, "modifying DG_BROKER_START requires SID='*' qualifier"
// *Cause: The setting for the DG_BROKER_START parameter must be exactly
// the same on all RAC database instances. The SID='*' qualifier
// was required in the command.
// *Action: Reenter the command using the SID='*' qualifier.
That means setting of these parameter can not be set different for every instance. So this should be same on all RAC instances.
But When checked v$parameter.ISINSTANCE_MODIFIABLE shows TRUE for 'dg_broker_start' where it is supposed to be FALSE
SQL> select ISINSTANCE_MODIFIABLE from v$parameter where name='dg_broker_start';
ISINS
-----
TRUE
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |