Self-Service Driven Provisioning of Pluggable Databases
announced new capabilities that support managing the full lifecycle
of pluggable database as a service in Oracle Enterprise Manager 12c
Release 3 (18.104.22.168). This latest release builds on the existing capabilities
to provide advanced automation for deploying database as a service using
Oracle Database 12c Multitenant option. It takes it one step
further by offering pluggable database as a service through Oracle Enterprise
Manager 12c self-service portal providing customers with fast
provisioning of database cloud services with minimal time and effort.
is a significant addition to Oracle Enterprise Manager 12c’s
existing portfolio of cloud services that includes infrastructure as a
service, database as a service, testing as a service, and Java platform as a service. The solution
provides a self-service mechanism to provision pluggable databases allowing
users to request and access database(s) on-demand. The self-service operations
are also enabled through REST APIs allowing customers to integrate with
third-party automation systems or their custom enterprise portals.
provisioning allows rapid access to pluggable database as a service
for hosting or certifying applications on Oracle Database 12c
driven migration to pluggable database as a service in order to migrate
a pre-Oracle Database 12c database to a pluggable database
as a service model and test the consolidation strategy
service catalog for all approved pluggable database as a service configurations
which helps customers achieve standardization while catering to all
applications and users in the enterprise
guarantee via database resource manager (and IORM on Oracle Exadata)
that enables deployment of mixed workloads in a shared environment
role based access, and policy based management that enforces governance
and reduces administrative overhead
or showback which improves metering and accountability for services
consumed by each pluggable database
REST APIs that support integration with ticketing or change management
systems, and or with other self-service portals
administrative and maintenance overhead through self-managing automation
that allows for intelligent placement of pluggable databases
how pluggable database as a service works, watch this quick demo:
miss this opportunity to learn first-hand how Oracle Database 12c
and Oracle Enterprise Manager 12c bring together the next evolution
in self-manageability—so you can plug into the Cloud faster using
the power of Oracle Database 12c.
Join us for this live
webcast to discover new groundbreaking management capabilities for:
diagnostics and application tuning
Managing many pluggable
databases as one
database cloud services
Only Oracle Enterprise
Manager 12c offers customers maximum performance, enhanced automation,
and total control for Oracle Database 12c.
These new capabilities
can be integrated with your standard monitoring and management that you
already have in your environment without having to undertake any additional
tools or any additional training. Simply install or upgrade to Oracle
Enterprise Manager 12c and Oracle
Database 12c and together these two products will let you plug into
Here is a quick summary
of all the new Oracle Enterprise Manager 12c capabilities for Oracle Database
lifecycle management of multitenant databases: Support
for the entire lifecycle operations of multitenant databases that
comprise migration, creation, cloning, patching and tracking for compliance
data masking: Allows customers to maximize compliance and security
data in-flight as it is being copied from production
diagnostics: Improvements to Automatic
Database Diagnostic Monitor (ADDM) for real-time and proactive problem
detection, especially designed for catching short, transient performance
business operations monitoring: Monitors
composite business operations such as; batch jobs and ETL operations,
providing real-time reports on all SQLs and PL/SQLs executed inside
hub: Newly redesigned performance
home page that provides administrators with a single, at-a-glance
view of all performance data and advisors
Enterprise Manager Database Express 12c: An out-of-the-box,
lightweight, easy-to-use web-based
management solution for managing individual databases
as a Service: This ultimate
consolidation of databases lets administrators host multiple application
schemas within a single database and offer database as a service to
hundreds of application users without creating database sprawl
database cloning allows administrators to create fully functional
copies of databases using the copy-on-write capabilities of the underlying
us for a live Webcast to find out about the recently released Oracle Enterprise
Manager 12c plug-ins that deliver new capabilities and support
for managing database cloud services with schema as a service for extreme
database consolidation and quick efficient database cloning through Snap
Clone or RMAN Backups. These new capabilities provide an optimum utilization
of development and database resources giving customers more flexibility
and control during application development, leading to a faster time-to-market
for delivering IT services.
we deal with Database as a Service use cases, we often find that consumers
do not need dedicated databases of their own. Developers of a home-grown
application, for example, might be satisfied with a logical slice of the
database. This logical slice, leads us to the concept of Schema as a Service—a
new capability offered in the latest release of Oracle
Enterprise Manager 12c Release 2 Plug-in Update 1.
Schema as a service
is the ultimate and extreme in consolidating multiple schemas in a shared
database model. Cloud users can request one or more schemas, with or without
seed data, from Oracle Enterprise Manager 12c’s out-of-the-box self
service portal. It offers excellent manageability, not only for its fast
efficient provisioning, but because administrators only need to manage
a small number of databases.
Schema as a
Service: Consolidate Multiple Schemas in a Shared Database Cloud Services
comes at the expense of isolation, because the operating system and database
are not isolated among the database consumers. While enabling Schema as
a Service, it’s important to isolate the workloads as much as possible
to make sure that one user doesn't run away with all the database resources.
Administrators can guarantee this does not happen by using Oracle Enterprise
Manager 12c’s CPU monitoring capabilities built in to Oracle
Database Resource Manager to maintain service levels.
For security, the
more consolidated you get, the more concerns administrators have about
data isolation and security. Using Oracle
Data Vault can help resolve these issues. It is integrated with Oracle
Enterprise Manager 12c, and administrators can use Oracle Data Vault to
enable fine grain control based on roles and privileges within the database
For reporting purposes,
metering and chargeback capabilities can be implemented to help IT organizations
gain in-depth visibility into resource consumption and expenses incurred
with each schema as a service deployment. This is useful for regulatory
compliance requirements as well.
a Service at a Glance:
application schemas in a shared database deployment model
user (i.e. developers or testers) can provision one or more database
schema(s) with a dedicated database cloud service
can be based on workload characteristics and specifications
are guaranteed through Oracle Database Resource Manager
is done through quotas, retirement policies and chargeback plans
Oracle Data Vault for security isolation and control
when needs change
through ultimate consolidation of multiple database applications
productivity and increase efficiency with automated provisioning
Deploy schema as
a service implementations consistently using self-service profiles and
Metering and chargeback
helps keep track of resource consumption and usage for accountability
overhead and compliance challenges by preventing database sprawl
How To: There are several steps
involved when setting up and deploying database schema as a service in
Oracle Enterprise Manager’s self service portal. Here is a quick
summary of what’s involved. For more details be sure to review the
up Platform as a Service Zones
your schema as a service, you first need to create a Platform as a Service
(PaaS) infrastructure using Oracle Enterprise Manager 12c’s self-service
portal. A PaaS Zone comprises multiple hosts, i.e. servers with Oracle
Enterprise Manager 12c agent installed.
Use the portal
to create a PaaS zone and organize it by function type (i.e. based on
geography, line of business (sales, development) or application lifecycle.
(i.e. dev, test, QA, production)
Next expose the
PaaS zone to the self-service cloud users in the portal. For example,
developers can now have the option to select a development PaaS zone
or testers can select a QA zone.
each zone can be restricted based on the self-service user's credentials.
up Database Pools
are a collects of databases used to host schema as a service.
To create a new
database pool, you can use a portion of resources that are available
to the zone. Keep in mind that all members of the database pool need
to be the same target type. For example, a single database instance
or database cluster; platform, or same database version. This ensures
provisioning consistency during deployment.
placement constraints and policies for the database pool. For placing
databases within the pool and controlling how resources are utilization,
you need to first create a placement constraint and set its policies.
This provides protection for the database members within the pool for
resource consumption. For example, a production database pool might
enforce more conservative constraints whereas a development pool might
allow liberal limits.
You can set a
constraint for each database in the pool by services or by workload
associated with the service request based on CPU and memory. You can
also enable Oracle Database Resource Manager for the database pool to
control your CPU usage and the underlying service levels.
During this part
of the schema as a service set up, future reservations, archive retention
and duration of request can all be enabled.
and setting limits for users based on role level can be assigned in
this step of the process. Oracle Enterprise Manager supports quota based
on CPU, memory and number of database services.
and Service Templates
A service template
is standardized definition that is offered to self-service users to
create a database or schemas within the deployment. A service template
defines the workload characteristics and schema details that can be
generated with or without seed data.
To create a service
template with seed data, you need to create a profile. A profile is
an entity that captures source database information for provisioning
purposes. Once you create your service template it becomes part of a
collection which makes up the service catalog. This catalog is then
exposed to cloud users in the self-service portal.
Next, you can
either export the seed data from the source database or export the schema
definitions without the data. Once you decide, a Data Pump Export job
will be created.
You can now map
your newly created profile and service templates to the required zone(s)
and database pools.
The final step
in deploying schema as a service is to configure resource metering and
Setting up metering
and chargeback can easily be done in order to track resource usage within
the schema as a service implementation.
For more information
on how to set up chargeback we recommend reading this white
us for this presentation to learn about Oracle Enterprise Manager 12c's
recent release of new and updated Management Plug-ins that provide optimum
utilization of compute resources, ultimately leading to faster time-to-market
for IT services delivery. In addition to providing enhanced cloud management
support, the Plug-ins extend Oracle Enterprise Manager 12c's
capabilities for Database as a Service (DBaaS) and Infrastructure as a
Service (Iaas), as well as introduce new features for Testing as a Service
This year 2013 valentines day, we announced the GA of several brand new Plug-ins versions for Enterprise Manger Cloud Control 12c.
We also released Oracle Enterprise Manager Cloud Control 12c Release 2 Plug-in Update 1 (22.214.171.124) for multiple platforms. Release 2 Plug-in Update 1, contains the original bits of 12c EM Cloud Control Release 2 (that was originally released in Oct 2012), packaged with the latest versions of several Plug-ins (including some brand new plugins).
Following shows the list of new plug-ins versions available along the Oracle Enterprise Manager Cloud Control 12c Release 2 Plug-in Update 1 (126.96.36.199). The new plug-ins have dependency on 188.8.131.52, and customer needs to be on minimum 184.108.40.206 version of the product before deploying new plug-in versions. The new plug-ins include tons of new features, support for new managed targets, along with stability and performance bug fixes.
The brand new version of DB plugin ( DB 220.127.116.11), comes packed with stability and brand new features of diagnosability, High Availability, Manageability, RAC and Grid Infrastructure, Security etc. Above plug-in list includes Enterprise manager Storage Management Framework, a brand new plug-in that enables Snap Clone functionality by leveraging the snapshot and Copy on write features of underlying Storage. The new plug ins are packed with features like Testing as a service, Snap Clone, Schema as a service, RMAN based Data Prov just to name a few.
Note: The "Oracle Big Data Appliance" & "Oracle Engineered System Healthcheck" Plug-ins were released sometime back (and have been available to EM customers on Self Update).
EM Customers can do a fresh installation using "Oracle Enterprise Manager Cloud Control 12c Release 2 Plug-in Update 1 (18.104.22.168)", and will get the latest version of the product, along with all the latest plug-ins out of the box.
EM Customers who are on Release1 (22.214.171.124), or on older releases 11g and 10.2.0.5, can choose to use Oracle Enterprise Manager Cloud Control 12c Release 2 Plug-in Update 1, to move/upgrade directly to the latest Release 2, and all plug-ins will be automatically upgraded to the latest versions of all Plug-ins deployed.
EM Customers who have previously already moved on to EM Cloud Control Release 2 (126.96.36.199), can choose to utilize Self Update to download/import and deploy the new Plug-in versions, using the self update feature in the product.
as leading financial services firm, SquareTwo Financial, talks about maintaining
compliance while increasing IT productivity and performance by replacing
in-house data masking with Oracle Data Masking solution.
pre-built templates for popular packaged systems such as, Oracle E-Business
expertise and strong DBMS security portfolio
Oracle Data Masking ensures privacy by transforming sensitive data before
it is transferred to test, QA, and other non-production environments,
addressing regulatory compliance for both Oracle and non-Oracle Databases.
Oracle Data Masking Pack: Production data is cloned
and masked before being copied to Test.
masking with role-based security
Optimized for Oracle
and non-Oracle databases
Oracle testing products
Oracle Data Masking
completely replaces sensitive information such as; names, account numbers,
SSNs, financial results, purchasing transactions, etc. in your development,
test and QA systems with data that cannot be “reverse engineered”
to reveal its original source. This allows production data to be safely
used for development, testing, or sharing with out-source or off-shore
partners for other non-production purposes. The Pack provides extensive
search capabilities to scan enterprise databases for sensitive
data discovery based on established data patterns and models.
The solution allows
masking of all the related data elements automatically while preserving
referential relationships combining the sensitive data columns and associated
relationships in an Application Data Model. Oracle Data Masking can detect
data dependencies, such as foreign key constraints and replaces sensitive
information transparently. This ensures that the referential integrity
necessary for applications to work and function properly will continue
be in place, even on development systems.
will save time and eliminate risk by replacing individual scripts and
routines written by DBAs with centrally managed and deployed libraries
of masking processes.
scalable and automated solution to create test environments from production
data using bulk masking.The
solution enables faster time-to-market by speeding up the development
process while helping organizations comply with privacy regulations
and confidentiality policies.
Enables rapid DBA
productivity through the use of application masking templates.
data masks that are defined once and can be used every time that set
of data needs to be masked.
Data security is
integrated within the application management lifecycle, meaning that
DBAs can provide realistic-masked production data to developers or testing
groups for accurate application testing while reducing their storage
costs by not having to provision an entire production environment for
each developer or project.
Oracle Data Masking
Pack is built into and installed with Oracle Enterprise Manager 12c.
for Security and Compliance
Oracle Data Masking offers a comprehensive and customizable library of
masking formats, templates and policies that can be used to replace sensitive
information with realistic simulated values—all with just a few
mouse clicks. The sensitive data never has to leave the Oracle Database
or the production environment. This maintains data security and compliance
through privacy and confidentiality polices on shared production data.
The solution helps protect against unauthorized access to data that is
being shared with off-shore developers, partners or 3rd party vendors.
Oracle Data Masking Pack: Centralized Extensible
In addition, Oracle
Data Masking allows organizations to enforce compliance with regulatory
requirements such as; Sarbanes-Oxley, Payment Card Industry Data Security
Standards, Health Insurance Portability and Accountability Act, as well
as numerous other laws and regulations that restrict the use of actual
Oracle Data Masking
continues to gain strong adoption, check out the latest customers to see
how they are benefiting from the solution:
the latest news about Coles
Supermarkets, one of Australia's largest grocery chains with more
than 100,000 employees and 2,000 stores country-wide. Learn how Coles
completely revamped their data warehouse with Oracle Exadata and Oracle
Enterprise Manager 12c . The new system improved Coles's processes
and critical reporting by as much as 3 to 4x out-of-the-box with a 4 to
6x faster query performance. The result, higher quality of service for
the business and for customers during peak seasonal spikes.
February 7 10:00 a.m. PST / 1:00 p.m. EST
us for a live and interactive webcast on how to comply with regulatory
requirements and data protection policies by protecting sensitive data
in non-production Oracle Databases as well as non-Oracle databases using
Oracle Data Masking Pack, a part of Oracle Enterprise Manager 12c
quality management and Oracle Database Security defense-in-depth solution.
discovering sensitive data
Standard and advanced
masking techniques made easy
Eliminate the need
for a staging database using At-source masking
Secure your Oracle
Applications (Oracle E-Business Suite, Oracle Fusion Applications) data
quickly using masking templates
integration with Oracle's data subsetting solution
Earlier this month (Jan 2013) we announced the GA of Enterprise Manager for Big Data Appliance (BDA) Plugin - 188.8.131.52.0
is the first version of Enterprise Manager for Big Data Appliance (BDA)
Plugin release. The plugin is available to EM customers on Self Update
(screenshot below), and certification information for this plugin is
also available to customers on MyOracleSupport certify (here).
Using the Enterprise Manager 12c Big Data Appliance Plug-in 184.108.40.206, users can:
Discover the software and hardware components of a Big Data Appliance Network and add them as managed targets.
Manage the hardware and
software components that comprise a Big Data Appliance Network as a
single target or as individual targets.
Study collected metrics to analyze the performance of the network and each Big Data Appliance component.
Trigger alerts based on availability and system health.