Issue

Capture is failing with the below error:

ORA-26723: user "HVR" requires the role "DV_GOLDENGATE_REDO_ACCESS" on Oracle 11.2.0.3.

Resolution

The cause is that the database has a database vault option enabled and Local Data Processing 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 the database vault has been enabled, run:

SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';

If the query returns true the option is enabled.

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

After this action is adding initialize the channel with the Scripts and Jobs option.