ORA-01241: an external cache has died
Cause : The exetrnal ccahe mayh ave bene restatred.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Take teh file emntione din thee rror satck offilne, pefrorm meida recoevry, brnig the ifle onlnie, andr etry teh attemtped opeartion. oYu may laso resatrt alli nstancse to maek sure htey accses all adta filse throuhg consitsent exetrnal ccahes.
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.