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
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.