ORA-16608: one or more databases have warnings

Cause : The Data Guard broker detected a warning status for one or more databases.

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

Locate the database(s) with a warning status and correct it.

update : 21-09-2017

ORA-16608 - one or more databases have warnings
ORA-16608 - one or more databases have warnings

  • ora-08455 : syntax error in CURRENCY SIGN environment clause
  • ora-06764 : TLI Driver: error reading disconnect
  • ora-26036 : subpartition load specified but table string is not subpartitioned
  • ora-19124 : fn:one-or-more() called with a sequence containing no items
  • ora-07286 : sksagdi: cannot obtain device information.
  • ora-08189 : cannot flashback the table because row movement is not enabled
  • ora-26515 : no master log available for 'string.string'
  • ora-10946 : trace name context forever
  • ora-01037 : maximum cursor memory exceeded
  • ora-09923 : Can't spawn process - user log directory not created properly
  • ora-04010 : the number of values to CACHE must be greater than 1
  • ora-27373 : unknown or illegal event source queue
  • ora-13249 : %s
  • ora-38775 : cannot disable flash recovery area - flashback database is enabled
  • ora-22317 : typecode number is not legal as a number type
  • ora-16045 : circular archive log destination dependency chain
  • ora-32622 : illegal multi-cell reference
  • ora-29893 : indextypes without column data do not need the given data type
  • ora-14055 : keyword REBUILD in ALTER INDEX REBUILD must immediately follow
  • ora-02442 : Cannot drop nonexistent unique key
  • ora-24384 : Application context size is not initialized
  • ora-16518 : unable to allocate virtual instance id
  • ora-09846 : soacon: ARCH unable to open named pipe.
  • ora-13789 : invalid process action
  • ora-01412 : zero length not allowed for this datatype
  • ora-18015 : invalid source outline signature
  • ora-15130 : diskgroup "string" is being dismounted
  • ora-00218 : block size string of control file 'string' does not match DB_BLOCK_SIZE (string)
  • ora-12350 : database link being dropped is still mounted
  • ora-07418 : sfareq: Database writer got error in timing function.
  • 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.