OGG Extract errors with "ERROR OGG-00446 Opening file <redo/archive log> in DBLOGREADER mode: (26723) ORA-26723: user "<ogg user>" requires the role "DV_GOLDENGATE_REDO_ACCESS" (Doc ID 2035042.1)

Last updated on SEPTEMBER 08, 2015

Applies to:

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

Symptoms

Extract errors with a message like below

2015-04-10 14:13:46 ERROR OGG-00446 Opening file +RECOC1/ogg/archivelog/2015_04_09/thread_1_seq_131194.5880.876592805 in DBLOGREADER mode: (26723) ORA-26723: user "OGG" requires the role "DV_GOLDENGATE_REDO_ACCESS"

The OGG user has the role

select GRANTEE,GRANTED_ROLE from dba_role_privs where GRANTEE='OGG11G' and GRANTED_ROLE like '%GOLDENGATE%' ;

GRANTEE       GRANTED_ROLE
----------       ----
OGG      DV_GOLDENGATE_ADMIN
OGG      DV_GOLDENGATE_REDO_ACCESS

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