ZDLRA: Reconcile failing with ORA-64776 "No additional information" (Doc ID 2760543.1)

Last updated on JANUARY 26, 2022

Applies to:

Symptoms

• The replication of the Protected db is failing during the reconcile with the following error :
  
  DBGRCVCAT: awsr=/orssv/rcfile/forwatermarks_1828661106.xml
  DBGRCVCAT: sqlcode after set_authentication on: 0
  DBGRCVCAT: Content-length = 2214
  DBGRCVCAT: reconcile_diag_mesg : Http_Client_Error: retrycnt: 0 status_code:
  msg:"No additional information"
  codedesc:"No additional information",
  db_key=13082407
  DBGRCVCAT: reconcile_diag_mesg : writeFixedSections(fail) watermarks
  error:ORA-64776: message from downstream replication server during reconcile
  client put:"No additional information", db_key=13082407
  DBGRCVCAT: doReplicationReconcile: resync (fail):ORA-64776: message from
  downstream replication server during reconcile client put:
  "No additional information"
  BEGIN dbms_ra_int.replication_reconcile( 'PROTECTED_DB_UNIQUE_NAME' , 'REPLICATION_USER'); END;

  *
  ERROR at line 1:
  ORA-64773: Note: Error generated during execution of API command: Reconcile
  failed. Check incident log
  ORA-06512: at "RASYS.DBMS_RA_INT", line 1440
  ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
  ORA-06512: at "RASYS.DBMS_RA_INT", line 1408
  ORA-06512: at line 1

• Verify the replication user has access for the Protected db in Downstream :
  
  
  SQL> select * from ra_db_access order by db_unique_name;

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.