This discussion is archived
5 Replies Latest reply: Mar 14, 2012 1:59 PM by 706614 RSS

After change the agent user password. Collector failed to be started.

may@cb Newbie
Currently Being Moderated
I alter the agent user password on av server database and also used command "avca create_credential " change the password on wallet. I restart agent sucessfully, however can not start collector on console and command line and got following error.
avctl start_collector -collname OSAUD_Collector -srcname pps1_integration
Starting collector...
Error executing command start_collector
Internal Error

Please advise. Thanks in advance.


May
  • 1. Re: After change the agent user password. Collector failed to be started.
    706614 Explorer
    Currently Being Moderated
    Please look at $ORACLE_HOME/av/log/avca.log in the Server home to see if there are more detailed errors. You can also look at $ORACLE_HOME/av/log/agent.log and agent.err on the agent side for clues.
  • 2. Re: After change the agent user password. Collector failed to be started.
    may@cb Newbie
    Currently Being Moderated
    It did show below message. Do you know what caused the package lost and how to fix it? Thanks.


    03/12/12 02:13:28 Executing command start_collector, -collname, OSAUD_Collector, -srcname, pps1_integration
    03/12/12 02:13:28 Starting collector...
    03/12/12 02:13:29 Error executing command start_collector
    Internal Error
    at oracle.av.management.impl.HttpManagementAdaptor.persistCommand(HttpManagementAdaptor.java:364)
    at oracle.av.management.impl.HttpManagementAdaptor.collectAgentMetrics(HttpManagementAdaptor.java:525)
    at oracle.av.management.impl.ManagementServiceImpl.isAgentAlive(ManagementServiceImpl.java:458)
    at oracle.av.management.impl.ManagementServiceImpl.startCollector(ManagementServiceImpl.java:632)
    at oracle.av.management.impl.ManagementServiceImpl.startCollector(ManagementServiceImpl.java:696)
    at oracle.av.management.impl.ManagementServiceImpl.startCollector(ManagementServiceImpl.java:707)
    at oracle.av.avca.control.StartCollectorTask.executeTask(StartCollectorTask.java:93)
    at oracle.av.avca.backend.BaseTask.execute(BaseTask.java:104)
    at oracle.av.avca.Avctl.startCTL(Avctl.java:163)
    at oracle.av.avca.Avctl.main(Avctl.java:191)
    Nested Exception:
    java.sql.SQLException: ORA-06550: line 1, column 14:
    PLS-00201: identifier 'AVSYS.DBMS_AUDIT_VAULT' must be declared
    ORA-06550: line 1, column 8:
    PL/SQL: Statement ignored

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

    at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3475)
    at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4399)
    at oracle.av.management.impl.HttpManagementAdaptor.persistCommand(HttpManagementAdaptor.java:353)
    at oracle.av.management.impl.HttpManagementAdaptor.collectAgentMetrics(HttpManagementAdaptor.java:525)
    at oracle.av.management.impl.ManagementServiceImpl.isAgentAlive(ManagementServiceImpl.java:458)
    at oracle.av.management.impl.ManagementServiceImpl.stopCollector(ManagementServiceImpl.java:764)
    at oracle.av.management.impl.ManagementServiceImpl.stopCollector(ManagementServiceImpl.java:826)
    at oracle.av.avca.control.StopCollectorTask.executeTask(StopCollectorTask.java:104)
    at oracle.av.avca.backend.BaseTask.execute(BaseTask.java:104)
    at oracle.av.avca.Avctl.startCTL(Avctl.java:163)
    at oracle.av.avca.Avctl.main(Avctl.java:191)
  • 3. Re: After change the agent user password. Collector failed to be started.
    706614 Explorer
    Currently Being Moderated
    Question:

    Did you run the 'avca create_credential' command on the AV Server or on the Agent?

    The error suggests that you ran it on the server, which means the credentials the 'avctl' command uses to connect to the server are now the agent's credentials, which does not have permissions to access the packages needed to start the collector.
  • 4. Re: After change the agent user password. Collector failed to be started.
    may@cb Newbie
    Currently Being Moderated
    I did change the password on agent wallet using avca create_credential. Do you mean should on server wallet instead of agent wallet? Thanks.

    May
  • 5. Re: After change the agent user password. Collector failed to be started.
    706614 Explorer
    Currently Being Moderated
    Hi May:

    What I meant was, the error suggests that the avca create_credential command was run not on the agent wallet but on the server wallet.

    Please try this:

    On the Server, look up $ORACLE_HOME/network/admin/tnsnames.ora. The first entry in the file should point to the AV Server. With that alias, try running the command:

    sqlplus /@<alias> (where <alias> is the first entry in the file).

    Does that succeed?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points