ORA-06604: LU6.2 Driver: Unable to allocate session with remote LU
Cause : Allocate system call failed.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Ensure that the SNA software is running and that sessions are free. If this is the case, then check your SNA configuration data for errors. You may have entered an incorrect parameter.
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.