If you apply the SDR patch 9.78.11, Oracle replications fail with this error:
Oracle.DataAccess.Client.OracleException ORA-06550: line 1, column 75:
PLS-00201: identifier 'DBMS_LOGMNR.NEW' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at nn.g7()
at qn.a(Int32 iDestID)
at qn.a(Boolean& A_0)
at gm.f()
To resolve the issue add SYNONYM permissions:
CREATE PUBLIC SYNONYM DBMS_LOGMNR FOR SYS.DBMS_LOGMNR;