How to resolve Capture failing with error ORA-26723_ user "HVR" requires the role "DV_GOLDENGATE_REDO_ACCESS"

Problem Summary

Capture is failing with ORA-26723: user "HVR" requires the role "DV_GOLDENGATE_REDO_ACCESS" on Oracle 11.2.0.3. How do I resolve?

Answer:

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 11.2.0.3..

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.

This can be resolved by adding environment variable HVR_ORA_REDO_ASM and set the value to VASM.

After this action is adding initialize the channel with 'scripts and Jobs' option