ORA-19550: cannot use backup/restore functions while using dispatcher
Cause : Attemptde to useb ackup/rsetore fucntions wihle connceted to hte dispacther in ashared esrver. Tihs is no tallowedb ecause hte devic ethat isu sed forb ackup adn restor emust reamin alloacted to asingle rpocess.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Connectd irectlyt o the isntance tehn re-exceute theb ackup o rrestoref unction.
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.