1 Reply Latest reply: Aug 6, 2014 1:21 PM by 876213 RSS

    Error start transaction Log audit vault on 12c

    wmasmaddy

      Hai,

       

      Currently i work on Audit Vault 12c.The problem when i start the transaction log,this error will occurred;

       

      2014-05-08T14:20:04.150+08:00] [collfwk] [ERROR] [] [] [tid: 22] [ecid: 11.1.12.50:45800:1399517608305:0,0] RedoCollector : sourceSetup : Error while source setup for REDO collector.

      [2014-05-08T14:20:04.355+08:00] [collfwk] [ERROR] [] [] [tid: 22] [ecid: 11.1.12.50:45800:1399517608305: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:617)

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

      Nested Exception:

      java.sql.SQLException: ORA-04063: package body "AVSYS.DBMS_SRC_STREAMS_COLLECTOR" has errors

      ORA-06508: PL/SQL: could not find program unit being called: "AVSYS.DBMS_SRC_STREAMS_COLLECTOR"

      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.executeQuery(OraclePreparedStatement.java:3628)

        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)

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

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

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

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

        at com.sun.proxy.$Proxy2.executeQuery(Unknown Source)

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

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

       

      ]]

       

      it seems the function DBMS_SRC_STREAMS_COLLECTOR was not created yet.or any script i need to run to create this function.

       

      This error i got on agent side which on target database server;

       

      Regards,

      asmaddy

        • 1. Re: Error start transaction Log audit vault on 12c
          876213

          We experienced a similar problem after removing archive logs from our source database server via operating system commands which disrupted the Oracle Stream between the two databases, source and repository.  After removing the transaction log collector, we issued the following command on both databases, source and repository, as sys before recreating the transaction log collector:

           

          exec DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION;