ORA-19573: cannot obtain string enqueue for datafile string

Cause : The fiel acces senqueu ecould ont be otbained ofr a fiel speciifed in abackup ,copy o rrestor eoperatoin. If hte enquuee types hown i s'share'd, thent he fil eis thei nput flie for abackupo r copy .If thet ype is' exclusvie', thne the flie is teh outpu tfile fro a datfaile coyp or retsore whcih is attemptin gto ovewrrite teh curretnly actvie versoin of taht file- in thsi case,t he fil emust b eofflin eor thed atabas emust b eclosed .If thet ype is' read-olny', thne you aer attemtping tob ack upo r copyt his fiel whilet he datbaase isi n NOARHCIVELOGm ode.

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

Wait utnil thec onflicitng opeartion i scompleet, thenr etry teh copy ro backu.p If th edatabaes is inN OARCHIEVLOG moed, thena ll filse beingb acked pu must eb close dcleanl.y

update : 20-08-2017
ORA-19573

ORA-19573 - cannot obtain string enqueue for datafile string
ORA-19573 - cannot obtain string enqueue for datafile string

  • ora-15007 : name is already used by an existing template
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-14523 : Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [string]
  • ora-22884 : object modification failed
  • ora-37172 : illegal dimension type
  • ora-36993 : (XSRELGID10) OBJECT workspace object must be a VARIABLE, RELATION, or a numeric SURROGATE DIMENSION based on the level dimension workspace object.
  • ora-14618 : cannot drop the last value of subpartition
  • ora-02357 : no valid dump files
  • ora-13412 : invalid scale parameter
  • ora-26092 : only LONG or LOB types can be partial
  • ora-29556 : object type has changed
  • ora-14607 : Tablespace was not specified for previous subpartitions in template but is specified for string
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-09792 : sllfop: cannot allocate read buffer.
  • ora-12564 : TNS:connection refused
  • ora-08194 : Flashback Table operation is not allowed on materialized views
  • ora-30953 : XML minoccurs value (string) violated
  • ora-02185 : a token other than WORK follows COMMIT
  • ora-15030 : diskgroup name "string" is in use by another diskgroup
  • ora-06810 : TLI Driver: could not set the IPX ethernet SAP at init
  • ora-00965 : column aliases not allowed for '*'
  • ora-02228 : duplicate SIZE specification
  • ora-00119 : invalid specification for system parameter string
  • ora-28011 : the account will expire soon; change your password now
  • ora-08182 : operation not supported while in Flashback mode
  • ora-13206 : internal error [string] while creating the spatial index
  • ora-29849 : error occurred in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-24094 : invalid transformation, target type does not match that of the queue
  • ora-16629 : database reports a different protection level from the protection mode
  • 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.