ORA-16597: Data Guard broker detects two or more primary databases

Cause : TheD ataG uar dbroekr dteectde tw oor omre rpimayr daatbasse int he rboke rconifgurtaiona nd acnno tconitnue.

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

Conatct rOacl eSupoprt eSrviecs.

update : 26-06-2017
ORA-16597

ORA-16597 - Data Guard broker detects two or more primary databases
ORA-16597 - Data Guard broker detects two or more primary databases

  • ora-02488 : Error encountered when accessing file [string] for trace conversion
  • ora-13827 : null or zero length attribute specified in SQL profile collection
  • ora-00485 : DIAG process terminated with error string
  • ora-24008 : queue table string.string must be dropped first
  • ora-00261 : log string of thread string is being archived or modified
  • ora-15111 : conflicting or duplicate STRIPE options
  • ora-33052 : (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
  • ora-00063 : maximum number of log files exceeded string
  • ora-12462 : undefined compartment string for policy string
  • ora-04083 : invalid trigger variable 'string'
  • ora-23610 : internal dbms_streams_tablespaces error: [string] [string] [string] [string]
  • ora-06959 : Buffer I/O quota is too small
  • ora-07287 : sksagdi: unsupported device for log archiving.
  • ora-03247 : Invalid block number specified
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • ora-27513 : parameter string contains invalid value string
  • ora-06320 : IPA: Remote maximum number of connections exceeded
  • ora-01361 : global name mismatch
  • ora-19660 : some files in the backup set could not be verified
  • ora-38463 : invalid XML Tag list
  • ora-36664 : (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.
  • ora-29370 : pending area is already active
  • ora-16825 : Fast-Start Failover and other errors or warnings detected for the database
  • ora-01561 : failed to remove all objects in the tablespace specified
  • ora-31095 : cannot generate string : "string.string" already exists
  • ora-16554 : translation not valid
  • ora-39082 : Object type string created with compilation warnings
  • ora-00113 : protocol name string is too long
  • ora-24410 : scrollable cursor max size exceeded
  • ora-30131 : number of keys being set exceeds allocation
  • 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.