ORA-12648: Encryption or data integrity algorithm list empty
Cause : An Oracle Advanced Security list-of-algorithms parameter was empty, e.g. "()".
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Change the list to contain the name of at least one installed algorithm, or remove the list entirely if every installed algorithm is acceptable.
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.