Book Review: Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c

Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c I try to read and review all books about Enterprise Manager Cloud Control 12c (EM12c). The last one I read is, “Managing IaaS and DBaaS Clouds with Oracle Enterprise Manager Cloud Control 12c”. As you can understand from the name, the book focuses mainly on how you can build and manage IaaS and DBaaS using EM12c and it is about only 110 pages. The author, Ved Antani works as Technical Director with Electronic Arts. While reading the book, you may feel that all topics are approached with a perspective of a software developer not by a system (database) administrator.

List of chapters:

  1. Setting Up Enterprise Manager: As expected, the book starts with the installation chapter about EM12c but unexpectedly, it doesn’t cover how to set up EM12c step by step. It doesn’t give any details, only covers the concepts.
  2. Infrastructure as a Service: One of the best chapters of the book, it covers almost all topics about registering and using Oracle VM Manager, but still lack of some information such as installing required plugins.
  3. Database as a Service: In this chapter, the author explains how to build a DBaaS. The topics are organized to build any PaaS. It includes registering/creating storage servers, and give some information about chargeback system
  4. Enterprise Monitoring: This chapter covers the topics to build an automated monitoring system using Oracle Enterprise Manager. Incident handling is also mentioned in this chapter.
  5. Cloud APIs: Most interesting and promising chapter is surely “cloud APIs”, but unfortunately this chapter doesn’t go into details but just give some sample RESTful calls and JSON results.

How to Add RAC Databases to Enterprise Manager Cloud Control 12c

It’s been asked several times to me how to add RAC (Clustered Databases) to Enterprise Manager 12c. Finally I found time to get screenshots and prepare a step-by-step guide. The interesting point about adding Clustered Databases is, when you try to discover (and add) a cluster databases like you do a stand-alone database, EM12c does not show you an error but the process doesn’t complete. It makes users to feel like there’s a bug. In fact, it’s just because user miss a required step.

So how to add a RAC Database? First of all, we need to deploy agents to all nodes. you can find related document on my blog. After you deployed agents to all nodes, we’ll add “Oracle Cluster and High Avaliablity Service”.

Add Cluster Target

Enterprise Manager 12c Host Availability Page (Status History)

Some servers were unreachable today, fortunately they were all monitored by Oracle Enterprise Manager 12c, so I see them on the summary page and contacted the related sysadmin staff to fix the problems. I’ve not set up notification mails yet (this is a new implementation), so I didn’t get emails when the servers are down. I wondered when they shutdown and check one of the servers “Availability” page (while it’s down).

hostdown1

Oracle Partner Events: 12c Roadshow And Delivering DBaaS

Oracle Database 12c Partner Roadshow

On November 5th and 6th, I attended to Oracle Database 12c Partner Roadshow in Istanbul. During this 2-day partner-only (and free) briefing, François Pons from Oracle Server Technologies, gave detailed technical information about new features of Oracle 12c to Oracle partners in Turkey. Although it was not a workshop, Mr. Pons provided live demos and gave detailed answers to all questions. I can say that, all attendees were very pleased.

me, 12c-man and François Pons The training started with the Oracle Multitenant architecture. As I remember, Heat Map, Automatic Data Optimization, Partitioning Enhancements, Temporal Validity, new ASM Functionality (Flex ASM, Flex Clusters etc), new RAC Functionality, Application Continuity and Optimizer Enhancements are mentioned in great detail. Presentation were very well prepared and live demos strengthen the content. I’m specially happy to hear more about new ASM functionality and Application Continuity.

There will be another event for Oracle partners in Istanbul on November 14th-15th. It’ll be a 2-day workshop on “Architecting Oracle Private Database Cloud & Delivering Database-As-A-Service (DBaaS)”. The workshop’s main focus is service delivery and how to transform current IT infrastructure to a service delivery mode. Of course, Enterprise Manager Cloud Control and Engineered Systems will be the stars of the show!

You may find more information about the DBaaS workshop on Oracle blog.

Enterprise Manager 12c: AdminServer Could Not Be Started

I got an error when trying to start Oracle Enterprise Manager Cloud Control 12c. It says AdminServer couldn’t be started:

When I examined the EMGC_ADMINSERVER.out file, I see that “<BEA-141281> <unable to get file lock, will retry …> weblogic.management.ManagementException: Unable to obtain lock” message. As you know, Enterprise Manager Cloud Control uses Weblogic. Weblogic uses “lock” (*.lok) files to prevent a server to run multiple times. I checked if EMGC_ADMINSERVER is running: