My Oracle Support Banner

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 and later
Information in this document applies to any platform.


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.




To view full details, 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 a vibrant support community of peers and Oracle experts.