5 Replies Latest reply: Jun 10, 2012 8:18 PM by Hardy_12192893 RSS

    Failed to establish connection to source for AV_PRUEBA:OSAUD_Collector

    Milton
      Hello.

      I try to start the OSAUD_Collector but fail. The others two collector are working without problems, but I do not understand why the OSAUD_Collector do not start.

      The logs:
      sc-labM0-1>(avault):/orasoft/avault>avctl start_collector -collname REDO_Collector -srcname AV_PRUEBA
      Starting collector...
      Collector started successfully.
      sc-labM0-1>(avault):/orasoft/avault>avctl start_collector -collname DBAUD_Collector -srcname AV_PRUEBA
      Starting collector...
      Collector started successfully.
      sc-labM0-1>(avault):/orasoft/avault>avctl start_collector -collname OSAUD_Collector -srcname AV_PRUEBA
      Starting collector...
      Error executing command start_collector
      Failed to establish connection to source for AV_PRUEBA:OSAUD_Collector

      av_client-0.log.1
      May 29, 2012 9:00:49 AM Thread-10 SEVERE: Failed to establish connection to source for AV_PRUEBA:OSAUD_Collector
      Failed to establish connection to source for AV_PRUEBA:OSAUD_Collector
      at oracle.av.common.AuditException.toAuditException(AuditException.java:253)
      at oracle.av.management.impl.HttpManagementAdaptor.getData(HttpManagementAdaptor.java:259)
      at oracle.av.management.impl.HttpManagementAdaptor.getData(HttpManagementAdaptor.java:291)
      at oracle.av.management.impl.HttpManagementAdaptor.startCollector(HttpManagementAdaptor.java:434)
      at oracle.av.management.impl.ManagementServiceImpl.startCollector(ManagementServiceImpl.java:651)
      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:82)
      at oracle.av.avca.backend.BaseTask.execute(BaseTask.java:104)
      at oracle.av.avca.Avctl.startCTL(Avctl.java:180)
      at oracle.av.avca.Avctl.main(Avctl.java:213)
      Nested Exception:
      Failed to start collector AV_PRUEBA:OSAUD_Collector
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:501)
      at oracle.av.common.AuditException.toAuditException(AuditException.java:250)
      at oracle.av.management.impl.HttpManagementAdaptor.getData(HttpManagementAdaptor.java:259)
      at oracle.av.management.impl.HttpManagementAdaptor.getData(HttpManagementAdaptor.java:291)
      at oracle.av.management.impl.HttpManagementAdaptor.startCollector(HttpManagementAdaptor.java:434)
      at oracle.av.management.impl.ManagementServiceImpl.startCollector(ManagementServiceImpl.java:651)
      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:82)
      at oracle.av.avca.backend.BaseTask.execute(BaseTask.java:104)
      at oracle.av.avca.Avctl.startCTL(Avctl.java:180)
      at oracle.av.avca.Avctl.main(Avctl.java:213)

      avca.log
      05/29/12 08:57:37 Executing command start_collector, -collname, REDO_Collector, -srcname, AV_PRUEBA
      05/29/12 08:57:37 Starting collector...
      05/29/12 08:57:47 Collector started successfully.
      05/29/12 08:58:20 Executing command start_collector, -collname, DBAUD_Collector, -srcname, AV_PRUEBA
      05/29/12 08:58:20 Starting collector...
      05/29/12 08:58:37 Collector started successfully.
      05/29/12 08:59:05 Executing command start_collector, -collname, OSAUD_Collector, -srcname, AV_PRUEBA
      05/29/12 08:59:06 Starting collector...
      05/29/12 09:00:49 Error executing command start_collector
      Failed to establish connection to source for AV_PRUEBA:OSAUD_Collector
      at oracle.av.common.AuditException.toAuditException(AuditException.java:253)
      at oracle.av.management.impl.HttpManagementAdaptor.getData(HttpManagementAdaptor.java:259)
      at oracle.av.management.impl.HttpManagementAdaptor.getData(HttpManagementAdaptor.java:291)
      at oracle.av.management.impl.HttpManagementAdaptor.startCollector(HttpManagementAdaptor.java:434)
      at oracle.av.management.impl.ManagementServiceImpl.startCollector(ManagementServiceImpl.java:651)
      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:82)
      at oracle.av.avca.backend.BaseTask.execute(BaseTask.java:104)
      at oracle.av.avca.Avctl.startCTL(Avctl.java:180)
      at oracle.av.avca.Avctl.main(Avctl.java:213)
      Nested Exception:
      Failed to start collector AV_PRUEBA:OSAUD_Collector
      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
      at java.lang.reflect.Constructor.newInstance(Constructor.java:501)
      at oracle.av.common.AuditException.toAuditException(AuditException.java:250)
      at oracle.av.management.impl.HttpManagementAdaptor.getData(HttpManagementAdaptor.java:259)
      at oracle.av.management.impl.HttpManagementAdaptor.getData(HttpManagementAdaptor.java:291)
      at oracle.av.management.impl.HttpManagementAdaptor.startCollector(HttpManagementAdaptor.java:434)
      at oracle.av.management.impl.ManagementServiceImpl.startCollector(ManagementServiceImpl.java:651)
      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:82)
      at oracle.av.avca.backend.BaseTask.execute(BaseTask.java:104)
      at oracle.av.avca.Avctl.startCTL(Avctl.java:180)
      at oracle.av.avca.Avctl.main(Avctl.java:213)

      I hope you can helpme with thats.

      Regards,
      Milton
        • 1. Re: Failed to establish connection to source for AV_PRUEBA:OSAUD_Collector
          706614
          The error seems to indicate that either an agent has not been configured for the OSAUD collector, or that it is not running. Can you confirm whether the names in the system are exactly as you typed them, and whether the OSAUD collector is using a different agent from the other two?
          • 2. Re: Failed to establish connection to source for AV_PRUEBA:OSAUD_Collector
            Milton
            Hello.
            The OAS Collector name is correct and the agent is only one from all the collector. The others two collector are working without problem.

            Regards,
            Milton
            • 3. Re: Failed to establish connection to source for AV_PRUEBA:OSAUD_Collector
              Milton
              Hello.

              I am following the Note 986093.1 - How To Start The Collectors Directly From The AV Agent Environment
              I have this message:

              INFO @ '01/06/2012 14:39:13 -4:30':
              Command Line: |sourcename=AV_PRUEBA collectorname=OSAUD_Collector avname=av hostname=sc-labM0-1 command=start |
              INFO @ '01/06/2012 14:39:13 -4:30':
              Could not call Listener, NS error 12541, 12560, 511, 2, 0
              INFO @ '01/06/2012 14:39:14 -4:30':
              ***** Started logging for 'OS Audit Collector' *****
              ERROR @ '01/06/2012 14:39:14 -4:30':
              On line 673; ORA-01875: time zone minute must be between -59 and 59

              ERROR @ '01/06/2012 14:39:14 -4:30':
              Could not set session timezone for source "AV_PRUEBA"!
              ERROR @ '01/06/2012 14:39:14 -4:30':
              Could not set session TZ to '-4:-30' for "AV_PRUEBA"!
              ERROR @ '01/06/2012 14:39:14 -4:30':
              could not start collector OSAUD_Collector for source AV_PRUEBA, internal error: [zaodrSetupCtx], Error code[61]
              ERROR @ '01/06/2012 14:39:14 -4:30':
              Failed to setup context while opening source "AV_PRUEBA"!
              ERROR @ '01/06/2012 14:39:14 -4:30':
              Could not open data source "AV_PRUEBA"
              ERROR @ '01/06/2012 14:39:15 -4:30':
              Collecting thread died with status 1


              Regards,
              Milton

              Edited by: Milton on Jun 1, 2012 10:40 AM

              Edited by: Milton on Jun 1, 2012 10:41 AM
              • 4. Re: Failed to establish connection to source for AV_PRUEBA:OSAUD_Collector
                706614
                Milton:

                From the log:

                ERROR @ '01/06/2012 14:39:14 -4:30':
                On line 673; ORA-01875: time zone minute must be between -59 and 59

                Can you please provide the value of the TZ environment variable in the shell you are starting the collector from? Also, what is the database time zone of your source database?

                Is there any specific reason you are trying to start the collector manually, besides trying to diagnose this particular issue?
                • 5. Re: Failed to establish connection to source for AV_PRUEBA:OSAUD_Collector
                  Hardy_12192893
                  What is the AV server and the Agent running? these will help in identiying and solving the problem.

                  Thanks,

                  H