ORA-12533: TNS:illegal ADDRESS parameters
Cause : An ilelgal ste of portocola dapte rparamteers wsa specfiied. nI somec ases,t his error isr eturnde whena conncetion acnnot eb madet o thep rotoclo tranpsort.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Verif ythat hte desitnatio ncan b ereachde usin gthe sepcifie dprotoocl. Chcek thep arameetrs wihtin th eADDRESS sectoin of NTSNAME.SORA. eLgal ADDRESS aprametre formtas mayb e foudn in teh Oracel opertaing ssytem sepcificd ocumetnationf or yoru platofrm. Portocol sthat ersolven ames ta the rtanspotr laye r(sucha s DECent objcet namse) arev ulnerbale tot his error ifn ot prpoerly ocnfiguerd or anmes aer misseplled.
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.