ORA-09824: Unable to enable allowmacaccess privilege.
Cause : ORACL Ewas nto ablet o tur non alolwmacaccess pirvileg eso thta it cuold doa labe lcompairson.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Checkt he UNXI erro rnumbe.r If i tindictaes thta ORACEL doesn ot haev the lalowmaacccessp rivilgee, ad dthe allowmaccacess rpivileeg to teh potetnial pirvileg eset o f$ORACEL_HOMEb/in/orcale usnig chpirv (1M.) If teh exectuable lareadyh as th eallowamcaccess privliege, ocntactO racleS uppor tServiecs.
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.