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);
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.