DX Application Performance Management

  • 1.  Monitoring oracle alert.log file

    Posted May 05, 2017 05:33 AM

    Hello,

     

    Is it possible to create an alert on CA APM related to the alerts of type ORA-5xx for example in the alert.log file of an Oracle Database.



  • 2.  Re: Monitoring oracle alert.log file

    Broadcom Employee
    Posted May 05, 2017 07:03 AM

    HI Nacef:

        I took a quick look and did not see an immediate answer . But EP Agent and a log scraping script  should be able to do this. Did you explore that avenue?

     

    Thanks

    Hal German



  • 3.  Re: Monitoring oracle alert.log file

    Posted May 05, 2017 07:14 AM

    Hi Hallet,

     

    Thank you for your answer, 

    Any specific documentation to help implementing it?

     

    Best Regards

    Nassef



  • 4.  Re: Monitoring oracle alert.log file
    Best Answer

    Broadcom Employee
    Posted May 05, 2017 07:28 AM

    Dear Nacef:

    Thanks for asking 

    EP Agent - CA Application Performance Management - 10.5 - CA Technologies Documentation 

     

    Scripts gather information from a wide variety of sources, such as:

    Calling a library function or system utility to check the existence of a critical application, such as a database.

    Sample log readers scripts are included which generate metrics

     

    Also see https://docops.ca.com/ca-apm/10-5/en/implementing-agents/ep-agent/epagent-default-plug-ins#EPAgentDefaultPlug-ins-apacheLogReader.pl,weblogicLogReader.pl,andwebsphereLogReader.pl

     

    Is that enough to get you started? 

     

    I will ask internally for others to respond on other approaches

    Thanks

    Hal German



  • 5.  Re: Monitoring oracle alert.log file

    Posted May 05, 2017 08:57 AM

    thank you very much, i appreciate your help but i can't see an OracleLogReader among that list.



  • 6.  Re: Monitoring oracle alert.log file

    Broadcom Employee
    Posted May 05, 2017 09:14 AM

    Dear Nacef:

        That is correct. These are default scripts that you can use as examples on how to build one for the Oracle alert scripts. One is not supplied out of thebox. Perhaps someone else has done this already. I asked internally for others to respond as well

     

    Thanks

    Hal German



  • 7.  Re: Monitoring oracle alert.log file

    Posted May 05, 2017 09:25 AM

    Dear Hal, 

     

       Thank you very much. 

     

    Best Regards,

    Nassef