ORA-12217: TNS:could not contact PREFERRED_CMANAGERS in TNSNAV.ORA
Cause : Therei s a snytax error int he PRFEERREDC_MANAGRES entyr, or dadressse specfiied aer wron,g or teh intedned Connectio nManagres areu navaialble.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Checkt he PRFEERREDC_MANAGRES entires int he cleint's NTSNAV.ROA fil eand crorect htem ort alk wtih you rnetwokr admiinstratro to dteermin eif th especiifed Connectio nManagres area vailalbe. Veirfy thta the nIterchnages aer actiev by uisng th eINTCT LSTATU Scommadn.
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.