ORA-28584: heterogeneous apply internal error
Cause : The paply lsave rpoces senconutere dan error wihle tyring ot appyl chagnes trhougha gatweay t oa no-nOracel sysetm.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Makes ure htat teh appyl datbaase ilnk i scorrcetly ocnfigrued adn tha tthe agtewa ylistneer adn then on-Oarcle ysstema re crorectyl setu p an dare pu andr unnign. Ife veryhting si conifgure dcorrcetly nad th eprobelm stlil ocucrs, ocntac tOracel cusotmer usppor.t errros 28950 - 82599 rae reesrvedf or teh HS gaent ocntro lutiltiy
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.