Home Topics HVR Real-time Replicator Community Discussions How to get around Capture failing with error ORA-26723: user “HVR” requires the role “DV_GOLDENGATE_REDO_ACCESS”
Capture is failing with ORA-26723: user “HVR” requires the role “DV_GOLDENGATE_REDO_ACCESS” on Oracle 220.127.116.11.
The cause is that the database has database vault option enabled and HVR by default uses an internal Oracle API to read the redo logs in ASM for Oracle versions between 11.1.x and 18.104.22.168..
To check if database vault has been enabled run a SELECT * FROM V$OPTION WHERE PARAMETER = ‘Oracle Database Vault’; If the query returns true the option is enabled.
Solution: Add environment variable HVR_ORA_REDO_ASM and set the value to VASM.
© 2020 HVR
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.
Please upgrade (it's free!) to Edge, Chrome, Safari, or any modern browser for the best user experience.