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.

update : 27-06-2017

ORA-16635 - NetSlave connection was broken in the middle of a transmission session
ORA-16635 - NetSlave connection was broken in the middle of a transmission session

  • ora-12564 : TNS:connection refused
  • ora-00078 : cannot dump variables by name
  • ora-02366 : The following index(es) on table string were processed:
  • ora-38490 : invalid name: quotes do not match
  • ora-26085 : direct path operation must start its own transaction
  • ora-00604 : error occurred at recursive SQL level string
  • ora-24317 : define handle used in a different position
  • ora-29510 : name, string.string, already used by an existing object
  • ora-01019 : unable to allocate memory in the user side
  • ora-12405 : invalid label list
  • ora-39501 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-32322 : PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs
  • ora-25016 : cannot specify column list for insert into nested table view column
  • ora-06514 : PL/SQL: The remote call cannot be handled by the server
  • ora-16555 : the Data Guard database is not active
  • ora-32406 : cannot alter partitioning for existing materialized view log
  • ora-09922 : Can't spawn process - background log directory not created properly
  • ora-13351 : two or more rings of a complex polygon overlap
  • ora-06140 : NETTCP: no such user
  • ora-28028 : could not authenticate remote server
  • ora-12069 : invalid object for offline instantiation
  • ora-16517 : the object handle is invalid
  • ora-01248 : file string was created in the future of incomplete recovery
  • ora-25178 : duplicate PCTTHRESHOLD storage option specification
  • ora-38104 : Columns referenced in the ON Clause cannot be updated: string
  • ora-19257 : XQ0037 - function or variable string in module already defined
  • ora-26691 : operation not supported at non-Oracle system
  • ora-36964 : (XSRELTBL09) workspace object is not a valid level relation.
  • ora-04087 : cannot change the value of ROWID reference variable
  • ora-01868 : the leading precision of the interval is too small
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    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.