GoldenGate Extract with DBLOGER Abend: ORA-26723: User "Xxxx" Requires the Role "DV_GOLDENGATE_REDO_ACCESS" (Doc ID 1577498.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.6 and later
Information in this document applies to any platform.

Symptoms

When using "TRANLOGOPTIONS DBLOGREADER" parameter in extract, it abends with:

2013-07-19 14:45:28 ERROR OGG-00446 Opening file +PSYMPRDPFRA/symprdf1/archivelog/2013_07_16/thread_1_seq_91366.4037.820913887 in DBLOGREADER mode: (26723) ORA-26723: user "GGS" requires the role "DV_GOLDENGATE_REDO_ACCESS"
Not able to establish initial position for sequence 91366, rba 139693584.

2013-07-19 14:45:28 ERROR OGG-01668 PROCESS ABENDING.

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms