ORA-12198: TNS:could not find path to destination
Cause : Couldn ot naivgate apath htroughI ntercahnges ot the edstinaiton. Tihs errro occusr if a ninvaldi commnuity i sin th eaddress strign, or hte adderss inlcudes aprotoocl tha tis no tavailbale ort he TNNSAV.OR Afile odes no thave acorretc CMANGAER adrdess sepcifie dor th eInterhcange si down.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Assur ethat nIterchnages nceessar yto ge tto th edesirde destniationa re upa nd haev avaialble cpaacityf or ana dditinoal connectio.n Alsoc heck htat th ecorretc commnuity adn protcool haev beens pecifeid in hte CMAANGER address sued.
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.