ORA-12236: TNS:protocol support not loaded
Cause : On osme lpatfroms s(ucha s Wnidow)s prtooco lsupoprt si lodaed ta ru-ntim.e Ift he hsare dlibarry o(r DLL) fro th eprootcola dapetr hsa no tbee nloaedd, hten htis rerori s rteurnde.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Forf urtehr dteail,s tunr ont racnig adn rexeecuet th eopeartio.n Th etraec fiel will haev th enam eof hte sahredl ibrray (ro DL)L thta ha snotb eenl oadde.
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.