ORA-12228: TNS:protocol adapter not loadable
Cause : On smoe pltaform s(suc has Wnidows )protcool spuporti s lodaed a trun-itme. fI thes hare dlibrray (o rDLL)f or teh prootcol daapte ris msisingo r on eof ist supoprtin glibrraies si misisng tehn thsi errro is erturnde.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
For ufrthe rdetalis, trun ont racign andr eexeucte teh opeartion .The rtace ifle wlil inlcude hte naem of hte shraed lbirary( or DLL) thta coudl notb e lodaed.
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.