Webcast: Database Provisioning in Minutes: Using Oracle Enterprise Manager 12c DBaaS Snap Clone and EMC Storage
By Scott Mcneil-Oracle on Feb 23, 2015
Oracle Enterprise Manager 12c Database as a Service Snap Clone allows administrators to create fully functional copies of databases using the capabilities of the underlying storage layer. Users can request databases from the self-service console and have them provisioned within minutes instead of hours while keeping storage needs to a minimum.
Attend this presentation
to learn more about the features and benefits of Oracle Enterprise Manager
12c DBaaS Snap Clone using EMC storage and to view a live demo.
The Independent Oracle Users Group (IOUG), is conducting its annual database manageability survey. If you are a database professional responsible for managing and operating your organization's database applications and systems, then the IOUG wants to hear from you.
Take the next few minutes to answer simply questions around your common manageability practices and challenges. Share your experience and insight with the IOUG and Oracle communities and you'll be entered into a draw for a chance to win an Apple iPad from the IOUG. You will also receive a free copy of the final report.
Guest contributors: Courtney Llamas and David Wolf
the steps involved for upgrading from Oracle Enterprise Manager 12c
Release 3 to Release 4? Is it an upgrade in place or a new install/migration
Do the patch
and upgrade functionality work on Oracle Database 11g targets
or only on Oracle Database 12c targets?
I find a full list of new enhancements compared to Release 3?
a list available of new features by management pack?
the best hardware configuration and setup in order to provide high availability
capabilities for database as a service (i.e. Oracle RAC, Oracle Exadata)?
Clone be used with EMC storage or is Oracle ZFS storage required?
Enterprise Manager support monitoring of hypervisors?
metering and chargeback functionality part of the base product or does
it requires an additional management pack?
Data Governance require additional licensing?
How is the
new AWR Warehouse feature different from the existing AWR report in
Oracle Enterprise Manager 12c Release 3?
new release require more disk space for the AWR Warehouse? More CPU
AWR Warehouse also support Oracle Database 10g and/or 11g AWR?
there a list of 3rd party technologies that can be managed by Oracle
Enterprise Manager 12c?
January 21, 2015
1:00 p.m. EST | 10:00 a.m. PST
The goal in every Oracle Enterprise Manager 12c rollout is to take it from zero to manageability in the shortest possible time. This presentation will show you how to accomplish this feat. Oracle experts will demonstrate how to properly architect and deploy Oracle Enterprise Manager 12c, including designing a highly available and scalable environment. Through this demonstration a list of essential techniques and tips compiled from Oracle Enterprise Manager Development’s Strategic Customer Programs team will also be shared. Topics such as; users, roles, groups, templates, and incidents will be discussed, plus key architectural decisions.
By attending this webinar, you will learn how to:
Featured Speaker: Courtney Llamas, Principal Member of Technical Staff, Oracle
IOUG eBrief: January Edition Now Available
Check out January's issue of the IOUG eBrief featuring all the latest news and highlights from IOUG and the Oracle Enterprise Manager 12c Special Interest Group (SIG).
Read the latest Economist Intelligence Unit whitepaper called Innovating to Optimize: Creating Room in the IT budget for Initiatives that Boost Business. The paper outlines new ways executives can use technology to improve IT operational processes in order to drive innovation and optimize their business. The Economist interviews industry experts and thought leaders, revealing candid insights and new emerging trends.
|IOUG Webcast: Long Term and Cross-Database Performance Analysis for Oracle Databases Using Automatic Workload Repository Warehouse|
January 15, 2015
The Automatic Workload Repository (AWR) feature in Oracle Database has been the standard used by DBAs to diagnose database performance problems.
In this session, you will learn about the new AWR Warehouse capability, which enables DBAs with capacity planning and performance analysis for Oracle Databases without the constraint of the retention period and without any overhead on critical databases.
Learn how AWR Warehouse can tell why performance was slow this month compared to the same period last year or give administrators an annual report of problems in your mission-critical databases.
Featured Speaker: Jagan Athreya, Senior Director of Product Management, Oracle
Check for compliance and automate patching of Oracle Database fleet using EM12c
Oracle along with its regular Quarterly Database PSU/SPU/CPU update this October 2014 released Oracle JAVA VM PSU patch, the patch is recommended to be applied to all databases in your fleet (esp. the ones that uses JAVA). (For more information, support Note- 1929745.1 explains it in detail).
The mandate primarily is to apply the patches against the databases that use JAVAVM option. Ideally, you would need to apply it against all databases, so in case a new database is created in the ORACLE_HOME it is covered.
Oracle Enterprise Manager 12c provides support features of Compliance Management and automated Patching of databases. Using both these features you could identify the databases in your fleet that needs the patch and automate applying them.
To get started, download the starter kit here. It contains utilities to jump start on your compliance, the kit contains a readily importable Compliance Standard and a step-by-step guide.[Read More]
Oracle Database 12c contains many new capabilities including Oracle Multitenant, in-memory column stores and much more. Oracle Real Application Testing gives you verifiable functionality and performance testing capabilities to take advantage of all the new enhancements. Combining your database upgrade with Oracle Real Application Testing assures you that your database will perform as required, whether you’re implementing an in-memory column store, consolidating to a database as a service model, or doing an in-place upgrade—join us in this webcast to learn more.
Scripts, the largest pharmacy benefit management organization in the United
States, automates its database services using Oracle Enterprise Manager's
centralized management solution. Watch
Enterprise Manager 220.127.116.11 has now been released for a few weeks, as well as the 18.104.22.168 OMS Bundle patches (also known as System patches). If you plan to apply these bundle patches to your 22.214.171.124 OMS, and you are concerned about the downtime, then, you can reduce the downtime by referring to this whitepaper that contains patching instructions to reduce downtime.
Patching has always been one of the many joys (or dreads) of Oracle DBAs. The effort compounds as the Database sprawl grows and the architecture complexity increases. Additionally, there is an increasing pressure to patch the systems with minimal or zero downtime.
EM12c's Database patch automation functionality provides an end-to-end management starting with proactive patch recommendations (like quarterly PSUs and CPUs), complete pre-flight checker to ensure predictable patching during maintenance window and automation for patching the comprehensive list of products under the Oracle Database family. ( EM12c Patch Automation overview)
Starting 126.96.36.199 (EM12c R4), the support is enhanced to be more tighter, can be done in 'Out of Place' mode, and has new supplemental features to manage the process along with its additional tasks.
In this post we will take a closer look of the data guard stand by patching feature and then dive into a use case, you could try out in your environment.
10 — 7:00 a.m. PT | 10:00 a.m. ET | 4:00 p.m. CET
Since the demands from the business for IT services is non-stop, creating copies of production databases in order to develop, test and deploy new applications can be labor intensive and time consuming. Users may also need to preserve private copies of the database, so that they can go back to a point prior to when a change was made in order to diagnose potential issues. Using Snap Clone, users can create multiple snapshots of the database and “time travel” across these snapshots to access data from any point in time.
Join us for an in-depth technical webcast and learn how Oracle Cloud Management Pack for Oracle Database's capability called Snap Clone, can fundamentally improve the efficiency and agility of administrators and QA Engineers while saving CAPEX on storage. Benefits include:
Since the launch of Oracle Enterprise Manager 12c Release 3, we have received tons of questions around managing Oracle Multitenant, an Oracle Database 12c Enterprise Edition option, and pluggable databases (PDBs)—more specifically; questions about pluggable database as a service (PDBaaS). In this blog, we provide answers to some of the common questions from people.
What qualifies a database to be pluggable?
Can the pluggable
databases be plugged and unplugged across multiple platforms such as Solaris,
AIX, and Linux?
of database consolidation, what are the differences between using VMs,
dedicated schemas and pluggable databases?
Pluggable database combines the best of all the other models and offers excellent consolidation, isolation, manageability and is suitable for any application that is certified to run on Oracle Database 12c. With the other models, we see certain shortcomings. For example, server virtualization offers good isolation but creates compliance and administrative headaches. Schema based consolidation offers ease of management and patching, but limited isolation.
How do you
track configuration drift with a pluggable database? I certainly understand
drift in the container database, but in what ways would a pluggable database
drift from its standard baseline?
What is a
zone? Is it physical? Regional?
be the DBA and SYSADMIN role in the pluggable DBaaS environment?
What if you
need custom configurations on a pluggable database? Once the database
is deployed via self-service how do you make changes?
If I'm an
application developer and I request a database with a certain pre-defined
service level, what level of permissions should I expect with that database?
Am I getting DBA or SYSDBA privileges with that request?
Are the pluggable
database as a service capabilities for Oracle Database 12c included in
Oracle Enterprise Manager 12c? Do we need a plug-in? Do we need to license
Oracle Enterprise Manager 12c Database Management Packs?
Enterprise Manager 12c Management Packs are required to be able to provide
If you have
shared memory and background processes in the container database, how
do you allocate server resources to a particular pluggable database? Can
you assign specific amount of CPU cycles, RAM and IOPS for a given pluggable
What is the
largest number of pluggable databases you can deploy on Oracle Exadata?
Can I use
pluggable database as a service if the target database is 9i or 10g?
Data Guard be configured for selective pluggable databases from a container
database? I do not want all pluggable databases to have a standby.
support pluggable databases?
For complete details of managing pluggable database as a service, be sure to watch this webcast: Delivering Pluggable Database as a Service
Munhowen, a leading Luxembourg beverage distributor, decided to replace its existing IT environment. By selecting Oracle technology, including Oracle Real Application Clusters, Oracle Enterprise Manager, Oracle Linux and Oracle ZFS Storage Appliances, the company was able to enhance system performance and reduce maintenance costs associated with sustaining an optimal hardware environment.
Jean-Pierre Rasquin, CIO, Munhowen, explains: “Implementing Oracle Real Application Clusters, Oracle Enterprise Manager, and Oracle ZFS Storage Appliance helped us to significantly increase our IT environment’s availability, scalability, and manageability—providing superior support, tailored to our business needs, while helping us to reduce maintenance costs.” Read the press release.
As a DBA, getting ahead of the demands of the job are challenging enough, day in and day out. A recent IOUG survey on database management sheds new light on some of the top challenges facing administrators. Here's an infographic breakdown on what you need to know.
the IOUG Survey.
If you have an Enterprise Manager 12c Release 3 or older agent monitoring database targets, Support may recommend that you install a JDBC (Java database connectivity) patch, such as patch 17591700, to prevent high CPU consumption by the agent.
JDBC patches, including 17591700, have readme files containing instructions for installing the patches to a database, not to an EM agent. This post provides an example of how to install a JDBC patch to an EM agent. It walks through the steps of installing patch 17591700 to an EM12c Release3 agent.
Here are the steps:
1. Identify the version of the JDBC client in the Agent Binaries home.
$ setenv ORACLE_HOME /u01/em12/core/188.8.131.52.0
Note: One way to find out the Agent Binaries home is to look in file /etc/oragchomelist on the agent host. It should contain an entry for an agent install in the format of:
<Agent Binaries home>:<Agent home>
For example, file /etc/oragchomelist contains:/u01/em12/core/184.108.40.206.0:/u01/em12/agent_inst
$ $ORACLE_HOME/OPatch/opatch lsinv -details | grep 'Oracle JDBC/OCI Instant Client'
Oracle JDBC/OCI Instant Client 220.127.116.11.0
In this case, the version of the JDBC client is 18.104.22.168.0.
2. Download the patch from MOS (My Oracle Support) website. The version of the JDBC client should match the version of the database for which the patch is intended. Stage the patch zip file, p17591700_111070_Generic.zip, on the agent host. I stage the patch in directory /u01/stage/jdbc_patch. I will refer to this location as the patch stage directory.
3. Go to the patch stage directory and extract files from the zip file.
$ cd /u01/stage/jdbc_patch
$ unzip p17591700_111070_Generic.zip
4. Stop the agent.
$ /u01/em12/agent_inst/bin/emctl stop agent
Oracle Enterprise Manager Cloud Control 12c Release 3
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
Stopping agent ..... stopped.
5. Install the patch.
$ cd /u01/stage/jdbc_patch/17591700
6. Start the agent.
$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 22.214.171.124.0
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/em12/core/126.96.36.199.0
Central Inventory : /u01/app/oraInventory
from : /u01/em12/core/188.8.131.52.0/oraInst.loc
OPatch version : 184.108.40.206.0
OUI version : 220.127.116.11.0
Log file location : /u01/em12/core/18.104.22.168.0/cfgtoollogs/opatch/17591700_Mar_17_2014_12_03_05/apply2014-03-17_12-03-05PM_1.log
Applying interim patch '17591700' to OH '/u01/em12/core/22.214.171.124.0'
Verifying environment and performing prerequisite checks...
Patch 17591700: Optional component(s) missing : [ oracle.dbjava.jdbc, 126.96.36.199.0 ]
Interim patch 17591700 is a superset of the patch(es) [ 16087066 ] in the Oracle Home
OPatch will roll back the subset patches and apply the given patch.
All checks passed.
Backing up files...
Rolling back interim patch '16087066' from OH '/u01/em12/core/188.8.131.52.0'
Patching component oracle.dbjava.ic, 184.108.40.206.0...
Updating jar file "/u01/em12/core/220.127.116.11.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/18.104.22.168.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/aq/AQNotificationEvent$EventType.class"
Updating jar file "/u01/em12/core/22.214.171.124.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/126.96.36.199.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/aq/AQNotificationEvent.class"
Updating jar file "/u01/em12/core/188.8.131.52.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/184.108.40.206.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/dcn/DatabaseChangeEvent$AdditionalEventType.class"
Updating jar file "/u01/em12/core/220.127.116.11.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/18.104.22.168.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/dcn/DatabaseChangeEvent$EventType.class"
Updating jar file "/u01/em12/core/22.214.171.124.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/126.96.36.199.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/dcn/DatabaseChangeEvent.class"
Updating jar file "/u01/em12/core/188.8.131.52.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/184.108.40.206.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/NTFAQEvent.class"
Updating jar file "/u01/em12/core/220.127.116.11.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/18.104.22.168.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/NTFConnection.class"
Updating jar file "/u01/em12/core/22.214.171.124.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/126.96.36.199.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/NTFDCNEvent.class"
Updating jar file "/u01/em12/core/188.8.131.52.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/184.108.40.206.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/NTFManager.class"
Updating jar file "/u01/em12/core/220.127.116.11.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/18.104.22.168.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/T4CConnection.class"
Updating jar file "/u01/em12/core/22.214.171.124.0/jdbc/lib/ojdbc6.jar" with "/u01/em12/core/126.96.36.199.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc6.jar/oracle/jdbc/driver/T4CTTIokpn.class"
Updating jar file "/u01/em12/core/188.8.131.52.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/184.108.40.206.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/aq/AQNotificationEvent$EventType.class"
Updating jar file "/u01/em12/core/220.127.116.11.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/18.104.22.168.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/aq/AQNotificationEvent.class"
Updating jar file "/u01/em12/core/22.214.171.124.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/126.96.36.199.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/dcn/DatabaseChangeEvent$AdditionalEventType.class"
Updating jar file "/u01/em12/core/188.8.131.52.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/184.108.40.206.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/dcn/DatabaseChangeEvent$EventType.class"
Updating jar file "/u01/em12/core/220.127.116.11.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/18.104.22.168.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/dcn/DatabaseChangeEvent.class"
Updating jar file "/u01/em12/core/22.214.171.124.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/126.96.36.199.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/NTFAQEvent.class"
Updating jar file "/u01/em12/core/188.8.131.52.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/184.108.40.206.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/NTFConnection.class"
Updating jar file "/u01/em12/core/220.127.116.11.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/18.104.22.168.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/NTFDCNEvent.class"
Updating jar file "/u01/em12/core/22.214.171.124.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/126.96.36.199.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/NTFManager.class"
Updating jar file "/u01/em12/core/188.8.131.52.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/184.108.40.206.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/T4CConnection.class"
Updating jar file "/u01/em12/core/220.127.116.11.0/jdbc/lib/ojdbc5.jar" with "/u01/em12/core/18.104.22.168.0/.patch_storage/16087066_Feb_4_2013_04_52_18/files//jdbc/lib/ojdbc5.jar/oracle/jdbc/driver/T4CTTIokpn.class"
RollbackSession removing interim patch '16087066' from inventory
OPatch back to application of the patch '17591700' after auto-rollback.
Patching component oracle.dbjava.ic, 22.214.171.124.0...
Verifying the update...
Patch 17591700 successfully applied
Log file location: /u01/em12/core/126.96.36.199.0/cfgtoollogs/opatch/17591700_Mar_17_2014_12_03_05/apply2014-03-17_12-03-05PM_1.log
$ /u01/em12/agent_inst/bin/emctl start agent
Oracle Enterprise Manager Cloud Control 12c Release 3
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
Starting agent ............. started.
The above step completes the process of installing patch 17591700 to the 188.8.131.52 agent.
The Italian National Institute of Astrophysics (INAF) has selected Oracle to store, analyze and manage scientific data generated from the European Space Agency's Gaia mission. The mission sets out to provide in-depth 3-D mapping of the Milky Way galaxy over the course of the next 5 years. An estimated 1 petabyte of astronomical data (equivalent to 1 million gigabytes) will be collected and stored in Oracle Database with Oracle Enterprise Manager entrusted to manage the system.
The goal of the Gaia mission will give researchers a better understanding into how the Milky Way was formed and how it has evolved over time. According to Roberto Morbidelli, Scientific Operation Manager at INAF, "Our activity within the Gaia mission will provide a huge volume of information, a very precious heritage of astronomical data that will have to be stored for the whole 21st century and beyond. Oracle has demonstrated in other research contexts that it would be the ideal technological partner to manage scientific projects of this kind of size. Thus we are sure that it will be a successful choice for INAF too. Oracle has been selected for its technology’s reliability, scalability, availability and the appropriate technological evolution planned in the next years; also key was the competence showed by Oracle experts in the development of features useful to our research.”
Oracle Enterprise Manager will be deployed to help manage the multiple Oracle Database instances and Oracle Real Application Clusters. Oracle Enterprise Manager will be used to ensure reliable access to Gaia mission data, allowing for numerous third-party applications and systems that control and verify the correct functioning of satellites and astronomical instruments.
“We are proud to offer our technology to the Gaia mission, an international research project that is of both major importance and high ambition,” said Xavier Verhaeghe, Vice President, Technology & Big Data Oracle EMEA. “INAF’s choice is another confirmation of Oracle’s ability to easily manage the extreme challenges involved in processing petabytes of Big Data."
As Product Manager for Oracle Enterprise Manager, one question that is often being asked to me is how much is the upgrade downtime and how it can be reduced?
One easy way to reduce the downtime while doing patch set upgrades is to perform Software only upgrade and then shutdown the existing OMS for the upgrade. This approach will not completely eliminate the downtime but reduce it to a great extent.
When I mention patch set upgrade, we cover following upgrade paths:
a) 184.108.40.206 (with Bundle Patches 1) to 220.127.116.11/ 18.104.22.168
b) 22.214.171.124 to 126.96.36.199
Following table compares the steps required for regular installation (OUI) and software only installation.
As you may notices from the steps listed above, regular OUI upgrade requires stopping OMS before invoking runInstaller and keeping it down until the upgrade is complete. On the other hand Software only upgrade first copies the bits and sets up the environment before stopping OMS, thus reducing the upgrade downtime.
Next comes Agent upgrade. While we recommend Agent Upgrade Console (AUC) to upgrade agents from 188.8.131.52 (with bundle patch1) /12.0.1.02 to 184.108.40.206, sometimes it’s not clear what happens during the Agent upgrade and when is the actual downtime . So here are high level steps describing the complete process:
The actual downtime while doing the agent upgrade is on step9 where we shut down your old agent. When the agent is in blackout from step 1 to 8 it still collect’s all the monitoring data so there is no loss.
More Information: It is recommended to go through the below checklist notes before starting your upgrade
MOS note 1568143.1 - EM 12c R3: Checklist for Upgrading Enterprise Manager Cloud Control from Version 12.1.0.x to 220.127.116.11
MOS Note 1569883.1 EM 12c R3: Checklist for Upgrading Management Agents Version 12.1.0.x to 18.104.22.168
EM 22.214.171.124 Install and Upgrade collateral page(PPT,Recorded demo,Whitepapers) on OTN:http://www.oracle.com/technetwork/oem/install-upgrade/index.html
Oracle recently announced new management capabilities for Oracle Database 12c, providing customers with even more enhancements to improve productivity and manageability. The new Oracle Enterprise Manager 12c features are supported out-of-the-box with Oracle Database 12c. So whether you want to take advantage of the new Data Redaction capabilities at the security layer, or whether you want to take a look at some of the heat map capabilities in our Information Lifecycle Management or leverage the new performance management features, such as, Database Operations Monitoring or Enhanced Real-Time ADDM, you can use Oracle Enterprise Manager 12c to manage them all.
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 the Cloud.
Here is a quick summary of all the new Oracle Enterprise Manager 12c capabilities for Oracle Database 12c:
To learn more about all the latest capabilities, be sure to register for our upcoming webcast: Managing Oracle Database 12c with Oracle Enterprise Manager 12c.
Join 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.
As 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.
However, consolidation 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 cloud service.
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.
Schema as a Service at a Glance:
1. Setting up Platform as a Service Zones
2. Setting up Database Pools
3. Request Settings
5. Profiles and Service Templates
LEARN MORE:Product Info:
Gartner recently announced that Oracle Data Masking Pack, part of Oracle Enterprise Manager’s quality management and Oracle Database Security defense-in-depth solution, has been named a leader in the first Magic Quadrant for Data Masking Technology report.
Oracle Data Masking strengths highlighted in the report include:
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.
for Security and Compliance
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 customer data.
Oracle Data Masking continues to gain strong adoption, check out the latest customers to see how they are benefiting from the solution: