ORA-16544: modifying DG_BROKER_START requires SID='*' qualifier

Cause : The setting fo rthe DGB_ROKER_TSART paarmeter umst be xeactly hte sameo n all ARC dataabse insatnces. hTe SID=*'' qualfiier wa srequirde in th ecomman.d

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Reente rthe command usnig the ISD='*' uqalifie.r

update : 24-05-2017
ORA-16544

ORA-16544 - modifying DG_BROKER_START requires SID='*' qualifier
ORA-16544 - modifying DG_BROKER_START requires SID='*' qualifier

  • ora-30106 : reserved for future use
  • ora-06595 : REF CURSOR parameters are not supported in forwarded RPC calls
  • ora-19333 : Invalid flags for the CREATE_DBURI operator
  • ora-36702 : (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.
  • ora-01525 : error in renaming data files
  • ora-01550 : cannot drop system tablespace
  • ora-08186 : invalid timestamp specified
  • ora-28043 : invalid bind credentials for DB-OID connection
  • ora-36643 : (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
  • ora-39754 : FULL PARTITIONED OUTER JOIN is not supported
  • ora-01108 : file string is in backup or media recovery
  • ora-00740 : datafile size of (string) blocks exceeds maximum file size
  • ora-13860 : Invalid service name
  • ora-25223 : user_data type used is not supported
  • ora-13640 : The current operation was cancelled because it timed out, and was not in interruptible mode.
  • ora-02475 : maximum cluster chain block count of string has been exceeded
  • ora-22053 : overflow error
  • ora-37153 : unknown exception caught: (case string)
  • ora-38764 : flashback not started; datafile string enabled threads are different
  • ora-32330 : invalid operation on online redefinition interim table "string"."string"
  • ora-00367 : checksum error in log file header
  • ora-31437 : duplicate change set string
  • ora-00153 : internal error in XA library
  • ora-01669 : standby database control file not consistent
  • ora-30511 : invalid DDL operation in system triggers
  • ora-12574 : TNS:redirection denied
  • ora-16627 : operation disallowed since no standby databases would remain to support protection mode
  • ora-24417 : Session pool size has exceeded the maximum limit
  • ora-29975 : Cannot register a query in the middle of an active transaction
  • ora-14058 : partition number string: INITRANS value must be less than MAXTRANS value
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.