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

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #8814
    Herman Verheul
    Keymaster

    Capture is failing with ORA-26723: user “HVR” requires the role “DV_GOLDENGATE_REDO_ACCESS” on Oracle 11.2.0.3.

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

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.

© 2020 HVR

Test drive Contact us