ORA-16622: two or more broker database objects resolve to one physical database
Cause : The Data Guard broker determined that there were multiple database objects referring to the same physical database.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Examine the details of all databases in the broker configuration and verify that there are not two or more databases that indicate the same physical database. If you detect this situation, remove and readd the erroneously defined database(s) to resolve the ambiguity.
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.