DX Infrastructure Management

Expand all | Collapse all

How to Monitor Error statements stored in Tables in Oracle DB?

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

    Posted 10-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?

    Posted 10-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