Database Machine (EXADATA) Schematic problem in OEM12c

When adding an Exadata to Oracle Enterprise Manager 12c (OEM), it is pretty easy yet at times you may run into a problem or two.  Many of these problems can be minimized by using the Oracle Enterprise Manager 12c: Exadata Discovery Cookbook (cookbook).  The cookbook can be found here, so you don’t have to search to far for it.

As with adding any target in OEM, you add the Exadata the same way (Setup –> Add Target –> Add Targets Manually).  I’m not going to go into details here on adding the Exadata target because it is covered in the cookbook and it is also a basic function of OEM.   Just keep in mind, that adding an Exadata, you will need the databasemachine.xml or the catalog.xml file.  With the Exadata’s I’ve been adding, I have been using the databasemachine.xml.

What I do want to go over, is when you add an Exadata and the schematic of the Exadata box does not appear in OEM.  In figure 1, you see that I have two Exadata boxes listed on the Oracle Exadata Database Machines page. 

Figure 1: Oracle Exadata Database Machines

image

One of these Exadata, was added to OEM without a problem; the other the schematic didn’t come up.  Just to make this a bit easier, the top database machine is the one that is missing the schematic.  Figure 2, shows what I’m referring to about missing the schematic.  What shows up is only the legend, but no graphic for the machine itself.

Figure 2: Missing schematic

image

So, the question has to be asked, Why did this happen? Everything was configured correctly!  Well, I was so puzzled by this, I had to ask Oracle for a bit of help.  What we (myself and Oracle) identified was that the databasemachine.xml file had a duplicate entry in it. 

Fixing the databasemachine.xml file is explained in a bit.  First, you need to remove the database machine that is having the problem from OEM.  This can be done from the Database Machine menu (Figure 3). 

Figure 3: Database Machine menu

image

After clicking the Remove Target… option, you are taken to a page that provides options for removing the Exadat from OEM (Figure 4).   To remove the whole Exadata, the default radio button is fine.  Just make sure you select the option to Unsubscribe SNMP Subscriptions. Once you check the box, make sure all the passwords are correct.   Then click the Yes button in the right-hand corner.

Figure 4: Remove Database Machine

image

When the Exadata is removed, OEM will drop you back into the All Targets page.  At this point, the Exadata has been removed from OEM.

Now, you are back to a clean slate for adding the Exadata to OEM.  Before you rush to re-add the machine, we need to take a look at the databasemachine.xml file.  What you are looking for is any possible duplicates in the file.

Note: The EMOMS.log file on the OEM server helps in resolving this issue.

In reviewing the EMOMS.log, you will want to search for any interactions between OEM on the name of your Exadata.  In searching the EMOMS.log you may find an Oracle error, in my case the error was ORA-00001.  OEM couldn’t add a record to the EM_DBM_RACK_COMPONENTS table due to a PK error (Listing 1).

Listing 1: PK Error in EMOMS.log

ERROR model.DbmDiscovery logp.251 – ORA-00001: unique constraint (SYSMAN.EM_DBM_RACK_COMPONENTS_PK) violated

Knowing that there is a primary key error in the EM_DBM_RACK_COMPONETS table, this should lead you to think that the problem is in the databasemachine.xml file.   The databasemachine.xml file can be edited with any text editor; the file is an XML file.  A simple search for each of the values in the <ADMINNAME>.  Listing 2, shows you what I found in the databasemachine.xml file I’m working with.

Listing 2: Duplicates in databasemachine.xml

   <ITEM ID=”1″>

        <TYPE>ib</TYPE>

        <ADMINNAME>sw-ib1</ADMINNAME>

         <ADMINIP>10.*.*.*</ADMINIP>

         <ULOCATION>1</ULOCATION>

         <UHEIGHT>1</UHEIGHT>

    </ITEM>

    <ITEM ID=”13″>

        <TYPE>ib</TYPE>

        <ADMINNAME>sw-ib1</ADMINNAME>

        <ADMINIP>10.*.*.*</ADMINIP>

         <ULOCATION>20</ULOCATION>

         <UHEIGHT>1</UHEIGHT>

    </ITEM>

One of these entries in the databasemachine.xml file has to go; however, do not remove the whole <ITEM_ID></ITEM_ID>.  Just remove the name from the <ADMINNAME></ADMINNAME> in the second entry.  In this example, it would be <ITEM_ID=13> is the duplicate and I removed the name from the <ADMINNAME> tags.

After editing the databasemachine.xml file,  copy it to all the nodes within the Exadata.  This way you make sure that all the machines have the same file.  To do this,  use SCP (Listing 3).

Listing 3: SCP to copy to other compute nodes

scp ./databasemachine.xml root@db02:/opt/oracle.SupportTools/onecommand

Now, with the databasemachine.xml file in place, you can try and re-add the Exadata to OEM.  Again, keep in mind the easiest way to add the Exadata is to follow the cookbook (here).  That way you make sure all the points are covered.

Once you rediscover the Exadata in OEM, you should be able to pull the Database Machine Schematic up correctly (Figure 5). 

Figure 5: The correct view of Database Machine Schematic

image

Now, that the Exadata has been imported into OEM successfully, you can now add all the associated targets that are running on the Exadata (ie, database, ASM, listener, etc..). 

Enjoy!

twitter: @dbasolved

blog: http://dbasolved.com

Please follow and like:
Comments
  • If some one wants expert view concerning blogging then i
    recommend him/her to pay a quick visit this webpage, Keep up the pleasant job.

    Also visit my site – vpn

  • While this may really feel overwhelming, viewing it as an opportunity to build sturdy ties along with his family can flip it right into a constructive expertise. A large number of ukrainian women have rigorous ties for their households, and they’ll love a man so, who treats their specific members of the family with dignity. Ukrainian males are typically very near their households, and their kinfolk might be extra involved in your relationship than you’re used to. Trust is every little thing in a long-distance relationship. No relationship is with out its bumps, and cultural variations can add complexity. It’s necessary to remain assured in your relationship and address any issues or judgments collectively. It’s a gentle method to appreciate every other’s bodily presence and appearance. Simply give attention to capturing each other’s essence reasonably than perfection. Over time, you’ll both enhance your communication, and utilizing translation tools or studying some primary phrases in each other’s languages might help bridge the hole.

    Most Ukrainian ladies have heard English curse phrases and can probably perceive them even without translation. Even when you’re at a loss of words or say one thing embarrassing or not can’t say something eloquent, do not worry! And it is best to look how the lady reacts to what you say. Searching for a classy Ukranian or Russian lady? ” in Russian. It can present your Ukrainian lady you are ready to find out about her tradition. Nevertheless, must you need to make a Ukrainian single appreciate you for you, then ensure to recollect this essential Ukrainian dating tradition. Ukraine, nothing lasts forever, relationship love modifications ukrainian time and courting even disappear if partners are not concerned about sustaining it. And if there’s a language barrier, be affected person-it’s all part of the enjoyable, and you’ll get better at understanding each other over time. Have a look at her body language. CharmingDate Ukrainian single ladies are engaged in sports activities activities, they commonly go to gym with a purpose to look beautiful, be match, wholesome. There are actually extra women completely Ukraine than males. You’ll notice him engaging in additional meaningful conversations, asking about your ideas, desires, and opinions.

    Over time, you’ll be able to find the right match for yourself. Authentic connections develop over time, and sincere feelings are expressed naturally, not pressured or exaggerated. Awkward silences can punctuate your conversations when you find yourself talking to a shy man. So, you’re relationship a Ukrainian guy on-line? Fret not, this Ukrainian dating site is here to help! 1 Make buddies with Ukrainian hot ladies on Ukraine relationship site. If you’d like to achieve an efficient Ukrainian dating expertise, it is important to start out a seek for a perfect match on a legitimate Ukrainian dating site. To start out your seek for a perfect match, be part of JollyRomance now. If working exhausting can clear up all issues in this world, then we shouldn’t have any problems now. You possibly can specify the choices you want comparable to; occupation, training, habits, youngsters, and plenty of other issues of curiosity to you, after which the system may choose a listing of supreme candidates for you. To really get someone to talk to you on-line, that you must have a profile that’s interesting enough for ladies to ping you. They are literate sufficient to help virtually each matter you might rise through the dialog. If you’re used to a extra fashionable or egalitarian method to relationships, this might take some adjustment.

    Ukrainian males and American men, for example, often method relationships, gender roles, and family life in distinct ways due to their cultural backgrounds. In Ukraine, it’s frequent for males to take on financial obligations, which could differ from your standard method. It’s an awesome idea to make an effort to learn Ukrainian girls’ terminology because they value contact. Firstly, you’d better make eye contact & hold it! However, most communication instruments you want to contact women successfully are usually accessible on a paid foundation. Because Ukrainian girls were introduced up in households with onerous-working mother and father, chances are high, not every emotional need was met. Ukraine stunning girls are ready to move abroad and create a healthy household with their significant others. Family dynamics within the U.S. Family performs a central position in Ukrainian tradition, and this may be each a blessing and a challenge. You’re relationship someone from a special culture, so there are certain to be some differences in the way you see things.

Leave a Reply

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

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.