Configuring OEM 13c Incident Rules and Sending Alerts [Step By Step Tutorial : Part-10]

[@krishnaarekar1278]

Sir Could you please explain what should be the receiver's email ID in this case? is is Yahoo mail id or what sir. Thanks in advance.

[@YouVolve]

Hello Krishna - Thanks for your question. The receiver should be the one who is responsible and can respond to a database alert. Usually it the DBA of the database who is responsible. For example, if a tablespace 99% full alert comes, the DBA can add space to the tablespace. Ideally the email id should be the corporate or company email id of the DBA or the responsible person. But if you are configuring it for learning purpose, you may use a personal email id like Gmail or Yahoo etc. Gmail is little restrictive to allow its SMTP server to be configured with third party applications but Yahoo is easy so I demonstrated using my Yahoo id. Hope this will clarify your doubt.

[@krishnaarekar1278]

@@YouVolve Thank you sir for your response. If possible could you please confirm where should be the receiver's email id configured. It's in the OEM console only in the Enterprise Manager Password and Email section in E- mail addresses section only, please confirm once. Awaiting your response sir.

[@YouVolve]

@@krishnaarekar1278 - The receiver's email has to be configured in the incident rules. This video has everything from start to finish about creating incident rules, configure receiver email, testing SMTP server etc. Please watch the video thoroughly to understand the concepts and do not skip the video.

[@krishnaarekar1278]

@@YouVolve Sir, okay thank you. I will do watch the complete video. Thanks once again sir.

[@YouVolve]

Anytime.

[@fabiodelicato9290]

Very well done. Great job!

[@YouVolve]

Thank you very much for watching my video and sharing your feedback.

[@DUMIE63]

Hello Manash, Thank you for your guidance and clear instructions in your lessons. Is there a way for us to tell OEM13 to still send the notifications despite the fact that the datafiles are set to auto-extend within the tablespace(s)? Regards Andre

[@YouVolve]

Hi Andre, Thanks for your feedback. By default OEM does not send alerts on utilization for tablespaces with auto-extensible datafiles. But you can create a Metric Extension (ME) to send such alerts. Please watch the video below to learn how to create an ME for special purposes: kzbin.info/www/bejne/gqDJeoeIaJiWfNU In your case you have to use the SQL below in the ME to create an incident on utilization for tablespaces with auto-extensible datafiles: With t as (SELECT tablespace_name, round(sum(MAXBYTES/1024/1024)) max_mb, round(sum(BYTES/1024/1024)) current_mb, round(sum(USER_BYTES/1024/1024)) data_mb FROM dba_data_files where AUTOEXTENSIBLE='YES' group by tablespace_name ), t2 AS (select tablespace_name, MAX(round((data_mb/decode(max_mb,0,1,max_mb))*100)) Usage_pc, ROW_NUMBER() OVER (ORDER BY MAX(round((data_mb/decode(max_mb,0,1,max_mb))*100)) DESC) RN from t GROUP BY tablespace_name) select tablespace_name,Usage_pc from t2 where rn=1 Please note that ME can accept a SQL who returns only one single row. So, the SQL is written in a way to return only the tablespace with highest utilization. Also you have to define two columns in the ME as the SQL returns two values. First the tablespace name and second the utilization percentage. You have to adjust the thresholds in the column definition to generate the appropriate alert. Hope this will help.

[@DUMIE63]

@@YouVolve Hi Manash, Many thanks for your prompt reply and very helpful support.☺

[@YouVolve]

Glad that it helped.

[@SumanGirijaHi]

very good explanation . please help with videos on targets for standby region OMS , another requirement on video - to create OMS and OMR at standby server , and make the agents understand both primary OMS and standby OMS .. When Primary OMS is down , still agents need to understand Standby OMS is reachable , so should be monitored

[@YouVolve]

Thanks for your feedback. Those topics are in my to-do list.

[@venkkatmerla4389]

Hi Manash, I have created a create for process parameter configuration which is available in the database limits , the rule was configured but I am unable to see the values for that rule , I mean what is the threshold for warning and critical , I assigned that group , i don’t want to configure process parameter from metric template can you please help me here. Thanks , Venkat merla

[@YouVolve]

@venkkatmerla4389 - Your question is not very clear to me. But I am trying to answer my best. First be sure to understand what Monitoring Template, Incident Rule and Metric Collections these 3 things refer to. You cannot define thresholds in a incident ruleset as it is for defining the rules for actions to be taken based on severity of an incident. Like what to do when there a Critical incident or what to do when a Warning incident etc. How to determine if an incident is a Critical or Warning is defined in the "Metric and Collection Settings" for the database or target. There you will get the option to define the thresholds for different severities. What kind of alert are you trying to configure in OEM. If you want to alert when a certain % of the processes have been utilized or you want an alert if a database has a process parameter set or changed to less than a certain value? In the first case Metric and Collection Settings already has the metric defined under Database Limits, you just need to define Warning and Critical % values. In the second case, there is no inbuilt metric so you have to create a Metric Extension for that. Please watch this video which will clear up the concepts: kzbin.info/www/bejne/oGrFcmCulsyjqbs

[@venkkatmerla4389]

Hi Manash, I am testing one process parameter configuration in one of my environment, I just want to copy rule set which are available in the prod OEM to other OEM is that possible? Kindly help me with your inputs

[@YouVolve]

@venkkatmerla438 - Yes, you can copy a rule set from one OEM to another provided they are of the same version using the Export/Import options. To do that, select the rule set line then under Actions menu select the Export option. That will create an XML file with the name of the rule set and download automatically. You can then copy that xml file to another OEM system and import it using the Import option under the Actions menu in the target OEM system.

[@venkkatmerla4389]

@@YouVolve thank you Manas

[@abdulmusawir1000]

Great

[@YouVolve]

Thanks

[@swathikummari4906]

VM installation is pending from Storage Team for New OEM installation. Meanwhile, I am working on to integrate OEM monitoring with PagerDuty application( which works as our oncall management tool). Also, i am trying to follow below link for the same,please let me know is it the correct way to do it or recommend me anything if that works. kzbin.info/www/bejne/roeapqyFfbapfq8 Basically,our primary goal is to get the OEM alert on our phones and within 30minutes if the on-call person is not responding,it has to go to all the team members when we are on weekends or on-call such that no alert should go missing atleast for production databases. In order to install and configure Pagerduty with OEM,I have to set the Oracle Support credentials in OEM which are failing to authenticate even if they are the correct ones. Request you to please help me setup the credentials for Oracle Support and need your guidance on this to move forward. Please find the attached screenshots for your reference.

[@YouVolve]

@swathikummari4906 - Thanks for your question. You do not need the MOS credentials to configure PagerDuty (PD). You just need the DL or the email id that you get for your DBA team from PD. For example you may get something like: [e-mail]. All the policies and escalation hierarchies are configured in PD side like the on-call rotation schedule, minutes before escalation to the next level etc. Once you get the DL, just add that to an action against one of the rules as I have shown in my video. In my video I am adding my personal email ID to the rule as an action to send an alert email. You may add one more rule or an action to send the alert to your PD email and PD will take care of the remaining stuff. Usually PD is sent for production alerts so you have to select the appropriate rule to add the PD DL. Hope this will help.