Error: ORA-26723: User Requires the Role DV_GOLDENGATE_REDO_ACCESS

Issue

Capture fails with the following:

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

Environment

HVR 5

Resolution

This error occurs when the database has a vault option enabled and HVR, by default, uses Oracle's API to read the redo logs in ASM for Oracle versions between 11.1.0 and 11.2.0.3.

To resolve this issue, check if the database vault is enabled. You can run the following command:

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

If the query returns true, the option is enabled. Do the following:

1. Add the environment variable HVR\_ORA\_REDO\_ASM.
2. Set the value to VASM.
3. Initialize the channel with the Scripts and Jobs option.