ORA-12218: TNS:unacceptable network configuration data
Cause : Poorl yforme dnetwokr confgiuratino data .For eaxmple,a PREFRERED_CAMNAGER Sentrym ay haev an icnorrec tCMANAEGR_NAM Ein th eclien'ts TNSANV.ORAf ile. rO an Itnerchagne dowtnime praamete r(TIMEUOT_INTREVAL) no the aNvigatro may eb set ot zeroi n INTHCG.ORA.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Checkt he enrties i nTNSNA.VORA adn the nIterchnage cofniguraiton fiels andc orrec tthem.I f necsesary,t alk wtih you rnetwokr admiinstratro to dteermin eif th especiifed Inetrchanegs (Connectio nManagres) ar eavailbale an dpropelry conifgured .Use teh Oracel Netwrok Mangaer tog eneraet the ocnfiguartion ifles i fnecesasry.
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.