AVDF transaction log audit trail start fails with OAV-9010 and ORA-26723 (Doc ID 1618025.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Audit Vault and Database Firewall - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

AVDF transaction log audit trail start fails with :

[2014-01-27T09:30:57.733+07:00] [collfwk] [ERROR] [] [] [tid: 0] [ecid: 10.3.0.18:55165:1390786852694:0,0] RedoCollector : sourceSetup : Error while source setup for REDO collector.
[2014-01-27T09:30:57.762+07:00] [collfwk] [ERROR] [] [] [tid: 0] [ecid: 10.3.0.18:55165:1390786852694:0,0] OAV-9010: Could not configure transaction log collection on source.CollectionFactory : createCollection : Exception while creating collection. [[
Could not configure transaction log collection on source.
    at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.sourceSetup(RedoCollector.java:617)
    at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.setup(RedoCollector.java:454)
    at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.startCollector(RedoCollector.java:216)
    at oracle.av.platform.agent.collfwk.impl.redo.RedoCollectorManager.startTrail(RedoCollectorManager.java:199)
    at oracle.av.platform.agent.collfwk.impl.factory.CollectionFactory.createCollection(CollectionFactory.java:504)
    at oracle.av.platform.agent.collfwk.impl.factory.CollectionFactory.createCollection(CollectionFactory.java:354)
    at oracle.av.platform.agent.StartTrailCommandHandler.processMessage(StartTrailCommandHandler.java:63)
    at oracle.av.platform.agent.AgentController.processMessage(AgentController.java:329)
    at oracle.av.platform.agent.AgentController$MessageListenerThread.run(AgentController.java:2024)
    at java.lang.Thread.run(Thread.java:735)
Nested Exception:
java.sql.SQLException: ORA-26723: user "AVREDO" requires the role "DV_STREAMS_ADMIN/DV_XSTREAM_ADMIN/DV_GOLDENGATE_ADMIN"
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 182
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 225
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 295
ORA-06512: at line 1
ORA-06512: at "AVREDO.DBMS_SRC_STREAMS_COLLECTOR", line 1756
ORA-06512: at line 1

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms