Using Enterprise Manager to manage cloud services

Yesterday we talked about the virtues of Enterprise Manager. To honest the type of monitoring tool is not important but the fact that you have one is. One of the virtues that VMWare touts of VSphere is that you can manage instances on your server as well as instances in VCloud. This is something worthy of playing with. The same tool for your on premise instances also managing your instances in the cloud has power. Unfortunately, VCloud allows you to allocate virtual machines and storage associated with it so you only have a IaaS option of compute only. You can’t allocate just storage. You can’t deploy a database server unless you have a database deployed that you want to clone. You need to start with an operating system and build from there. There are benefits of PaaS and SaaS that you will never see in the VCloud implementation.

Oracle Enterprise Manager provides the same universal management interface for on premise and in cloud services. Amazon falls short on this. First, they don’t have on premise instances so the tools that they have don’t monitor anything in your data center, only in their cloud. Microsoft has tools for monitoring services plugins for looking at Azure services. It is important to note that you need a gateway server in the Azure cloud to aggregate the data and ship the telemetry data back and report it in the monitoring tool. There is a good Blog detailing the cost if IaaS monitoring in Azure. The blog points out that the outbound data transfer for monitoring can cost up to $17/month/server so this is not something that comes for free.

Today we are going to look at using Enterprise Manager as a management tool for on premise systems, the Oracle Public Cloud, Amazon AWS, and Microsoft Azure. We are going to cheat a little and use a VirtualBox instance of Enterprise Manager 13c. We are not going to go through the installation process. The books and blogs that we referenced yesterday detail how to do this. Unfortunately, the VirtualBox instance is available from We are not going to use this instance but are going to use an instance for demo purposes only available internal to Oracle. The key difference between the two systems is that the edelivery instance is 21 GB in size for download and expands to provide an OEM 13c instance for testing while the internal system ( has a 12c and 11g database installed and is 39.5 GB (expanded to almost 90 GB when uncompressed). Given the size of the instance I really can’t provide external access to this instance. You can recreate this by downloading the edelivery system, installing an 11g database instance, installing a 12c database instance, and configuring OEM to include data from those instances to replicate the screen shots that we are including.

If we look at the details on the virtual box instance we notice that we need at least 2 cores and 10 GB of memory to run this instance. The system is unusable at 8 GB of RAM. We really should bump this up to 12 GB of RAM but given that it is for demo purposes and for training it is ok if it runs a little slow. If we were running this in production it is recommended to grow this to 4 cores and 16 GB of memory and also recommended that you not use a downloaded VirtualBox instance for production but install from scratch.

The key things that we are going to do are walk through what it takes to add a monitoring agent onto the service that we are trying to monitor and manage. If we look at the architecture of Enterprise Manager we notice that there are three key components; the Oracle Management Repository (OMR), the Oracle Management Service (OMS), and the Oracle Management Agent (OMA). The OMR is basically a database that keeps a history of all telemetry actions as well as reports and analytics for the systems being monitored. The OMS is the heart of Enterprise Manager and runs on a WebLogic server. The code is written in Java and presents the primary user interface to the administrators as well as being the gateway between the OMR and the agents or OMAs. The agents are installed on the target systems and collect operating system data, database data, weblogic data, and all other log data to ship back to the OMR for analysis by the users.

It is important to note at this point that most PaaS and SaaS providers do not allow you to install an Enterprise Manager Agent or any other management agent on their instances. They want to manage the services for you and force you to use their tools to manage their instance. SalesForce, for example, only gives you access to your customer relationship data. You can export your contact lists to an csv file to backup your data but you can’t correlate the contact list to the documents that you have shared with these users. Amazon RDS does not provide a file system access, system access to the database, or access to the operating system so that you can install the management agent. You must use their tools to monitor services provided on their sites. Unfortunately, this inhibits you from looking at important things like workload repository reports or sql tuning guides to see if something is running slow or waiting on a lock. Your only choice is to deploy the desired PaaS or SaaS as a manual or bundled install on IaaS forcing you to manually manage things like backups and patching on your own.

The first thing that we need to do in Enterprise Manager is to log in and click on the Setup button on the top right. We need to define named credentials since we are going to connect to the cloud service using public and private ssh keys. We need to follow the Security pull down to Named Credentials.

We click on the Create icon in the top left and add credentials with public and private keys. If we don’t have an ssh key to access the service we can generate an ssh key using ssh-keygen which generates a public and private key and upload the key using the SSH Access pull down in the hamburger menu. Once we upload the ssh key we can use ssh -i keyname.ppk opc@ip_address for our database server. We will use this keyname.ppk to connect with Enterprise Manager and have all telemetry traffic transferred via the ssh protocol.

Once we have the credentials valid in the cloud account we can create the ssh access through Enterprise Manager. To do this we to to Setup at the top right, Security, Named Credentials. We then click on the Create button in the middle left to start entering data about the credentials. The name in the the screen shot below failed because it begins with a number so we switched it to ssh2017 since 2017ssh failed the naming convention. We are trying to use host access via ssh which is done with pull down menu definitions. The system defaults to a host access but we need to change from host to global which does not tie our credentials to one ip address. We upload our public and private key as well as associate this with the opc user since that user has sudo rights. We can verify the credentials by looking at the bottom of the list. This should allow us to access our cloud host via ssh and deploy an agent to our cloud target.

Note that we created two credentials because we had a step fail later. We created credentials for the opc user and for the oracle user. The opc credentials are called ssh2017 as shown in the screen shots. The oracle credentials are called oracle2017 and are not shown. The same steps are used just the username is changed as well as the name of the credentials.

If we want to install the management agent onto our instance we need to know the ip address of the service that we are going to monitor as well as an account that can sudo to root or run elevated admin services. We go to the Enterprise Manager splash screen, login, select the Setup button in the top right and drill down to Add Target and Add Target Manually. This takes us to the Add Target screen where we can Install Agent on Host. To get rid of the warnings, we added our cloud target ip address to the /etc/hosts file and used a fully qualified and short name associated with the ip address. We probably did not add the right external dns name but it works with Enterprise Manager. When we add the host we use the fully qualified host name. We can find this by logging into the cloud target and looking at the /etc/hosts file on that server. This gives us the local ip address and a fully qualified host name. Once we have this we can enter a directory to upload the agent software to. We had to create an agent directory under the /u01/app/oracle directory. We select the oracle2017 credentials (the screen shots use ssh2017 but this generates an error later) we defined in the previous step and start uploading the agent software and configuring the host as a target.

Note that we could have entered the ip address rather than going through adding the ip address to /etc/hosts. We would have received a warning with the ip address.

When we first tried this we got an error during the initialization phase that opc did not own the /u01/app/oracle directory and had to create an agent directory and change ownership. Fortunately, we could easily resubmit and enter a new directory without having to reenter all of the other information. The deployment takes a while because Enterprise Manager needs to upload the agent binaries, extract, and install them. The process is updated with status so that you can see the progress and restart when errors happen. When we changed the ownership, the installation failed at a later step stating the opc did not have permission to add the agent to the inventory. We corrected this by installing as oracle and setting the /u01/app/oracle/agent directory to be owned by oracle.

When we commit the ip address or host name as well as the ssh credentials, we can track progress as the management server deploys the agent. We get to a point where we note that the oracle user does not have ssh capabilities and we will need to run some stuff manually from the opc account.

At this point we should have an enterprise manager connection to a cloud host. To get this working from my VirtualBox behind my AT&T Uverse wireless router I first had to configure a route on my broadband connection and set the ip address of the Enterprise Manager VirtualBox image to a static ip address. This allows the cloud instance to talk back to the OMS and store data in the OMR.

The next step is to discover the database instances. This is done by going through a guided discovery on the host that we just provisioned. It took a few minutes to sync up with the OMS but we could verify this with the emctl status agent command on the target host. We add the target manually using the guided discovery and select database services to look for on the target.

At this point we should have a database, listener, and host connected to our single pane of management glass. We should see a local database (em12c) and a cloud based database (prs12cHP). We can look at the host characteristics as well as dive into sql monitoring, database performance, and database management like backup and restore options or adding users to the repository. We could add a Java Cloud Service as well as link these two systems together and trace a web page request down to a sql read and look at what the longest latency component is. We can figure out if the network, java memory allocation, or databse disk is causing the slowest response. We can also look at sql tuning recommendations to get suggestions on changing our sql code or execution plans using the arw report and sql tuning utilities in Enterprise Manager.

In summary, we can connect to an on premise server as well as a cloud server. We can’t connect to an Amazon RDS instance because we don’t get file system level access to push a client to or a root user to change the agent permissions. We do get this with IaaS on Oracle, Compute servers on Azure, and EC2 on Amazon. We also get this with PaaS on Oracle and potentially event from SalesForce. No one give you this ability with SaaS. It is assumed that you will take the SaaS solution as is and not need to look under the covers. Having a single pane of glass for monitoring and provisioning services is important. The tool should do more than tell you how full a disk is or how much of a cpu is loaded or available. It should dive into the application and let you look at where bottlenecks are and help troubleshoot issues. We could spend weeks diving into Enterprise Manager and the different management packs but we are on a journey to look at PaaS options from Amazon, Microsoft, and Oracle.

346 thoughts on “Using Enterprise Manager to manage cloud services”

  1. hello!,I like your writing so much! share we communicate more about your post on AOL? I require an expert on this area to solve my problem. Maybe that’s you! Looking forward to see you.

  2. Today, with all the fast life-style that everyone is having, credit cards have a huge demand throughout the market. Persons out of every area of life are using credit card and people who not using the credit card have arranged to apply for one. Thanks for spreading your ideas about credit cards.

  3. I just wanted to type a simple remark to appreciate you for these precious secrets you are showing here. My rather long internet lookup has at the end of the day been honored with professional suggestions to write about with my friends and family. I would say that we site visitors are undoubtedly endowed to live in a great website with so many outstanding individuals with helpful techniques. I feel very much happy to have discovered your webpages and look forward to plenty of more awesome times reading here. Thank you once again for a lot of things.

  4. Thank you so much for providing individuals with an exceptionally terrific possiblity to read critical reviews from this web site. It is often very enjoyable and stuffed with amusement for me and my office acquaintances to search the blog a minimum of thrice weekly to find out the latest items you have. And definitely, we’re always motivated concerning the dazzling things you serve. Selected 1 points on this page are unquestionably the best I’ve ever had.

  5. I just wanted to type a small message so as to say thanks to you for all of the remarkable solutions you are giving on this site. My time consuming internet investigation has at the end of the day been paid with brilliant know-how to go over with my visitors. I would admit that we site visitors are quite fortunate to dwell in a fantastic place with many outstanding people with useful hints. I feel very much blessed to have come across your entire weblog and look forward to plenty of more brilliant minutes reading here. Thanks once again for everything.

  6. I wish to show appreciation to you just for bailing me out of such a challenge. Just after surfing throughout the internet and obtaining views which are not pleasant, I figured my entire life was gone. Living devoid of the answers to the difficulties you’ve resolved by way of your entire article is a critical case, and ones that might have in a wrong way affected my career if I had not encountered the website. Your own personal natural talent and kindness in taking care of all the details was helpful. I’m not sure what I would have done if I had not come upon such a stuff like this. I’m able to at this point look ahead to my future. Thank you very much for this professional and result oriented help. I won’t think twice to endorse your blog to any person who ought to have assistance about this issue.

  7. Thank you for all of your effort on this web site. Debby take interest in carrying out investigation and it is easy to understand why. My spouse and i notice all of the powerful means you present reliable tips via your website and even foster contribution from others on this subject matter so our princess is without question understanding a lot. Take advantage of the remaining portion of the new year. You’re carrying out a tremendous job.

  8. I as well as my friends appeared to be checking out the best techniques located on your web page and so instantly came up with a horrible feeling I never expressed respect to the blog owner for those tips. These guys came certainly warmed to see all of them and already have in actuality been taking pleasure in those things. Many thanks for being quite considerate as well as for settling on such magnificent resources millions of individuals are really eager to be informed on. Our own sincere apologies for not expressing gratitude to earlier.

  9. I’m also writing to let you know of the perfect discovery my girl had visiting your blog. She picked up several things, which included what it’s like to have a marvelous coaching heart to make many more clearly gain knowledge of a number of tricky subject matter. You undoubtedly exceeded my desires. Thanks for providing the great, trustworthy, informative as well as cool thoughts on this topic to Evelyn.

  10. My spouse and i got now thrilled that Albert managed to round up his web research with the ideas he received out of the weblog. It’s not at all simplistic to just possibly be releasing strategies which often most people may have been making money from. And we grasp we now have you to give thanks to because of that. All of the illustrations you have made, the simple blog navigation, the friendships you can make it easier to foster – it’s everything impressive, and it’s really aiding our son and the family recognize that the subject matter is brilliant, which is truly important. Many thanks for the whole lot!

  11. I wish to get across my affection for your generosity giving support to those individuals that absolutely need guidance on in this issue. Your very own dedication to getting the message throughout had been exceptionally good and have specifically empowered men and women just like me to realize their dreams. Your amazing warm and friendly useful information means a great deal a person like me and substantially more to my peers. Many thanks; from all of us.

  12. I intended to put you this little bit of word so as to thank you over again considering the gorgeous solutions you have documented at this time. It is simply remarkably open-handed with you to make unreservedly exactly what many of us would have sold for an e book to end up making some dough for themselves, especially given that you might well have done it if you ever considered necessary. Those techniques as well acted like the good way to fully grasp most people have similar fervor like my personal own to realize significantly more in regard to this condition. I am certain there are lots of more pleasant periods up front for individuals that check out your site.

  13. I as well as my friends ended up looking at the good techniques found on your website and suddenly came up with a terrible suspicion I had not expressed respect to the web site owner for those strategies. The people appeared to be totally excited to see them and now have in actuality been making the most of them. Appreciation for really being considerably accommodating and then for making a choice on varieties of very good themes millions of individuals are really eager to be aware of. My personal honest apologies for not expressing gratitude to earlier.

  14. I want to voice my passion for your kind-heartedness giving support to women who must have guidance on this particular concern. Your special commitment to getting the message all-around turned out to be surprisingly practical and has continuously made men and women much like me to realize their aims. Your personal informative advice entails this much a person like me and still more to my peers. Regards; from everyone of us.

  15. I have to get across my gratitude for your generosity supporting those individuals that must have guidance on your concern. Your very own dedication to passing the solution all through became surprisingly significant and has continually made individuals just like me to attain their goals. Your amazing invaluable information indicates a whole lot to me and extremely more to my colleagues. Thank you; from each one of us.

  16. Thanks for your whole work on this blog. My daughter really loves making time for research and it is easy to understand why. A number of us hear all of the powerful tactic you produce both interesting and useful guidance via the website and therefore foster participation from other people about this theme and our own girl is in fact becoming educated so much. Take advantage of the rest of the new year. You’re the one doing a pretty cool job.

  17. I happen to be commenting to let you understand of the useful experience my wife’s princess had viewing your web site. She came to find a wide variety of things, which include how it is like to have an awesome coaching mood to have other folks just master several problematic subject matter. You truly did more than visitors’ expectations. Many thanks for rendering the warm and helpful, dependable, explanatory not to mention cool tips about your topic to Kate.

  18. I’m just writing to let you be aware of of the nice encounter my friend’s daughter encountered going through your blog. She figured out a lot of details, including what it’s like to possess an incredible giving character to let other folks completely know just exactly several multifaceted issues. You undoubtedly surpassed readers’ expectations. Thanks for displaying these invaluable, trusted, revealing and as well as cool thoughts on this topic to Tanya.

  19. I have to point out my gratitude for your kindness for people that have the need for help with the idea. Your real dedication to getting the solution all around ended up being pretty productive and has without exception encouraged somebody just like me to arrive at their dreams. Your informative key points can mean this much to me and substantially more to my peers. Warm regards; from everyone of us.

  20. I simply wanted to appreciate you all over again. I do not know the things I would’ve achieved in the absence of the type of advice contributed by you directly on that industry. It had been a fearsome situation for me, but noticing your specialised mode you handled it made me to leap with fulfillment. Extremely thankful for the support as well as hope you really know what a powerful job that you’re undertaking educating some other people thru your web site. Probably you haven’t come across all of us.

  21. I definitely wanted to compose a quick remark so as to express gratitude to you for all the amazing points you are giving at this site. My time intensive internet look up has finally been rewarded with reasonable facts to go over with my two friends. I would admit that we website visitors actually are undeniably lucky to exist in a magnificent site with very many outstanding professionals with very beneficial tricks. I feel very lucky to have encountered your entire web site and look forward to plenty of more awesome minutes reading here. Thank you again for all the details.

Leave a Reply

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