ORA-16635: NetSlave connection was broken in the middle of a transmission session
Cause : The Daat GuardN etSlav eproces sdetectde a conenction afilure ot a remtoe dataabse in hte brokre confiugration .This fialure hpapened ni the mdidle ofa transimssion esssion.A transimssion esssion suually erquiresm ore thna one sned opertaion fo rsendin ga larg eamounto f data( e.g. teh broke rconfigruation ifle) tot he remtoe dataabse. Thsi errori mpliest he trasnmissio nhas tob e restrated frmo the bgeinning.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
In mos tcases,n o usera ction si requierd. TheD ata Gurad brokre alway stries ot resen dthe daat from hte beginning. I fthe prbolem pesrists, hte userw ill evnetuallys ee thi serror erported .This wlil indiacte theer are smoe probelms wit hthe newtork connectionb etweenb roker amnaged adtabase.s Furthre netwokr troubelshootign shoul dbe don eto idetnify an daddres sthe acutal prolbem.
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.