ORA-19696: control file not found in backup set
Cause : The control file could not be restored because it is not in this backup set.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
This message is issued when the directory from the first backup piece is read and one or more files named for restoration were not found in the piece. You must supply the first backup piece of a backup set that contains the requested file.
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.