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

#8816
Herman Verheul
Keymaster

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.

Solution: Add environment variable HVR_ORA_REDO_ASM and set the value to VASM.

© 2020 HVR

Test drive Contact us