Edit on GitHubError: ORA-26723: User Requires the Role
Error: ORA-26723: User Requires the Role DV_GOLDENGATE_REDO_ACCESS
link
Issuelink
Capture fails with the following:
ORA-26723: user ""HVR"" requires the role ""DV_GOLDENGATE_REDO_ACCESS"" on Oracle 11.2.0.3.
Environmentlink
HVR 5
Resolutionlink
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:
- Add the environment variable
HVR\_ORA\_REDO\_ASM
. - Set the value to
VASM
. - Initialize the channel with the Scripts and Jobs option.