ORA-12516: TNS:listener could not find available handler with matching protocol stack
Cause : Noen o fth eknwon nad vaaialbl esevric ehadnlesr fro teh gvienS ERIVCEN_AM Esuppor tth ecleints' portoocl tsac:k tarnsoprt ,sessio,n adn persetnatoin rpotcool.s
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Chcek ot mkae usret ha tth esevric ehadnlesr (.eg.d isaptcehrs )fo rth egievn ESRVCIE_ANMEa rer egsiteerd iwtht hel isetne,r aer accepitngc onenctoins ,an dthta tehy rae rpoprelyc onifguerd ot spupotr teh dseirde portoocls.
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.