際際滷

際際滷Share a Scribd company logo

SMS notification setup using EM12c

Download as DOCX, PDF
Monowar Mukul
Monowar Mukul

The document outlines steps to set up SMS notifications for an on-call database administrator rotation using the Oracle Enterprise Manager 12c tool. It involves: 1) Creating a user account for after-hours SMS with each DBA's mobile number in the email field. 2) Setting up a notification schedule defining coverage windows for each of the three rotating DBAs - Person A from 5PM to 12AM daily, Person B from 12AM to 8AM daily, and Person C on Saturdays and Sundays from 8AM to 5PM. 3) Checking the notification status by viewing the schedule for the third week.

1 of 9
Downloaded 22 times
SMS notification setup for Standby/OnCall roster using EM12c Step1: Create a user for after-hours SMS SetupSecurity Administrators I have created user ORACLEDBA_SMS for this purpose: On E-mail address field, you need to enter each of the standby DBAs mobile number Step2:
Setting notification Schedule: i. Click Setup Notification My notification Schedule ii. Next page click on edit Schedule Definition iii. The default setting iv. Modify Schedule
I am going to set up for three dbas on rotation from next week: v. Click continue Step3: Setup Notification time with the standby dba Select Start Time, End Time, Days of week, Weeks then select E-mail-address for the stadndby person. Time selection is for the same day. Therefore I divided as below format for Standby roster: A. Everyday 5PM-12AM B. Everyday 12AM-8AM C. Saturday/Sunday 8AM-5PM A.Everyday 5PM-12AM press Batch Fill-in button after email selection.Make sure view week1.
Click finish button. B.Everyday 12AM-8AM Click Edit Schedule Definition again
Click Continue Click Finish button C.Saturday/Sunday 8AM-5PM Click Edit Schedule Definition again
Click finish button Step 4: Now for 2nd Week for Second standby DBA [Same as Step 3]
Step 5: Now for 3rd week for third standby DBA (Myself) [Same as Step 3]
Click Finish button; then Edit Schedule definition Edit Existing Schedule Click Finish button; then Edit Schedule definition Edit Existing Schedule
Step6: Check the notification status Click Setup Notification My notification Schedule Next page: I select 3rd week and press Go button

More Related Content

SMS notification setup using EM12c

  • 1. SMS notification setup for Standby/OnCall roster using EM12c Step1: Create a user for after-hours SMS SetupSecurity Administrators I have created user ORACLEDBA_SMS for this purpose: On E-mail address field, you need to enter each of the standby DBAs mobile number Step2:
  • 2. Setting notification Schedule: i. Click Setup Notification My notification Schedule ii. Next page click on edit Schedule Definition iii. The default setting iv. Modify Schedule
  • 3. I am going to set up for three dbas on rotation from next week: v. Click continue Step3: Setup Notification time with the standby dba Select Start Time, End Time, Days of week, Weeks then select E-mail-address for the stadndby person. Time selection is for the same day. Therefore I divided as below format for Standby roster: A. Everyday 5PM-12AM B. Everyday 12AM-8AM C. Saturday/Sunday 8AM-5PM A.Everyday 5PM-12AM press Batch Fill-in button after email selection.Make sure view week1.
  • 4. Click finish button. B.Everyday 12AM-8AM Click Edit Schedule Definition again
  • 5. Click Continue Click Finish button C.Saturday/Sunday 8AM-5PM Click Edit Schedule Definition again
  • 6. Click finish button Step 4: Now for 2nd Week for Second standby DBA [Same as Step 3]
  • 7. Step 5: Now for 3rd week for third standby DBA (Myself) [Same as Step 3]
  • 8. Click Finish button; then Edit Schedule definition Edit Existing Schedule Click Finish button; then Edit Schedule definition Edit Existing Schedule
  • 9. Step6: Check the notification status Click Setup Notification My notification Schedule Next page: I select 3rd week and press Go button