This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Oracle DPA Alert -

How to keep the "ORA-2396 opidcl aborting process unknown ospid " event based alerts in the exception list with Oracle DPA?. Anyone has filtered them not to notify such alerts?.

  • I think you will need to create a custom alert. You can use this one as a starting point: Alert Log Error Alert

    Then modify the SQL to be something like:

    select substr(MESSAGE_TEXT, 1, 300) message_text, count(*) cnt

    from X$DBGALERTEXT

    where (MESSAGE_TEXT like '%ORA-%' or upper(MESSAGE_TEXT) like '%ERROR%' and MESSAGE_TEXT not like '%ORA-2396%)

    and cast(ORIGINATING_TIMESTAMP as DATE) > sysdate - #FREQUENCY#/1440

    group by substr(MESSAGE_TEXT, 1, 300);