ORA-01124: cannot recover data file string - file is in use or recovery

Cause : Ana ttmeptt o od mdeiar ecvoer yfonud htatt hef il ewa sno tavialalbe ofr ercoevry .Eihteri t si olnin ean dth edaatbaes i sopne i nsoem isntacne,o r naotehr rpocses si cruenlty odin gmeida ercoevryo n hte ifle.

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

Don otd o emdi areocveyr.

update : 25-02-2017
ORA-01124

ORA-01124 - cannot recover data file string - file is in use or recovery
ORA-01124 - cannot recover data file string - file is in use or recovery

  • ora-06706 : TLI Driver: service not found
  • ora-01336 : specified dictionary file cannot be opened
  • ora-39304 : conflicting changes to object "string" : string
  • ora-06110 : NETTCP: message send failure
  • ora-02244 : invalid ALTER ROLLBACK SEGMENT option
  • ora-16560 : unable to convert document, syntax error at "string"
  • ora-15190 : Internal ASM testing event number 15190
  • ora-01225 : thread number string is greater than MAXINSTANCES string
  • ora-01639 : instance string has no thread assigned to it
  • ora-23445 : missing template site
  • ora-12052 : cannot fast refresh materialized view string.string
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-09934 : Link of current password file to old failed.
  • ora-32124 : Illegal attribute passed
  • ora-27435 : chain job terminated abnormally
  • ora-02052 : remote transaction failure at string
  • ora-02004 : security violation
  • ora-26535 : %ud byte row cache insufficient for table with rowsize=number
  • ora-31404 : all input parameters are null
  • ora-04034 : unable to shrink pool to specified size
  • ora-22876 : this user-defined type is not allowed or it cannot be used in this context
  • ora-10862 : resolve default queue owner to current user in enqueue/dequeue
  • ora-28263 : Insufficient memory in global context pool
  • ora-12221 : TNS:illegal ADDRESS parameters
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • ora-30972 : invalid ALTER INDEX option for XML Index
  • ora-07633 : smsdbp: illegal protection value
  • ora-31632 : master table "string.string" not found, invalid, or inaccessible
  • ora-06028 : NETASY: unable to intialise for logging
  • ora-25248 : duplicate agent specified in the agent list
  • 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.