This section describes the monitoring of the Oracle Database environment, including stand-alone and extended solutions for monitoring the Oracle Database 11g and 12c, the guest OS, and the full stack for the Oracle Tenant Resource Pod.
OEM Database Control is the primary stand-alone tool for managing your Oracle Database 11g. It can be installed as part of the database creation process.
Use Database Control to perform administrative tasks such as managing schema objects, controlling user security, managing database memory and storage, backing up and recovering databases and, if licensed, viewing performance and diagnostic information for your database. Figure 33 shows the OEM Database Control Login and Home page.
Figure 33. OEM Database Control Login and Home page
Database Control was configured as part of the Oracle Database 11g deployment, with some simple scripting in the application blueprint and service, as shown in Figure 34.
Overview
Monitoring Oracle Database 11g stand-alone
EMC Enterprise Hybrid Cloud 2.5.1, Federation Software-Defined Data Center Edition: 41 Deploying Oracle Database as a Service Oracle Enterprise Manager Database Express 12c (EM Express) is a web-based tool for managing Oracle Database 12c. It is built into the database and runs in the XDB schema inside the database. EM Express is easy to configure and offers support for basic database administration tasks such as storage and user management. If licensed, it provides comprehensive solutions for performance diagnostics and tuning. Figure 35 shows the EM Express Database Home and Login windows.
Figure 35. EM Express Login screen and Database Home window
For this solution, we enabled EM Express as part of the Oracle Database 12c
deployment with some simple scripting in the application blueprint and service, as shown in Figure 36.
Figure 36. Extract from the Oracle 12c service install script enabling EM Express
OEM Cloud Control 12c is Oracle’s integrated enterprise IT management product line, which is widely used for managing and monitoring the Oracle Database estate. It is highly configurable and has a number of partner plug-ins such as the EMC VMAX and VNX storage plug-ins for Oracle Enterprise Manager 12c.
The vCenter Operations Management Pack for Oracle Enterprise Manager from Blue Medora leverages Oracle OEM data to monitor Oracle environments and workloads via vCenter Operations Manager.
For this solution, we registered our host and database as targets with an existing environment featuring OEM Cloud Control 12c Release 2 (version 12.1.0.2), as shown in Figure 37.
Monitoring Oracle
Figure 37. Screen shot showing host, database, and listener targets after deployment We configured the OEM Management Agent as a scripted component in an
application blueprint and included it as part of the Oracle Database deployment, as shown in Figure 38.
EMC Enterprise Hybrid Cloud 2.5.1, Federation Software-Defined Data Center Edition: 43 Deploying Oracle Database as a Service VMware vCenter Operations Manager is the main operations management component of the EMC Enterprise Hybrid Cloud solution. It provides a simplified approach to operations management of physical and cloud infrastructures. vCenter Operations Manager includes operations dashboards to provide insights and visibility into the health, risk, and efficiency of your infrastructure, and to provide performance management and capacity optimization capabilities.
vCenter Operations Manager provides prebuilt and configurable dashboards for realtime performance, and capacity and configuration management. It abstracts performance data to health, risk, and efficiency measurements that enable IT to quickly identify evolving performance problems. Integrating vCenter Operations Manager with EMC ViPR Analytics enables full end-to-end visibility of the entire infrastructure, from virtual machine to LUN and every point in between. Figure 39 shows an example of the Details screen under the Operations tab in vCenter Operations Manager.
Figure 39. vCenter Operations Manager Details screen for a virtual machine deployed with Oracle DBaaS
The vCenter Operations Manager custom interface presents the ViPR Analytics and EMC Storage Analytics (ESA) packs. This enables administrators to quickly visualize the health of ViPR virtual arrays as well as physical VMAX and VNX arrays (both block and file) using customized EMC dashboards for vCenter Operations Manager, such as the EMC ViPR dashboard.
Capacity analytics in vCenter Operations Manager identify over-provisioned resources so they can be right-sized for the most efficient use of virtualized resources. What-if scenarios eliminate the need for spreadsheets, scripts, and rules of thumb.
ViPR SRM offers comprehensive monitoring and reporting for this hybrid cloud solution that helps IT visualize, analyze, and optimize their software-defined storage VMware vCenter
Operations Manager
infrastructure. Cloud administrators can use ViPR SRM to understand and manage the impact that storage has on their applications and view their storage topologies in their hybrid cloud from application to storage. They can view capacity and
consumption of ViPR software-defined storage and identify service-level agreement (SLA) issues via realtime dashboards or reports to meet the needs of the wide range of hybrid cloud users. Figure 40 shows the ViPR Performance dashboard.
Figure 40. ViPR Performance dashboard
In addition, for centralized logging, infrastructure components can be configured to forward their logs to VMware vCenter Log Insight, which then aggregates the logs from all the disparate sources for analytics and reporting. When integrated with vCenter Log Insight, EMC content packs for Avamar, VNX, and VMAX provide dashboards and user-defined fields specifically for those EMC products, which enables administrators to conduct problem analysis and analytics on their storage array and backup
infrastructure.
EMC Enterprise Hybrid Cloud 2.5.1, Federation Software-Defined Data Center Edition: 45 Deploying Oracle Database as a Service
Conclusion
EMC Enterprise Hybrid Cloud enables customers to build an enterprise-class, scalable, multitenant platform for complete infrastructure service lifecycle management.
The solution uses the best of EMC and VMware products and services to deliver on the following principles:
Self-service and automation
Multitenancy and secure separation
Workload-optimized storage
Security and compliance
Monitoring and service assurance
In addition, the solution supports the use of modular add-on components, including one for application services such as vCloud Automation Center Application Services and vCenter Orchestrator.
This solution enables the deployment of Oracle DBaaS in a dedicated business group running on EMC Enterprise Hybrid Cloud. The key findings of this solution are as follows:
Designing EMC Enterprise Hybrid Cloud with a dedicated Tenant Resource Pod for Oracle DBaaS improves management of Oracle licensing compliance.
Application developers and service users can provision an Oracle Database directly from the vCloud Automation Center Service Catalog for Day 1 operations.
The solution offers elasticity and support for Day 2 operations. The addition of resources—for example increasing vCPU or memory, or allocating storage—can be managed from vCloud Automation Center and applied or scheduled in line with defined approval policies. vCenter Orchestrator workflows can extend Day 2 operations to deliver custom actions managed in vCloud Automation Center.
vCenter Orchestrator enables process automation throughout the machine provisioning lifecycle in vCloud Automation Center from build to disposal.
Using vCloud Automation Center Application Services, DBAs and application architects can quickly build and publish blueprints with a drag-and-drop interface to automate the deployment of simple and multitier applications.
Summary
Findings
References
For additional information on EMC Enterprise Hybrid Cloud, see the following documents:
EMC Enterprise Hybrid Cloud 2.5.1, Federation Software-Defined Data Center Edition: Foundation Infrastructure Reference Architecture
EMC Enterprise Hybrid Cloud 2.5.1, Federation Software-Defined Data Center Edition: Foundation Infrastructure Solution Guide
EMC Enterprise Hybrid Cloud 2.5.1, Federation Software-Defined Data Center Edition: Data Protection Continuous Availability Solution Guide
EMC Enterprise Hybrid Cloud 2.5.1, Federation Software-Defined Data Center Edition: Data Protection Backup Solution Guide
EMC Enterprise Hybrid Cloud 2.5.1, Federation Software-Defined Data Center Edition: Data Protection Disaster Recovery Solution Guide
EMC Enterprise Hybrid Cloud 2.5 with VMware: Security Management Solution Guide
EMC Enterprise Hybrid Cloud 2.5 with VMware: Pivotal CF Platform as a Service Solution Guide
For additional information, see the following VMware product documentation.
VMware vCloud Automation Center documentation
Foundations and Concepts
Installation and Configuration
System Administration
IaaS Configuration for Virtual Platforms
Application Services
Tenant Administration
Advanced Service Design
Extensibility
Custom Properties Reference
IT Business Management Standard Edition documentation
IT Business Management Standard Edition Installation and Administration Guide
IT Business Management Standard Edition User's Guide VMware vCenter Orchestrator documentation
EMC
documentation
VMware documentation
EMC Enterprise Hybrid Cloud 2.5.1, Federation Software-Defined Data Center Edition: 47 Deploying Oracle Database as a Service Blog
Manage your SDDC: Add/remove vCAC IaaS VMs to/from DNS by Yuval Tenenbaum
Oracle Enterprise Manager Cloud Control documentation
Advanced Installation and Configuration Guide Oracle Database documentation
Database Installation Guide for Linux—Oracle Database 12c Release 1 (12.1)
Database Installation Guide for Linux—Oracle Database 11g Release 2 (11.2) My Oracle Support
Doc ID 1543773.1 : How to create an emcli script to add databases via emcli Oracle
documentation