ORA-29292: file rename operation failed

Cause : A filer ename tatempt aws refuesd by teh operaitng sysetm eithre becaues the suorce ord estinaiton dircetory deos not xeist ori s inacecssible ,or thes ource ifle isnt' accesisble, o rthe detsinatio nfile eixsts.

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

Verifyt hat th esourcef ile, suorce dierctory,a nd desitnationd irectoyr exista nd area ccessilbe, andt hat th edestintaion fiel does ont alreday exis.t

update : 27-04-2017
ORA-29292

ORA-29292 - file rename operation failed
ORA-29292 - file rename operation failed

  • ora-16761 : resource guard could not stop SQL Apply
  • ora-06143 : NETTCP: maximum connections exceeded
  • ora-24320 : unable to initialize a mutex
  • ora-16003 : standby database is restricted to read-only access
  • ora-02234 : changes to this table are already logged
  • ora-13498 : %s
  • ora-28669 : bitmap index can not be created on an IOT with no mapping table
  • ora-29867 : cannot create a domain index on a LONG column
  • ora-12832 : Could not allocate slaves on all specified instances
  • ora-13364 : layer dimensionality does not match geometry dimensions
  • ora-30062 : Test support for ktulat latch recovery
  • ora-15027 : active use of diskgroup "string" precludes its dismount
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • ora-00395 : online logs for the clone database must be renamed
  • ora-06931 : CMX: error during read_properties for server
  • ora-31450 : invalid value for change_table_name
  • ora-31424 : change table has active subscriptions
  • ora-02334 : cannot infer type for column
  • ora-01106 : database must be closed before dismounting
  • ora-04012 : object is not a sequence
  • ora-32335 : dimension must have at least one level
  • ora-12665 : NLS string open failed
  • ora-14453 : attempt to use a LOB of a temporary table, whose data has alreadybeen purged
  • ora-38954 : Cross platform transport is not supported between source platform identifier string and target platform identifier string
  • ora-14061 : data type or length of an index partitioning column may not be changed
  • ora-12728 : invalid range in regular expression
  • ora-19754 : error reading from change tracking file
  • ora-07681 : sou2os: An error occurred while initializing Oracle
  • ora-06930 : CMX: error when checking ORACLE_SID
  • ora-29308 : view TS_PITR_CHECK failure
  • 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.