My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.