2 Replies Latest reply: Dec 5, 2013 3:56 PM by user12003510 RSS

    Audit Vault 12.1.1 error creating audit trail with TRANSACTION LOG

    user12003510

      Hi,

       

      i installed AV 12.1.1 , the DB target is with Data Guard.

       

      when i run the script oracle_user_setup with the mode REDO_COLL the final message is that was succesfull , but when i go to the AV console and try to create an audit trail with TRANSACTION LOG the AV console shows me an error and the log shows me this :

       

      [2013-10-16T03:37:18.593-05:00] [collfwk] [ERROR] [] [] [tid: 10] [ecid: 192.168.56.8:78800:1381912639433:0,0] RedoCollector : runSourceScript : Error while running script on source for REDO collector.

       

      [2013-10-16T03:37:19.528-05:00] [collfwk] [ERROR] [] [] [tid: 10] [ecid: 192.168.56.8:78800:1381912639433:0,0] OAV-8004: Failed to start collector {0}:{1}CollectionFactory : createCollection : Exception while creating collection. [[

       

      Failed to start collector {0}:{1}

       

                      at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.runSourceScript(RedoCollector.java:816)

       

                      at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.sourceSetup(RedoCollector.java:579)

       

                      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:325)

       

                      at oracle.av.platform.agent.AgentController$MessageListenerThread.run(AgentController.java:1859)

       

                      at java.lang.Thread.run(Thread.java:679)

       

      Nested Exception:

       

      java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

       

      ORA-06512: at line 1

       

       

       

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

       

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

       

                      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)

       

                      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

       

                      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

       

                      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

       

                      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)

       

                      at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)

       

                      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)

       

                      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)

       

                      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3685)

       

                      at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1376)

       

                      at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)

       

                      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

       

                      at java.lang.reflect.Method.invoke(Method.java:616)

       

                      at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)

       

                      at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:124)

       

                      at $Proxy2.execute(Unknown Source)

       

                      at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.runSourceScript(RedoCollector.java:747)

       

                      at oracle.av.platform.agent.collfwk.impl.redo.RedoCollector.sourceSetup(RedoCollector.java:579)

       

                      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:325)

       

                      at oracle.av.platform.agent.AgentController$MessageListenerThread.run(AgentController.java:1859)

       

                      at java.lang.Thread.run(Thread.java:679)

       

       

       

      ]]

       

       

       

      i don't understand why the issue because the user has the privileges given by the script and i tried with grant as sysdba but without any result

       

       

       

      i don't understand what are the privileges that the collector needs.

       

      any idea?

       

      thnks for any help