ORA-16632: instance being added to database profile
Cause : The Data Guard broker determined that an instance has successfully found its database profile within the broker configuration file, but yet lacks an instance-specific profile. The broker automatically creates an instance-specific profile and associates the instance with its database profile.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
No user action is required. The broker will automatically associate the instance with its database profile and incorporate the instance in broker activity.
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.