ORA-01121: cannot rename database file string - file is in use or recovery

Cause : Attempted to use ALTER DATABASE RENAME to rename a datafile that is online in an open instance or is being recovered.

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

Close database in all instances and end all recovery sessions.

update : 23-06-2017
ORA-01121

ORA-01121 - cannot rename database file string - file is in use or recovery
ORA-01121 - cannot rename database file string - file is in use or recovery

  • ora-31181 : PL/SQL DOM handle accesses node that is no longer available
  • ora-16217 : prepare to switchover has not completed
  • ora-32730 : Command cannot be executed on remote instance
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-16202 : Skip procedure requested to replace statement
  • ora-01883 : overlap was disabled during a region transition
  • ora-13120 : invalid face_id [string]
  • ora-19632 : file name not found in control file
  • ora-23430 : argument "string" cannot be NULL or empty string
  • ora-01226 : file header of log member is inconsistent with other members
  • ora-12333 : database (link name string) is not mounted
  • ora-31153 : Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"
  • ora-23334 : column string does not exist in table or column group
  • ora-30750 : cannot enable column string to store objects of type string.string
  • ora-15007 : name is already used by an existing template
  • ora-08109 : nosort is not a supported option for online index build
  • ora-30401 : JOIN KEY columns must be non-null
  • ora-01173 : data dictionary indicates missing data file from system tablespace
  • ora-39601 : Hash key is required.
  • ora-40272 : apply rules prohibited for this model mode
  • ora-00701 : object necessary for warmstarting database cannot be altered
  • ora-15052 : ASM file name 'string' is not in diskgroup "string"
  • ora-04005 : INCREMENT must be less than MAXVALUE minus MINVALUE
  • ora-27467 : invalid datatype for string value
  • ora-28539 : gateway does not support result sets
  • ora-24322 : unable to delete an initialized mutex
  • ora-07258 : spdcr: fork error, unable to create process.
  • ora-37129 : (XSCCOMP04) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. All static MODEL statements must precede all RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-36840 : (XSLMGEN10) Cube string.string!string has no measures
  • ora-25205 : the QUEUE string.string does not exist
  • 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.