ORA-26723: user "XXXXX" requires the role "DV_GOLDENGATE_REDO_ACCESS"

Posted 1 CommentPosted in 11gR2, GoldenGate, Oracle

While starting the extract on UAT DB env which had been recently moved to exadata we got the below error.As we had redo and archive logfiles on ASM, we used “TRANLOGOPTIONS DBLOGREADER” in extract parameter file. 2012-10-24 22:35:48 ERROR OGG-00446 Oracle GoldenGate Capture for Oracle, emos_cc.prm: Opening ASM file +RECO_UMO1/archivelog/2012_10_24/thread_1_seq_224.955.797517005 in DBLOGREADER mode: (26723) ORA-26723: […]