Mike Hickey
Has anyone setup Oracle Enterprise Manager alerts to go to Xmatters? I know how to setup the Oracle Side, but I would like to take those alerts, and have them e-mailed to Xmatters, and create an on-call rotation within Xmatters to forward to the DBA on Call.
0
Comments
Please sign in to leave a comment.
Hey Mike!
Would Oracle Enterprise Manager have anything to do with Oracle APEX? We did it for a POC, I can see about putting it up on xMatters Labs.
If it's something different, then disregard. We do have an inbound email integration, but if at all possible the REST API through an inbound integration will be easier to work with. Typically it would be a webhook or something and we can format the notifications better to the users.
I'll see if I can track down something on the Oracle side.
Happy Tuesday!
--- Travis
Travis,
Below is a copy of an e-mail example that we get from Oracle Enterprise Manager. Enterprise manager monitors all of the database installs we have. When there is an issue, it send an e-mail to an alias setup within Enterprise Manager. I would like to take that mail, put it into a form in Xmatters, then have Xmatters page the on-call person. I am really confused on how to do this. Looking at the Documentaion, I see Integration Builder, Communiations Plans, forms and message templates. Just trying to figure out how to put all of this together.
Thanks!
Mike
Host=chrcnc-vap-db-02.chrcnc.twc.net
Target type=Host
Target name=chrcnc-vap-db-02.chrcnc.twc.net
Incident creation time=May 8, 2018 4:19:58 PM GMT
Last updated time=May 8, 2018 4:19:58 PM GMT
Message=Filesystem /db/arch01 has 4.08% available space, fallen below warning (20) or critical (5) threshold.
Severity=Critical
Incident ID=10077
Event count=1
Incident Status=New
Escalated=No
Priority=None
Incident owner=
Incident Acknowledged By Owner=No
Categories=Capacity
Rule Name=Critical Notifications,Critical Notifications Rule
Rule Owner=SYSMAN
Update Details:
Incident created by rule (Name = Incident management rule set for all targets, Create incident for critical metric alerts [System generated rule]).
Ah, I see.
I wrote up a "Getting Integrated Guide" on this very subject, check it out here. To help with the terminology, a Comm Plan is sort of like a folder where all the "stuff" is stored. A Form you can think of as a template for an event, it holds the name value pairs and "data" of an event as well as the notification templates (email, sms, voice, mobile, etc) and is also where you will configure the inbound email integration. Part 2 of that series has some details on how to get started with Comm Plans and forms.
Once you have the Comm Plan and Form set up, then the form will be the "domain" part of the email and the recipient (a user or a group) will be, er, the recipient of the email. So if your group is called "MyOnCallOracleGroup" and the "domain" part is "oracleenterprise.acme.xmatters.com", then in Oracle Enterprise Manager, you would enter the email address MyOnCallOracleGroup@oracleenterprise.acme.xmatters.com and all events that come into that address would be routed to "MyOnCallOracleGroup". Note that emails don't do well with spaces in the name, so you might need to play with the group name, or as noted in the article, put the group inside another group with a space safe name.
I hope that helps? Feel fee to post back if you have any troubles or questions.
Happy Wednesday!
--- Travis