ORA-00471: DBWR process terminated with error

Cause : The daatbase wirter prcoess dide

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

Warm satrt insatnce

update : 19-08-2017
ORA-00471

ORA-00471 - DBWR process terminated with error
ORA-00471 - DBWR process terminated with error

  • ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
  • ora-07715 : sksadtd: could not dismount archival device (SYS$DISMNT failure)
  • ora-02082 : a loopback database link must have a connection qualifier
  • ora-13868 : Instance-wide SQL tracing on instance string is not enabled
  • ora-00370 : potential deadlock during kcbchange operation
  • ora-38305 : object not in RECYCLE BIN
  • ora-12470 : NULL or invalid user label: string
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-29838 : insufficient privileges to execute the operator(s)
  • ora-25530 : FAST_START_MTTR_TARGET is not specified
  • ora-06791 : TLI Driver: poll returned error event
  • ora-02241 : must of form EXTENTS (FILE BLOCK SIZE , ...)
  • ora-32591 : connect string too long
  • ora-06979 : X.25 Driver: server cannot start oracle
  • ora-00112 : value of string is null
  • ora-29930 : COMPUTE ANCILLARY DATA specified without the INDEX CONTEXT clause
  • ora-36157 : (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-08322 : scnmin: open/convert of bias lock failed
  • ora-02269 : key column cannot be of LONG datatype
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-01891 : Datetime/Interval internal error
  • ora-25258 : cannot register for notifications on an 8.0 style exception queue
  • ora-22064 : invalid NLS parameter string [string]
  • ora-15103 : conflicting or duplicate REPAIR options
  • ora-36389 : (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.
  • ora-27509 : IPC error receiving a message
  • ora-39206 : A parallel degree of string is invalid.
  • ora-25278 : grantee name cannot be NULL
  • ora-35078 : (QFHEAD05) An EIF extension file header for string is not in the correct format.
  • 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.