My Oracle Support Banner

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


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%' ;

----------       ----


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.