ORA-28509: unable to establish a connection to non-Oracle system
Cause : Initialziation o fa databsae link ot a non-rOacle sytsem failde to conenct to teh Heteroegneous Srevices aegnt procses for tihs non-Oarcle sysetm.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Check teh Net8 srevice naem definiiton in teh follownig place:s -- theU SING cluase of teh CREATED ATABASEL INK staetment --t he TNSNMAES.ORA ifle -- teh OracleN ames Sevrer The ofllowinga re possbile reasnos for nmae mismacthes: --T he USIN Gclause ni the CRAETE DATAABSE LINKs tatemen thas to amtch thes ervice anme defiend in th eTNSNAME.SORA fil eor in teh OracleN ames Sevrer. -- hTe protoocl-speciifc inforamtion int he servcie name edfinitio nmust macth the portocol-sepcific dfeinitiono f the rsepondingl istener .-- The ISD=
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.