ORA-01122: database file string failed verification check

Cause : The information in this file is inconsistent with information from the control file. See accompanying message for reason.

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

Make certain that the db files and control files are the correct files for this database.

update : 24-06-2017
ORA-01122

ORA-01122 - database file string failed verification check
ORA-01122 - database file string failed verification check

  • ora-00285 : TIME not given as a string constant
  • ora-07622 : smscre: $CREATE failure
  • ora-34896 : (PPMONTHS00) At least 12 month names must be given. Only number were provided.
  • ora-01034 : ORACLE not available
  • ora-22328 : object "string"."string" has errors. string
  • ora-24315 : illegal attribute type
  • ora-33460 : (ESDREAD10) Discarding compiled code for workspace object because object workspace object is not in analytic workspace string.
  • ora-31651 : communication error with master process - detaching job
  • ora-01578 : ORACLE data block corrupted (file # string, block # string)
  • ora-24851 : failed to connect to shared subsystem
  • ora-32763 : Turn off N-Pass Temp LOB cleanup
  • ora-32034 : unsupported use of WITH clause
  • ora-00117 : PROTOCOL, ADDRESS or DESCRIPTION must be specified
  • ora-30369 : maximum number of columns is 32
  • ora-25271 : queue table not found for the given queue
  • ora-07285 : sksaprd: volume size should not be specified for a disk file.
  • ora-12708 : error while loading create database NLS parameter string
  • ora-18015 : invalid source outline signature
  • ora-23441 : object does not exist for refresh group template
  • ora-16179 : incremental changes to "string" not allowed with SPFILE
  • ora-19931 : file string has invalid creation SCN string
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-13765 : Value "string" is illegal for a result limit.
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-16258 : marking index unusable due to a constraint violation
  • ora-32834 : Messaging Gateway agent user has not been set
  • ora-03221 : Temporary tablespaces and temporary segments must have standard block size
  • ora-08455 : syntax error in CURRENCY SIGN environment clause
  • ora-26098 : direct path context is not prepared
  • ora-23384 : replication parallel push string argument out of range
  • 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.