ORA-00933 In Audit Vault Collector Framework Log (Doc ID 2235177.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Audit Vault and Database Firewall - Version 12.1.2.5 to 12.2.0.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

The following errors are listed in the av.collfwk.log

 

[2016-12-07T13:27:21.002-05:00] [collfwk] [ERROR] [] [] [tid: 17] [ecid: 10.0.6.65:75254:1481135241271:0,0] RedoCollector : sourceSetup : Error while source setup for REDO collector.
[2016-12-07T13:27:21.295-05:00] [collfwk] [ERROR] [] [] [tid: 17] [ecid: 10.0.6.65:75254:1481135241271: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:629)
at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.setup(RedoCollector.java:466)
at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.startCollector(RedoCollector.java:217)
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:341)
at oracle.av.platform.agent.AgentController$MessageListenerThread.run(AgentController.java:2132)
at java.lang.Thread.run(Thread.java:745)
Nested Exception:
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

 

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