This discussion is archived
6 Replies Latest reply: Oct 8, 2012 9:20 AM by user12613373 RSS

Extracting Data from OEM

user12613373 Newbie
Currently Being Moderated
Is there an easy to use API for extracting client data from OEM? We really like how OEM collects system information, health/performance metrics, etc. We'd like to use this data in our own in-house health monitoring software.

For example, using alerts generated by the OEM agent in our own home-grown alert management software, using the health metrics provided by the system monitoring plugin to create our own alerts, etc.
  • 1. Re: Extracting Data from OEM
    Loc Nhan Expert
    Currently Being Moderated
    Have a look at the repository views, especially the Events views and Monitoring views, documented in the Cloud Control Extensibility Programmer's Reference guide to see if they meet your requirements.

    http://docs.oracle.com/cd/E24628_01/doc.121/e25161/views.htm#sthref1295

    Regards,
    - Loc
  • 2. Re: Extracting Data from OEM
    Johan Louwers Explorer
    Currently Being Moderated
    As all data is stored in the database you could write some code to get it out and into your own software. However, what intrigues me is what functionality is it that you are missing in OEM and that your in-house health monitoring software will provide you?

    I guess this is a self build system? You can extend OEM, so are you also considering to expand OEM instead of moving data from OEM to your own application?

    If you check the URL below,.... if you build a cool extension on OEM you could even promote it to be marketed by Oracle.
    http://www.oracle.com/goto/emextensibility



    Regards,
    Johan Louwers

    Edited by: Johan Louwers on Oct 3, 2012 4:56 PM
  • 3. Re: Extracting Data from OEM
    user12613373 Newbie
    Currently Being Moderated
    Thanks Loc, I will take a look at this to see if we can extract the data that way.
  • 4. Re: Extracting Data from OEM
    user12613373 Newbie
    Currently Being Moderated
    Hi Johan,

    I think our biggest concern is how cumbersome the system is when it comes to doing anything and our fear of being locked into something so complex and difficult to manage.

    For example, last year we installed version 11 to evaluate. This year, we decided to evaluate 12c. Uninstalling 11 was virtually impossible using the 10 different methods we found online, so we were stuck with manually removing files, processes, and database stuff. It was horrible. We eventually re-installed the operating system on our OEM test server and OEM clients and tediously removed every single account/table in the database by hand.

    Then, after installing 12cR1, we found out that we couldn't install agents of a different OS type/machine architecture without something called Bundle Patch 1. The first thing the installation instructions say for this bundle patch? "Uninstall and reinstall OEM if you can". Once again, uninstalling OEM 12cr1 was a tedious process requiring hours/days of figuring out where OEM had its "tentacles" and manually removing it all. Then, we installed BP1. At least, we think we did. There was no indication from the UI or install instructions that we were actually installing the BP1 version. The agent issue was still there, by the way.

    Did I mention we did this 1 day before 12cR2 came out? Thankfully, we were able to upgrade from 12cR1 (12cR1 BP1 or whatever version it was) to 12cR2 fairly easily and then cross OS type/machine architecture problem went away.

    Now imagine if we had 12cR1 in a production environment and didn't have the luxury of reinstalling? This whole process has scarred our team and makes us even more wary to invest ourselves in a complete OEM solution...
  • 5. Re: Extracting Data from OEM
    sxkumar Explorer
    Currently Being Moderated
    The fact that you R2 upgrade was relatively easier and that your cross platform issues went away is no accident. We, in EM development team, are constantly trying to improve the product and the improvements you saw were direct result of that. We thank you for your feedback.

    Do you have any SR opened for the uninstall issues with R1? If you do, please let us know the SR number and we will take a look.
  • 6. Re: Extracting Data from OEM
    user12613373 Newbie
    Currently Being Moderated
    Unfortunately, I didn't open up any SR on the uninstall issue because I just didn't have the time. I will do my best to do so in the future though, as I want OEM to be our data center monitoring solution...a lot less home-grown code for me to write!

    Thank you for making the R2 upgrade process painless. It really was a refreshing change to have something "just work".

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points