goldengate ERROR OGG-00870 Database error 26887 (ORA-26887: Insufficient privileges to attach to XStream inbound server)

From: k.hadd <kouss.hd_at_gmail.com>
Date: Tue, 27 Aug 2019 14:22:01 -0400
Message-ID: <CAF+xsmRO6eX5KJ+2huP3LX9_--W69=--PHG=Fm1UpfYtWaS_vA_at_mail.gmail.com>

Hi ,
 I stumbled upon this error lately when configuring a bidirectional test replication between two 12c multi-tenant Databases. The initial direction is still working fine (SRC>TARGET).
 But when I added the replicat on the former SRC system using a login with rights on the PDB in question the process still ABBENDs.  Has any of you encountered such errors ? the MOS Doc ID 2327707.1 <https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=304000296660815&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2327707.1&_afrWindowMode=0&_adf.ctrl-state=17n14j94oy_4>  didn't help to fix it.

Thanks in advance
Koss

Here are the param files :

Toronto new SRC :

> view params TO_SCOT

EXTRACT to_scot
UserIdAlias gg_admin
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
DISCARDFILE ./dirrpt/to_scot.dsc,purge
EXTTRAIL ./dirdat/et
DDL INCLUDE MAPPED OBJNAME PDB.SCOTT.*
DDLOPTIONS REPORT
TABLE PDB.SCOTT.*;
> view params TO_epump

EXTRACT to_epump
PASSTHRU
PASSTHRUMESSAGES
RMTHOST montreal.evilcorp.com ,MGRPORT 7809 RMTTRAIL ./dirdat/rm
TABLE PDB.SCOTT.* ; MONTREAL : new Target

 view params r_mscot

replicat r_mscot
useridalias repuserPDB
assumetargetdefsdiscardfile ./dirrpt/rep_mscot.dsc, purge, megabytes 10 discardrollover on sunday
SOURCECATALOG PDB
HANDLECOLLISIONS
map PDB.SCOTT.*, target PDB.SCOTT.*;

 error :
2019-08-27 14:00:50 ERROR OGG-00870 Database error 26887 (ORA-26887: Insufficient privileges to attach to XStream inbound server "OGG$R_MSCOT".). 2019-08-27 14:00:50 ERROR OGG-01668 PROCESS ABENDING.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Aug 27 2019 - 20:22:01 CEST