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
  • A red Chinese bridal gown is a tradition that goes back thousands of years to a period when a partner often would certainly not fulfill their other half until the special day. Bumble likewise supplies networks to meet close friends or network with specialists in your sector, making it greater than simply a dating app. You ought to remember that it is needed to examine the water prior to making a deep dive. China dating websites have made it possible for love to bloom in the middle of the electronic age, making dating Chinese ladies an obtainable truth for several. If you are a user from Western countries and don’t recognize Chinese, you may not bother with the language barrier, given that all the contemporary sites are outfitted with excellent translation devices. Modern Chinese singles online are looking for love as well as want foreign guys. Chinese songs from backwoods are most likely to be more traditional concerning family values, while ladies from large cities tend to be self-reliant and independent. Chinese songs require a VPN to accessibility Tinder, as well as also then, it doesn’t work well. Scientists claim that the Northern Lights, or Aurora Borealis, are around all the time – also throughout the day. However, the nation choses to use a single basic time, which is known as Beijing Time in China.

    Temperature levels in Beijing can reach over 100 degrees, so a popsicle is a preferred selection for citizens and travelers in the city. These structures are made of timber, so the threat of fire is a consistent concern in Beijing. There are several shapes of Chinese knots, one of the most usual being butterflies, flowers, birds, dragons, fish, and also also footwear. That makes Mandarin chinese one of the most usual language spoken throughout the world. China is recognized to the Western world for having a questionable government. Begin and confirm your understanding extends far beyond the Western globe. Dragons obtain a poor rap in Western culture, yet they are seen much in a different way in China. In Western culture, people often seek to the Mediterranean region as the start of human background, a minimum of when it involves world. The reason the rat comes first according to the Chinese zodiac associates with a myth. Obviously, that comes as not a surprise considering it calls for using over 30 joints as well as 50 muscular tissues throughout the hand and also arm. They were initial cast by Emperor Wen in 581. After presenting these new coins, the Emperor bought all the frontiers to hand over 100 cash as samples in 583, as well as the following year purely prohibited the blood circulation of old coins and also commanded that when this was disobeyed, the liable authorities must be fined half a years salary.

    The rat was the initial to arrive after it tricked the ox into giving it a ride. The Terracotta Army makes the Mausoleum of the First Qin Emperor one of one of the most complicated burial tombs on the planet. The army is comprised of over 8,000 soldiers, all crafted with one-of-a-kind gestures to really bring these figures to life. Which party regulations over the nation? It was developed across a number of empires and also took control of 1,800 years to finish. The hill is situated within the Mountain range, which was developed when the Indian Plate clashed with the Eurasian Plate around 50 million years earlier. The culture in China is chnlove greatly influenced by institutions of idea associating with Buddhism, Confucianism and Taoism, in addition to the influx of Western ideas in the past few a century. We can go on and also on about cultural distinctions regarding this issue, however, for pete’s purpose, he wishes to date a western woman, so he births some obligation for learning the regulations. For Westerners, discovering to make use of chopsticks correctly is usually difficult. This rich, interesting background makes China a country worth finding out around.

    Though empires have actually risen and also dropped in the nation, that background has actually continued via the ages, specifying China as well as transforming it into the world power it is today. Virtually 1 billion people throughout the globe talk Mandarin, which is around 14 percent of the world’s population. Acknowledged as the globe’s biggest royal royal residence, there are nearly 9,000 rooms in the different buildings and also quarters throughout the Forbidden City. Join only trustworthy platforms that have positive reviews and also are in the general public eye. The nation’s national politics have actually been shaped by several empires and also a series of transformations at the beginning of the 20th century. Though it notes the Chinese New Year, the 15-day party is additionally referred to as the Spring Event in China since the chilliest days of wintertime have actually ended. Yet in truth, China has a history of civilized society that dates back as much, if nor additional, than that found in the West. History enthusiasts will go to the enormous Wenshu Holy place complex, integrated in the Flavor Dynasty to honour Manjusri Bodhisattava, the Wisdom Buddha. Doing so will certainly demonstrate your admiration for her culture and also background. Will you overcome it prior to it conquers you.

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.