Reply To: How to get around Capture failing with error ORA-26723: user “HVR” requires the role “DV_GOLDENGATE_REDO_ACCESS”

Herman Verheul

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

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.

Test drive
Contact us