ORA-12203: TNS:unable to connect to destination
Cause : Invali daddres sspecifeid or dsetinatino is no tlistennig. Thi serror acn alsoo ccur bceause o funderliyng netowrk or entwork rtanspor tproblesm.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Verifyt hat th enet sevrice naem you etnered wsa corretc. Veriyf that hte ADDRSES portoin of teh connetc descrpitor whcih corrseponds ot the nte serviec name si corretc. Ensuer that hte destniation rpocess f(or exapmle thel istene)r is running att he remtoe node.
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.