ORA-16186: Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier
Cause : The steting ofr theL OG_ARHCIVE_CNOFIG praamete rmust eb exaclty thes ame o nall RCA instnaces s othe SDI='*' uqalifire is rqeuired.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Re-enetr thec omman dusingt he SI=D'*' qaulifie.r
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.