goldengate ERROR OGG-00870 Database error 26887 (ORA-26887: Insufficient privileges to attach to XStream inbound server)
- From: "k.hadd" <kouss.hd@xxxxxxxxx>
- To: ORACLE-L <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 27 Aug 2019 14:22:01 -0400
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.
Other related posts:
- » goldengate ERROR OGG-00870 Database error 26887 (ORA-26887: Insufficient privileges to attach to XStream inbound server) - k.hadd
