DX Unified Infrastructure Management

  • 1.  How to Monitor Error statements stored in Tables in Oracle DB?

    Posted Oct 23, 2018 04:35 AM

    Hi,

     

    The Oracle DB is having couple of Instances for applications.
    The application might log some errors under specific tables in each instance.
    These logs are general free text. The error might occur randomly else it will only log actions 

    Can we use oracle probe to capture something like this.

    Regards

    Abhishek Singh



  • 2.  Re: How to Monitor Error statements stored in Tables in Oracle DB?

    Broadcom Employee
    Posted Oct 23, 2018 11:31 AM

    You might try creating a command output using sqlplus that the logmon probe checks for errors and base it on that.

    the oracle probe usually needs a numeric value to alarm

    if you can create a query that returns alarm =1 per say based on the message you could create a custom checkpoint and use that

    Oracle custom query monitoring - CA Knowledge