DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!

Administration Group Creation Failure in EM12c

Sometimes you want to change the way you are managing, monitoring or notifying in your EM12c environment that may require you to delete and recreate you administration groups.  If you are testing out administration groups, then you may very likely create, delete and recreate, as they are not something you can edit as you go along, (the system even warns you of this as you create them.

As I was working through a unique notification issue and how to handle it with administartion groups, I experienced a failure on creation after the deletion of a former admin group in EM12c, BP1:

As the previous admin group had been deleted and this failed, it was obvious that something hadn’t cleaned up properly after the previous admin group.  I’m not a fan of tearing into the SYSMAN schema, but this one was worth a look at not much was connected to it to begin with.

The error gave us a clear indicator of what we needed to look into:

We now knew what column and the table this came from.  How much data was contained in this table?

As there was only one row and it only contained the group hierarchy row info, I made a copy of the table, deleted the row, then committed it.

Can I now create my administration group?

Success.  I removed the copy of the table and proceeded to create the new monitoring templates for the groups.

Knowing the data behind the scenes, still making a copy of it, “just in case” is important when you are required to do a quick fix so toproceed forward when a job to clean up something like an administration group hasn’t cleaned up as much as it should have.

Print Friendly

facebook comments:

2 thoughts on “Administration Group Creation Failure in EM12c
  • Rahul says:

    Hi Kevlar,

    I am from Oracle and trying to understand this issue.
    Did you see any Admin Group creation failure before hitting this unique constraint violation issue. If yes, then we have already fixed this issue in 12.1.0.2 release.

    Thanks & Regards
    Rahul

  • dbakevlar says:

    Hello Rahul,
    Your comment has me responding as I might to an Oracle Support Service Request that asks questions that, if one looked, are already answered in the data posted previously by the submitter:
    1. Yes, if you look at the screen shot or read through the post, it states, “I experienced a failure on creation” .
    2. It is stated in the post that this issue did occur in the earlier version and although I’m very happy to hear that it’s solved in the new release, for anyone receiving this error, here is how to fix it.

    Thanks and Regards,
    Kellyn

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  • Facebook
  • Google+
  • LinkedIn
  • Twitter