Oracle has announced that Oracle Enterprise Manager 12c now delivers integrated management for Oracle Database 12c.

Purpose built for the cloud, the combined power of Oracle Database 12c’s multitenant architecture and Oracle Enterprise Manager 12c enables customers to easily consolidate, clone and manage many databases as one, improving IT productivity by reducing the time needed to perform administrative tasks and providing the ability to quickly identify and resolve issues through comprehensive diagnostics and analysis capabilities.

New database management capabilities are available with Oracle Enterprise Manager 12c Release 3. Customers running earlier releases of Oracle Enterprise Manager 12c can add the new functionality using the self-update console.

Oracle Enterprise Manager 12c’s next-generation automation capabilities allow administrators to streamline IT management processes, free up resources and reduce overall costs.

The new cloud lifecycle management capabilities for Oracle Database 12c include innovative management for multitenant databases. It offers customers in-depth intelligence into capacity planning, post-consolidation performance and faster deployments for consolidated database environments.

New features include:
* Complete lifecycle management of multitenant databases – support for the entire lifecycle operations of multitenant databases that comprise migration, creation, cloning and patching. The powerful configuration management capabilities of Oracle Enterprise Manager enable administrators to track the multitenant databases, manage compliance and avoid sprawl.

* Consolidated database replay – allows customers to test and plan their consolidation using Oracle’s multitenant container and pluggable database technology. Using real application workloads, administrators can understand the effects of database consolidation on service levels, resources and performance in either a standard or multitenant database environment.

* At-source data masking – allows customers to maximise compliance and security by masking data in-flight as it is being copied from production, thus helping ensure that sensitive data never leaves production system unmasked.

* Enhancements for continued industry leading performance management – focused on streamlining database administration, allowing administrators to make faster decisions and spend less time analysing issues, improving overall service quality and IT productivity.

* Enhanced diagnostics – improvements to Automatic Database Diagnostic Monitor (ADDM) for real-time and proactive problem detection, especially designed for catching short, transient performance issues.

* Realtime business operations monitoring – monitors composite business operations like batch jobs and ETL operations, providing real-time report of all SQLs and PL/SQLs executed inside the job.

* Performance hub – newly redesigned performance Home Page that provides administrators with a single, at-a-glance view of all performance data and advisors such as Active Sessions, I/O, memory, CPU, ADDM, SQL Tuning, Real-Time SQL Monitoring and Active Session History (ASH) Analytics.

* New Oracle Enterprise Manager Database Express 12c – an out-of-the-box, lightweight, easy-to-use web-based management solution for managing individual databases.

* New capabilities for deploying and managing database clouds – enable consolidation, standardisation, self-service automation and showback/chargeback while lowering cost of delivering database as a service (DBaaS). The new DBaaS features work on Oracle Database 10g and above.

* Schema as a service – ultimate consolidation of databases that lets administrators host multiple application schemas within a single database and thus offer database as a service to hundreds of application users without creating database sprawl. Users can perform day-to-day actions like provisioning, monitoring and backup, all from a single self-service console.

Schema as a service leverages database features like the Resource Manager and Database Vault to isolate the users of the cloud. This is complemented by metering and showback/chargeback capabilities, which provide visibility and transparency into resource consumption by each user.

* Snap Clone – instant database cloning allows administrators to create fully functional copies of databases using the copy-on-write (CoW) capabilities of the underlying storage layer. Users can request these databases from the self-service console and have them provisioned within minutes instead of hours while keeping storage needs to a minimum.

This technology is particularly useful for large scale functional testing on data that does not undergo lot of changes. Using Snap Clone, one can also create multiple snapshots of the database and “time travel” across these snapshots to access data from any point in time. Snap Clone can fundamentally improve the efficiency and agility of administrators and QA Engineers while saving CAPEX on storage.

“As enterprises continue to implement private clouds, IT management is becoming increasingly complex and costly,” says Sushil Kumar, VP, Product Strategy and Business Development, Oracle.
“Oracle Enterprise Manager 12c is being used by organisations around the world for its broad set of cloud-enabling and management capabilities. Oracle Database 12c is a new paradigm in database technology that promises to make IT rethink how they store and manage data in the cloud.

“By extending Oracle Enterprise Manager 12c to enable managing ‘many as one,’ with the new database release, Oracle is making it even easier for customers to significantly reduce IT management costs, avoid critical issues and outages and free up resources for other business-critical tasks.”