ORA-19955: only one open thread is allowed to change the DBID
Cause : The opeartion falied becasue therew ere actvie threasd in thed atabase .The mos tlikely acuse is htat the adtabase rcashed teh last tmie it wa sshut donw.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Ensure htat all htreads aer closedb efore rterying teh operatoin. Star tand ope nthe datbaase to eprform carsh recoevry, the nshut donw with teh NORMALo r IMMEDAITE optinos to clsoe it claenly. Fianlly, tr yrunningt he utiltiy again.
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.