Oracle Enterprise Manager Cloud Control 12c for Exalogic: Setting up Apps-to-Disk Monitoring

By Gagan Chawla

Exalogic is the logical choice for running Business Applications and provides an excellent consolidation platform hosting wide range of application workloads. It’s important to have a comprehensive Apps-to-Disk monitoring of Exalogic system enabled including monitoring of business applications, software and hardware components together from a single Oracle Enterprise Manager Cloud Control 12c console.

There are two Exalogic configuration flavors specifically in the way Exalogic is implemented 1) Virtualized or 2) Non-virtualized/physical configuration. More details on system configuration with each Exalogic release are described in this MOS note here.

In this blog post, we will cover important steps that are required to enable Oracle Enterprise Manager Cloud Control (CC) 12c as a centralized monitoring platform with Apps-to-Disk visibility for either configuration of Exalogic.

Setting up Oracle Enterprise Manager Cloud Control 12c for monitoring virtualized Exalogic stack 

• Setup your EM CC 12cR2 site with latest PSU if not already done. Refer to EM 12cR2  install/upgrade guide here
• Deploy EM CC 12cR2 agent on Exalogic Control Ops Center Enterprise Controller(EC) vServer
• Export Ops Center Enterprise Controller trust certificate and import it to Enterprise Manager Cloud Control Management Agent
• Ops Center Certificate should be imported to agent running on Ops Center Enterprise Controller.
• Steps to Export and import the certificate here 
  It's recommended to use emctl to import - emctl secure add_trust_cert_to_jks -trust_certs_loc $CERT_LOC/oc.crt -password welcome -alias
• Restart the agent after importing the certificate
• Deploy EM CC 12cR2 agent on OVM Manager(OVMM) vServer. Deploy Oracle Virtualization (VT) plug-in on OMS if not already done and on agent installed on OVM Manager vServer.
• Configure OVMM for read-only access [Mandatory]. Steps to configure OVMM for read-only access are here. If OVMM was registered with EM CC prior to performing this mandatory configuration then you must run synchronize operation from OVMM target menu in EM CC [Important]. Note – vDC operations are done via Exalogic Control that has embedded EM Ops Center pre-installed in the Exalogic system. Refer to Exalogic Administrator’s guide here
• Register OVMM in EM CC site by following EM CC Cloud Administrator’s guide here . It’s recommended to use the same EM CC 12cR2 agent deployed on the OVMM vServer during the OVMM registration process.
• Deploy and configure EM CC ZFS plug-in by referring to ZFS plug-in installation guide here. It’s recommended to use the agent deployed on Ops Center Enterprise Controller vServer for discovering ZFS Storage Appliance target.
• Deploy and configure EM CC Engineered System Healthchecks plug-in by referring to plug-In Installation Guide here. It’s recommended to use the agent deployed on Ops Center Enterprise Controller vServer for discovering Healthchecks target.
• Discover Exalogic system using Targets -> Systems UI and select deployment type ‘Virtual’ and use agent deployed on Exalogic Enterprise Controller for Exalogic targets discovery.
• Configure Exalogic Guest Base Template and Exalogic network by referring to following guide here and deploy agents on guest vServers
• FMW, Apps targets and Application stack should be discovered in EM CC. In case of Oracle Applications on Exalogic, it’s recommended to have respective Apps plug-ins (FA, EBS, PSFT, Siebel etc) deployed and configured. Refer to Applications Management pack collateral here.
  

EM CC Plug-Ins required in case of virtualized Exalogic configuration –

• Fusion Middleware (FMW) Plug-in [Default plug-in and deployed out-of-box] - enables overall Exalogic stack management. Exalogic monitoring for virtualized configuration was introduced in FMW 12.1.0.3 plug-in (EM 12cR2 release)
• Oracle Virtualization (VT) Plug-in – enables Virtual Targets monitoring integration. VT monitoring integration for Exalogic was introduced in VT 12.1.0.3 plug-in (EM12cR2 release)
• ZFS plug-in – enables ZFS target monitoring
• Engineered System Healthchecks plug-in – enables Exachk integration in EM CC
• Oracle Applications plug-ins (FA, EBS, PSFT, Siebel etc) – enables respective Application Management capabilities
  

Setting up EM CC 12c for monitoring non-virtualized/physical Exalogic stack

• Setup your EM CC 12cR2 site with latest PSU if not already done. Refer to EM 12cR2  install/upgrade guide here
• Deploy EM 12cR2 agents on all Compute Nodes. 
• Discover Exalogic system via Targets -> Systems UI and select deployment type 'Physical’ and use any of the agents deployed on compute nodes for Exalogic targets discovery
• Setup your EM Ops Center (OC) 12c site if not already done. Refer to EM OC 12c installation guide for Linux OS here and in case of Solaris OS here
• Discover Exalogic infrastructure targets in EM OC 12c by following EM OC feature reference guide here
• Deploy Exalogic Elastic Cloud Infrastructure (EECI) plug-in on EM CC OMS and management agent installed on OC Enterprise Controller server. Refer to EECI Plug in Install guide here for details and it’s also recommended to apply EECI plug-in patch 14214742. Each infrastructure component must be already discovered and managed in EM OC in previous step. Availability, performance and configuration Metrics for infrastructure components related to are collected by EM CC agent through EM OC JMX client.
• Configure EM OC Enterprise Controller and EM CC repository connection by following EM OC Plug in guide here
• Discover ‘Elastic Cloud Infrastructure’ target via Setup -> ‘Add Target’ -> ‘Add Targets Manually’ option and using agent deployed on Ops Center Enterprise Controller
• Deploy and configure EM CC ZFS plug-in by referring to ZFS plug-in installation guide here. It’s recommended to use the agent deployed on EM OC Enterprise Controller server for discovering ZFS Storage Appliance target.
• Deploy and configure EM CC Engineered System Healthchecks plug-in by referring to plug-In installation Guide here. It’s recommended to use the agent deployed on EM OC Enterprise Controller server for discovering Healthchecks target.
• FMW, Apps targets and Application stack should be discovered in EM CC.In case of Oracle Applications on Exalogic, it’s recommended to have respective Apps plug-ins (FA, EBS, PSFT, Siebel etc) deployed and configured. Refer to Applications Management pack collateral here.
  
  
  

EM CC Plug-Ins required in case of non-virtualized/physical Exalogic configuration –

• Fusion Middleware (FMW) Plug-in [Default plug-in and deployed out-of-box]  – enables overall Exalogic stack management.
• Exalogic Elastic Cloud Infrastructure (EECI) plug-in - enables Exalogic rack infrastructure components monitoring in EM CC
• ZFS plug-in – enables ZFS target monitoring
• Engineered System Healthchecks plug-in – enables Exachk integration in EM CC 
•  Oracle Applications plug-ins (FA, EBS, PSFT, Siebel etc) – enables respective Application Management capabilities
  

Additional Collateral -

• Oracle Enterprise Manager 12c: Managing Exalogic Elastic Cloud Demo
• Oracle Enterprise Manager Cloud Control 12cR2 Exalogic Monitoring guide
• Understanding Exalogic Control
• Oracle Exalogic: A Guide to Maximizing Operational Management Benefits (PDF)
• Oracle Exalogic: A Guide to Administration Tasks and Tools (PDF)

Contributed by Gagan Chawla, Saurabh Sachdev and Sumit Choudhary

Database as a Service: Glad that you asked these!

By Sudip Datta

Thanks for visiting my earlier blog post on the new Database as a Service (DBaaS) features which got released in Enterprise Manager 12cR2 Plugin Update 1.

Our first public webcast on DBaaS since the release was pretty well attended with peak attendance going well over our expectation. I wish we had more time to handle the technical Q&A, but since we didn't, let me use the blogosphere to answer some of the questions that were asked. I am repeating some of the questions that we answered during the webcast, because they warrant details beyond what the duration permitted.

Kevin from the audience asked "What's the difference between a regular provisioning and DbaaS?" Sometimes the apparently obvious ones are the most difficult to answer. The recently released whitepaper covers the regular/traditional provisioning versus DBaaS in detail. Long story cut short, in a traditional provisioning model, IT (usually a DBA) uses scripts and tools to provision databases on behalf of end users. In DBaaS IT's role changes and the DBA simply creates a service delivery platform for end users to provision databases on demand as and when they need them. And that too, with minimal inputs ! Here's how the process unfolds:

• The DBA pools together a bunch of server resources that can host databases or a bunch of databases that can host schema and creates a Self-Service zone.
• The DBA creates a gold image and provisioning procedure and expresses that as a service template
• As a result, the end users do not have to deal with the intricacies of the provisioning process. They input a couple of very simple things like the service template and the zone and everything else happens under the hood. The provisioning process, the physicality of the database, etc are completely abstracted out.
• And finally, because DbaaS deals with shared resource utilization and self-service automation, a DBaaS is usually complemented by quota, retirement and chargeback. 

The following picture can make it clear.

In terms of licensing, for a traditional administrator driven database provisioning, you need the Database Lifecycle Management Pack.  If you want to enable DBaaS on top of it, simply add the Cloud Management Pack for Database. 

I will combine the next two questions. Alfred asked, "Is RAC a requirement?" (the short answer for which is "No") while Jud asked, "Is the schema-level provisioning supported in an environment where the target DBs are running in VMs?" First of all, in our DBaaS solution we support multiple models, as shown below.

In the dedicated database model, the database can run on a pool of servers or a pool of cluster. So both single instance and RAC are supported. Similarly, in the dedicated schema (Schema as a Service) model, it can run on single instance or RAC, which can in turn be hosted on physical servers or VMs. Enterprise Manager treats both physical servers and VMs as hosts and as long as the hosts have the agent installed, they can participate in DBaaS. Bottomline is that as we move from IaaS and offer these higher order services, the underlying infrastructure becomes irrelevant. This should also satisfy Steve, who queried "As the technology matures is there an attempt by Oracle to provide ODA vs EXADATA as the foundation of the dbaas to lower the cost?". The answer is YES. But, why wait?  DBaaS is supported on Exa and ODA platforms TODAY. In fact, HDFC Bank in India is running DBaaS on Exadata. You can read about them in the latest Oracle Magazine.

Another interesting question came from Yuri. He asked, "Is there an option to disable startup/shutdown for the self-service users?" It can be answered in multiple ways. First of all, in Schema as a Service or dedicated schema model, the end user cannot control the database instance state because it houses database services (schemas) owned by others too. So this may be a good model for enterprises trying to limit what end users can do at the database instance level.  However, in a dedicated database model, the Enterprise Manager out-of-box self-service console allows the end user to perform operations like startup and shutdown on the database instance. In general, if you want to create your tailored own self-service console with a limited set of operations exposed in the self-service interface, using the APIs may be the way to go. Enterprise Manager 12c also supports RESTFul APIs for self-service operations and hence a limited set of capabilities may be exposed. Check this technical presentation for the supported APIs.

Gordon's question precisely brings out the value of the Enterprise Manager 12c offering. He asked, "How do the services in the cloud get added to Cloud Control monitoring and alerting?" Ever since Amazon became the poster child of public IaaS, enterprises tried emulating their model within the data centers. What most people ignore or forget is that there is a life of the resources in a cloud beyond the provisioning process. Initial provisioning is just the beginning of that lifecycle. In Amazon's case, the management and monitoring of resources is the headache of Amazon's IT staff and consumers are oblivious to the time and effort it takes for them to manage the resources. In a private cloud scenario, one does not have that luxury. Once the database gets provisioned, it needs to monitored for performance, compliance and configuration drifts by company's own  IT staff. In Enterprise Manager 12c, the agent is deployed on the hosts that constitute the pool making the databases automatically managed without any additional work. It comprehensively manages the entire lifecycle and both adminsitrators and self-service users have tailored views of the databases. Well, this also gives me an opportunity to address a question by a participant who alluded to a 3rd party tool exclusively for database provisioning purposes. First of all, as I mentioned during the webcast, Enterprise Manager 12c is the only tool that handles all the use cases- creation of full databases, schemas and cloning (both full clone and Snap Clone) from a single management interface. The point tools out there handle only fraction of these use cases- some specialize in cloning while others specialize in seed database provisioning. Second, as stated in the previous answer, provisioning is only the initial phase of the lifecycle and a provisioning tool cannot be synonymous with a cloud management tool. Thanks Gordon for helping me make that point!

Sam and Cesar share the honors for the most difficult question that came right at the beginning. "Has it started?  Been on hold for a while ." was their reaction at two minutes past ten. This is possibly the most embarrassing one for me because I was caught in traffic. With due apologies for that, I wish my car operated like Enterprise Manager's  Database as a Service!

By Sudip Datta