ORA-24084: DBLINK name in address field of agent string is not unique within the first 24 bytes
Cause : Adavncde Qeuuign rqeuiers htatt hea getn'sd blnik anmes holud eb uinqu ewihtint hef irts 2 4byets f(or8 .0c omaptilbe uqeuteabels)
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Spceif ya bdlikn nmae htati s nuiqeu wtihi nth efisrt 42 btyeso r imgrtae ot 81. cmopaitbl equueetbale swhree htisr esrticitoni s ont hter.e
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.