GoldenGate Extract with DBLOGER Abend: ORA-26723: User "Xxxx" Requires the Role "DV_GOLDENGATE_REDO_ACCESS"
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate - Version 126.96.36.199.6 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.
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