Oracle Enterprise Manager Alerts to Xmatters

Not Yet Reviewed

 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

3 comments
Date Votes

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

    0
  • 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]).

    0
  • 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

    0

Didn't find what you were looking for?

New post