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
Thursday Feb 27, 2014
By Courtney Llamas-Oracle on Feb 27, 2014
If you are using Fast Recovery Area (FRA) for the archive destination and the destination is set to USE_DB_RECOVERY_FILE_DEST, you may notice that the Archive Area % Used metric does not trigger anymore. Instead you will see the Recovery Area % Used metric trigger when it hits a Warning threshold of 85% full, and Critical of 97% full. As this metric is controlled by the server side database thresholds it cannot be modified by Enterprise Manager (see MOS Note 428473.1 for more information). Thresholds of 85/97 are not sufficient for some of the larger, busier databases. This may not give you enough time to kickoff a backup and clear enough logs before the archiver hangs. If you need different thresholds, you can easily accomplish this by creating a Metric Extension (ME) and setting thresholds to your desired values. This blog will walk through an example of creating an ME to monitor archive on FRA destinations, for more information on ME's and how they can be used, refer to the Oracle Enterprise Manager Cloud Control Administrator's Guide.[Read More]
Tuesday Feb 18, 2014
By Courtney Llamas-Oracle on Feb 18, 2014
One of the most critical events to monitor on an Oracle Database is your archive area. If the archive area fills up, your database will halt until it can continue to archive the redo logs. If your archive destination is set to a file system, then the Archive Area % Used metric is often the best way to go. This metric allows you to monitor a particular file system for the percentage space that has been used. However, there are a couple of things to be aware of for this critical metric.
Cluster Database vs. Database Instance
You will notice in EM 12c, the Archive Area metric exists on both the Cluster Database and the Database Instance targets. The majority of Cluster Databases (RAC) are built against database best practices which indicate that the Archive destination should be shared read/write between all instances. The purpose for this is that in case of recovery, any instance can perform the recovery and has all necessary archive logs to do so. Monitoring this destination for a Cluster Database at the instance level caused duplicate alerts and notifications, as both instances would hit the Warning/Critical threshold for Archive Area % Used within minutes of each other. To eliminate duplicate notifications, the Archive Area % Used metric for Cluster Databases was introduced. This allows the archive destination to be monitored at a database level, much like tablespaces are monitored in a RAC database.
In the Database Instance (RAC Instance) target, you will notice the Archive Area % Used metric collection schedule is set to Disabled.
If you have a RAC database and you do not share archive destinations between instances, you will want to Disable the Cluster Database metric, and enable the Database Instance metric to ensure that each destination is monitored individually.
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:
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 (220.127.116.11). 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:
Thursday Aug 22, 2013
By Akanksha Sheoran Kaler on Aug 22, 2013
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) 18.104.22.168 (with Bundle Patches 1) to 22.214.171.124/ 126.96.36.199
b) 188.8.131.52 to 184.108.40.206
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 220.127.116.11 (with bundle patch1) /12.0.1.02 to 18.104.22.168, 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 22.214.171.124
MOS Note 1569883.1 EM 12c R3: Checklist for Upgrading Management Agents Version 12.1.0.x to 126.96.36.199
EM 188.8.131.52 Install and Upgrade collateral page(PPT,Recorded demo,Whitepapers) on OTN:http://www.oracle.com/technetwork/oem/install-upgrade/index.html
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).
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:
Friday Feb 01, 2013
By Courtney Llamas-Oracle on Feb 01, 2013
When planning and configuring your Oracle Enterprise Manager 12c implementation, you will have many infrastructure considerations. One of the most often discussed pieces is the network ports that are used and how to configure load balancers, firewalls and ACLs for communication.
This blog post will help identify the typical default port and range for each component, how to identify it and how to modify the port usage.[Read More]
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:
Thursday Jan 24, 2013
By Scott Mcneil-Oracle on Jan 24, 2013
Tuesday Jan 15, 2013
By Scott Mcneil-Oracle on Jan 15, 2013
Latest information and perspectives on Oracle Enterprise Manager and Oracle Management Cloud.
- 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
- EM Compliance ‘Required Data Available’ flag – Understanding and Troubleshooting
- Test Drive Oracle’s Application Platform as a Service Solution