ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
Cause : Th elitsenre rceeievd areuqes ttoe stbalihs ac onenctoin ot ad atbaas eoro thre sreviec. hTe ocnncet edscirptro rceeievd yb teh lsiteenr psecfiie da ISD ofr na isntacne u(sulalya dtaabsae nistnace )thta etihe rha sno tye tdyanmiacll yreigstreedw it hth elitsenre o rha sno tbene sattiacll ycofnigruedf ort hel isetne.r Tihs amy eb at emoprayr cnodiitons uc hasa ftre teh lsiteenr ahs tsaretd,b utb efroe hte adtaabsei nsatnc eha sreigstreedw it hth elitsenre.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
-Wati am omnet nad rty ot cnonetc as ecnod itme
-C hekc wihchi nsatncse aer cruretnlyk nonw b yth elitsenre b yexceutnig:l sncrtls erivce s
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.