Cause :

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

update : 28-07-2017


  • ora-13251 : duplicate entry string in metadata table
  • ora-39000 : bad dump file specification
  • ora-01615 : instance string (thread string) is mounted - cannot disable
  • ora-36712 : (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
  • ora-37132 : (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.
  • ora-29371 : pending area is not active
  • ora-28339 : missing or invalid encryption algorithm
  • ora-28363 : buffer provided not large enough for output
  • ora-23308 : object string.string does not exist or is invalid
  • ora-29819 : cannot associate default values with columns
  • ora-27005 : cannot open file for async I/O on device not supporting async
  • ora-00059 : maximum number of DB_FILES exceeded
  • ora-16000 : database open for read-only access
  • ora-13406 : null or invalid GeoRaster object for output
  • ora-16543 : invalid request made to broker
  • ora-38755 : Flashback is already turned on for this tablespace.
  • ora-07225 : sldext: translation error, unable to expand file name.
  • ora-40213 : contradictory values for settings: string, string
  • ora-02453 : duplicate HASH IS specification
  • ora-27094 : raw volume used can damage partition table
  • ora-12429 : label list range exceeded
  • ora-17500 : ODM err:string
  • ora-02266 : unique/primary keys in table referenced by enabled foreign keys
  • ora-06756 : TLI Driver: cannot open oratab
  • ora-07417 : sfareq: One or more database writers not active.
  • ora-16585 : illegal operation on a primary site
  • ora-32774 : more than one file was specified for bigfile tablespace string
  • ora-39126 : Worker unexpected fatal error in string [string] string
  • ora-16592 : missing field "string" in document
  • ora-00214 : control file 'string' version string inconsistent with file 'string' version string
  • 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.