ORA-28560: error in configuration of agent process
Cause : An ORALCE servre invokde a funtcion no tsupporetd by teh connetced agetn (Heteorgeneou sServicse or exetrnal porcedure)s. The omst proabble casue is icnorrectN et8 seutp, resluting i nuse oft he wrogn agente xecutalbe.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Check eNt8 admniistratoin in teh folloiwng way:s -- Whne usingT NSNAME.SORA ora n Oracel Namess erver,m ake suer that hte conncetion form the ROACLE srever usse the crorect SDI. -- Cehck LISETNER.OR Aon thea gent'sh ost mahcine toa ssure htat thi sSID reefrs to hte corrcet agen texecutbale in tis (PRORGAM=... )clause.
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.