ORA-16502: the Data Guard broker operation succeeded with warnings

Cause : The Data Guard broker operation succeeded with warnings.

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

See accompanying messages for details.

update : 24-06-2017
ORA-16502

ORA-16502 - the Data Guard broker operation succeeded with warnings
ORA-16502 - the Data Guard broker operation succeeded with warnings

  • ora-38612 : FI item length cannot exceed half of one database block.
  • ora-12659 : Error received from other process
  • ora-24391 : invalid fetch operation
  • ora-00474 : SMON process terminated with error
  • ora-12491 : DBHIGH value does not dominate DBLOW
  • ora-30180 : argument index is too large
  • ora-01185 : logfile group number string is invalid
  • ora-04022 : nowait requested, but had to wait to lock dictionary object
  • ora-14126 : only a may follow description(s) of resulting partitions
  • ora-22856 : cannot add columns to object tables
  • ora-04000 : the sum of PCTUSED and PCTFREE cannot exceed 100
  • ora-30476 : PLAN_TABLE does not exist in the user's schema
  • ora-25329 : AQ array operations not allowed on 8.0 queues
  • ora-16574 : switchover disallowed when required databases are offline
  • ora-32690 : Hash Table Infrastructure ran out of memory
  • ora-34514 : (MXOPERR) You cannot string string data in the expression that begins with 'string'.
  • ora-27209 : syntax error in device PARMS - unknown keyword or missing =
  • ora-26663 : error queue for apply process string must be empty
  • ora-13431 : GeoRaster metadata rasterType error
  • ora-14028 : missing AT or VALUES keyword
  • ora-38769 : FLASHBACK DATABASE failed after modifying data.
  • ora-10944 : trace name context forever
  • ora-29326 : SET COMPATIBILITY release number higher than string
  • ora-16553 : the Data Guard broker process (DMON) failed to shutdown
  • ora-08180 : no snapshot found based on specified time
  • ora-25130 : cannot modify primary key - primary key not defined for table
  • ora-39078 : unable to dequeue message for agent string from queue "string"
  • ora-01873 : the leading precision of the interval is too small
  • ora-01664 : Transaction which has expanded the Sort Segment has aborted
  • ora-32812 : subscriber string does not exist
  • 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.