Can't Setup REDO LOG / AVDF Transaction Log Collector With Database Vault Enabled On Source Database, Fails With Error ORA-1031

(Doc ID 2348921.1)

Last updated on FEBRUARY 13, 2018

Applies to:

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

Symptoms

[2017-11-13T19:36:45.540+00:00] [collfwk] [ERROR] [] [] [tid: 31] [ecid: 1499872840:55982:1510601805800:0,0] RedoCollector : sourceSetup : Error while source setup for REDO collector.
[2017-11-13T19:36:45.885+00:00] [collfwk] [ERROR] [] [] [tid: 31] [ecid: 1499872840:55982:1510601805800:0,0] OAV-9010: Could not configure transaction log collection on source.CollectionFactory : createCollection : AuditException while creating collection. [[
Could not configure transaction log collection on source.
  at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.sourceSetup(RedoCollector.java:656)
  at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.setup(RedoCollector.java:488)
  at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.startCollector(RedoCollector.java:227)
  at oracle.av.platform.agent.collfwk.impl.redo.RedoCollectorManager.startTrail(RedoCollectorManager.java:227)
  at oracle.av.platform.agent.collfwk.impl.factory.CollectionFactory.createCollection(CollectionFactory.java:565)
  at oracle.av.platform.agent.collfwk.impl.factory.CollectionFactory.createCollection(CollectionFactory.java:392)
  at oracle.av.platform.agent.StartTrailCommandHandler.processMessage(StartTrailCommandHandler.java:63)
  at oracle.av.platform.agent.AgentController.processMessage(AgentController.java:588)
  at oracle.av.platform.agent.AgentController$MessageListenerThread.run(AgentController.java:3082)
  at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_PROPAGATION_INTERNAL", line 407
ORA-06512: at "SYS.DBMS_PROPAGATION_ADM", line 41
ORA-06512: at line 1
ORA-06512: at "I_SRCUSER_ORA.DBMS_SRC_STREAMS_COLLECTOR", line 1869
ORA-06512: at line 1

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
  at oracle.jdbc.driver.

Changes

 Database Vault has been enabled and  DV_SECANALYST role has been granted to AV User which was used to create the Secure database Target.

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