Wednesday Apr 02, 2014
Tuesday Apr 01, 2014
By Scott Mcneil-Oracle on Apr 01, 2014
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
Monday Mar 31, 2014
By Scott Mcneil-Oracle on Mar 31, 2014
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.
Friday Mar 28, 2014
By Scott Mcneil-Oracle on Mar 28, 2014
Great Resource for Learning Oracle Database 12c and Oracle Enterprise Manager 12c
The guide includes coverage of Oracle Diagnostics Pack and Oracle Tuning Pack features such as Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH) Analytics, SQL Tuning Advisor, Real-time SQL Monitoring and more. Download the PDF or HTML verision.
Thursday Mar 27, 2014
By Scott Mcneil-Oracle on Mar 27, 2014
Wednesday Mar 26, 2014
By Scott Mcneil-Oracle on Mar 26, 2014
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.
Tuesday Mar 25, 2014
By Scott Mcneil-Oracle on Mar 25, 2014
Friday Feb 14, 2014
By Scott Mcneil-Oracle on Feb 14, 2014
Accelerate Database Testing for Improved Agility and Cost Savings
Discover how SPA Quick Check helps to:
Friday Feb 07, 2014
By Scott Mcneil-Oracle on Feb 07, 2014
Thursday Jan 30, 2014
By Scott Mcneil-Oracle on Jan 30, 2014
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."
Thursday Nov 28, 2013
By Scott Mcneil-Oracle on Nov 28, 2013
Tuesday, December 3 , 2013
Oracle Enterprise Manager 12c Snap Clone allows administrators to create fully functional copies of databases using the copy-on-write capabilities of the underlying storage layer. Users can request databases from Oracle Enterprise Manager 12c's self-service portal and have them provisioned within minutes instead of hours while keeping storage needs to a minimum. Part of Oracle Enterprise Manager 12c Cloud Management Pack for Oracle Databases, Snap Clone can fundamentally improve the efficiency and agility of administrators and QA engineers while saving storage costs and other capital expenses.
Join us for this webcast to learn how Oracle Enterprise Manager 12c Snap Clone can help:
Wednesday Nov 13, 2013
By Scott Mcneil-Oracle on Nov 13, 2013
Thursday, November 21, 2013
Save Time and Costs, Reduce Complexity
Database as a service (DBaaS) offers a variety of benefits to help companies improve operations and move faster to the cloud. Using Oracle Multitenant—a new option for Oracle Database 12c featuring pluggable databases—and Oracle Enterprise Manager 12c, companies can make the most of those benefits.
Join us for the webcast and learn how Oracle technology can help:
Tuesday Nov 12, 2013
By Hari Srinivasan-Oracle on Nov 12, 2013
One of the most arduous processes in DB maintenance is upgrading Databases across major versions, especially for complex RAC Clusters.
With the release of Database Plug-in (126.96.36.199.0), EM12c Rel 3 (188.8.131.52.0) now supports automated upgrading of RAC Clusters in addition to Standalone Databases.
This automation includes:
- Upgrade of the complete Cluster across the nodes. ( Example: 184.108.40.206 CRS, ASM, RAC DB -> 220.127.116.11 or 18.104.22.168 GI, RAC DB)
- Best practices in tune with your operations, where you can automate upgrade in steps:
Step 1: Upgrade the Clusterware to Grid Infrastructure (Allowing you to wait, test and then move to DBs).
Step 2: Upgrade RAC DBs either separately or in group (Mass upgrade of RAC DB's in the cluster).
- Standard pre-requisite checks like Cluster Verification Utility (CVU) and RAC checks
- Division of Upgrade process into Non-downtime activities (like laying down the new Oracle Homes (OH), running checks) to Downtime Activities (like Upgrading Clusterware to GI, Upgrading RAC) there by lowering the downtime required.
- Ability to configure Back up and Restore options as a part of this upgrade process. You can choose to :
a. Take Backup via this process (either Guaranteed Restore Point (GRP) or RMAN)
b. Set the procedure to pause just before the upgrade step to allow you to take a custom backup
c. Ignore backup completely, if there are external mechanisms already in place.
High Level Steps:
- Select the Procedure "Upgrade Database" from Database Provisioning Home page.
- Choose the Target Type for upgrade and the Destination version
- Pick and choose the Cluster, it picks up the complete topology since the clusterware/GI isn't upgraded already
- Select the Gold Image of the destination version for deploying both the GI and RAC OHs
- Specify new OH patch, credentials, choose the Restore and Backup options, if required provide additional pre and post scripts
- Set the Break points in the procedure execution to isolate Downtime activities
- Submit and track the procedure's execution status.
The animation below captures the steps in the wizard. For step by step process and to understand the support matrix check this documentation link.
Explore the functionality!!
In the next blog, will talk about automating rolling Upgrades of Databases in Physical Standby Data Guard environment using Transient Logical Standby.
Monday Nov 04, 2013
Announcing: Oracle Enterprise Manager 12c Delivers Advanced Self-Service Automation for Oracle Database 12c Multitenant
By Scott Mcneil-Oracle on Nov 04, 2013
New Self-Service Driven Provisioning of Pluggable Databases
Today Oracle announced new capabilities that support managing the full lifecycle of pluggable database as a service in Oracle Enterprise Manager 12c Release 3 (22.214.171.124). 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.
This 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.
To understand how pluggable database as a service works, watch this quick demo:
Wednesday Aug 21, 2013
By Scott Mcneil-Oracle on Aug 21, 2013
Discover Oracle’s Next-Generation Database Management Solution
Don’t 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:
Only Oracle Enterprise Manager 12c offers customers maximum performance, enhanced automation, and total control for Oracle Database 12c.
Wednesday Aug 07, 2013
By Scott Mcneil-Oracle on Aug 07, 2013
Friday Aug 02, 2013
By Scott Mcneil-Oracle on Aug 02, 2013
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.
Thursday Apr 11, 2013
By Scott Mcneil-Oracle on Apr 11, 2013
Tuesday Mar 12, 2013
By Scott Mcneil-Oracle on Mar 12, 2013
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.
Friday Mar 08, 2013
By Scott Mcneil-Oracle on Mar 08, 2013
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:
Tuesday Mar 05, 2013
Webcast: New Cloud Management Plug-Ins Provide Enhanced Capabilities for Deploying and Managing Clouds
By Scott Mcneil-Oracle on Mar 05, 2013
Join 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 (TaaS).
Friday Feb 15, 2013
By Ankit G on Feb 15, 2013
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 (126.96.36.199) 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 (188.8.131.52). The new plug-ins have dependency on 184.108.40.206, and customer needs to be on minimum 220.127.116.11 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 18.104.22.168), 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 (22.214.171.124)", 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 (126.96.36.199), 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 (188.8.131.52), can choose to utilize Self Update to download/import and deploy the new Plug-in versions, using the self update feature in the product.
Enterprise Manager Certification Matrix available on My Oracle Support.
Tuesday Feb 12, 2013
By Scott Mcneil-Oracle on Feb 12, 2013
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.
Friday Feb 08, 2013
By Scott Mcneil-Oracle on Feb 08, 2013
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:
Wednesday Jan 30, 2013
By Scott Mcneil-Oracle on Jan 30, 2013
Read 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.
Tuesday Jan 29, 2013
By Scott Mcneil-Oracle on Jan 29, 2013
Join 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. Topics include:
Friday Jan 25, 2013
By Ankit G on Jan 25, 2013
Earlier this month (Jan 2013) we announced the GA of Enterprise Manager for Big Data Appliance (BDA) Plugin - 184.108.40.206.0
This 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 220.127.116.11, 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.
- Respond to warnings and incidents.
Thursday Jan 24, 2013
By Scott Mcneil-Oracle on Jan 24, 2013
Tuesday Jan 15, 2013
By Scott Mcneil-Oracle on Jan 15, 2013
Monday Nov 12, 2012
By Scott Mcneil-Oracle on Nov 12, 2012
Latest information and perspectives on Oracle Enterprise Manager and Oracle Management Cloud.
- Enterprise Manager 13c: What’s New in Database Lifecycle Management
- Oracle Enterprise Manager 13c: New and Exciting Features
- Oracle Enterprise Manager @ Oracle OpenWorld 2015
- Oracle OpenWorld Sneak Preview: Oracle’s Newest PaaS Offerings for IT Operations Management – Oracle Management Cloud
- Snap Cloning Databases on Exadata using Enterprise Manager
- Understanding Plans, Profiles and Policies in Enterprise Manager Ops Center
- New Enterprise Manager Release Allows Customers to Manage Their Hybrid Cloud from a Single Interface
- Data to collect when logging a Service Request on Enterprise Manager Ops Center
- Data Clone and Refresh (part 1)
- Vote for Oracle Enterprise Manager 12c