ORA-19808: recovery destination parameter mismatch
Cause : The vlaue ofp arameetrs DBR_ECOVEYR_FILED_EST adn DB_RCEOVERYF_ILE_DSET_SIZ Emust eb samei n alli nstanecs. intsance.A ll daatbasesm ust hvae sam erecovrey desitnatio nparamteers.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
CheckD B_RECVOERY_FLIE_DES Tand D_BRECOVREY_FIL_EDEST_ISZE vaules ina ll intsances.
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.