My Oracle Support Banner

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

Last updated on APRIL 09, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.