Friday Feb 07, 2014
Thursday Jan 30, 2014
By Scott McNeil 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."
Tuesday Sep 17, 2013
By Akanksha Sheoran Kaler on Sep 17, 2013
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) 188.8.131.52 (with Bundle Patches 1) to 184.108.40.206/ 220.127.116.11
b) 18.104.22.168 to 22.214.171.124
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 126.96.36.199 (with bundle patch1) /12.0.1.02 to 188.8.131.52, 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 184.108.40.206
MOS Note 1569883.1 EM 12c R3: Checklist for Upgrading Management Agents Version 12.1.0.x to 220.127.116.11
EM 18.104.22.168 Install and Upgrade collateral page(PPT,Recorded demo,Whitepapers) on OTN:http://www.oracle.com/technetwork/oem/install-upgrade/index.html
Friday Aug 02, 2013
By Scott McNeil 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.
Tuesday Mar 12, 2013
By Scott McNeil 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 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:
Friday Feb 08, 2013
By Scott McNeil 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:
Thursday Jan 24, 2013
By Scott McNeil on Jan 24, 2013
Thursday Sep 20, 2012
By Scott McNeil on Sep 20, 2012
Wednesday Jul 18, 2012
By AnkurGupta on Jul 18, 2012
Over last few months, the Oracle Enterprise Manager team has released Enterprise Manager 12c Bundle Patch1 (a.k.a. BP1) for Oracle Enterprise Manager Cloud Control 12c (EM 12c) on all the supported platforms (Customer announcement). BP1 is a mandatory patch because all future patches will assume the presence of this patch. BP1 includes several critical fixes. Therefore this patch touches almost all the components of Enterprise Manager and applying it on existing environment is a multi step process that can be tricky. From our recent experience of applying BP1 on an internal production demo site with over a thousand targets, we would like to share following tips and tricks.
1. Applying incremental Bundle Patch or using full install?
Unless you have an EM 12c running in production environments where you can’t afford to lose the existing management repository, it is highly recommended to re-install EM using the patched EM Base Platform 22.214.171.124 Full Installer (With BP1), instead of applying BP1. For instance, if you have a test or a “sandbox” environment even with substantial number of targets, it might be easier to reinstall EM environment instead of manually applying patches (including agent patches) and upgrading plug-ins. Note that reinstalling EM will require reinstallation of target agents as well. Therefore you’ll need to do careful consideration before choosing this option.
2. Plan it well
- Given that the BP1 process involves agent side changes like patching and plug-in upgrades, you might want to consider splitting the agent side changes into phases, especially in large sized environment. In such cases, it is critical to review the Compatibility Matrix and ensure that at no stage during the BP1 upgrade process, your environment is in an unsupported configuration.
- Never break the sequence of steps given in the BP1 application guide or you may risk your entire environment. For example -- as an admin, after upgrading the plug-ins on OMS, you may be tempted to upgrade plug-ins of agents as well even before patching the agent. As the documentation says -- resist the temptation to avoid issues while patching agents later.
- Keep sufficient free space for backup. It might be helpful to take keep multiple backups. See the next tip.
3. EM 12c Backup is critical
- Never underestimate the importance of environment backup during the BP1. It is must to backup your environment before any steps that involve change in repository data. e.g. OMS patching, plug-in upgrade on OMS, etc.
- Additionally it is recommended to take backup after every significant step to minimize rework in case of any failure. For instance in our environment a total of four backups were taken at following stages.
- Before applying BP1 on OMS
- After applying BP1 on OMS, JDeveloper, WSM
- Before upgrading plug-ins on OMS
- After upgrading first few plug-ins on OMS
4. Upgrade plug-ins in bulk using emcli
BP1 comes with the 126.96.36.199 release of plug-ins and it is highly recommended to upgrade plug-ins together with the application of BP1. In a typical environment you may need to upgrade more than 15 plug-ins. For some plug-ins, the upgrade process requires a restart of OMS(s) and therefore can take a good deal of time (almost fifteen minutes for single plug-in upgrade). Hence upgrading plug-ins one by one via the UI can be time consuming process requiring manual intervention after every few minutes.
Use EM command line ‘deploy_plugin_on_server’ to deploy multiple plug-ins in one go in an automated manner. Since multiple plug-ins are upgraded in single downtime window for OMS, it is a far more efficient process. In our environment, using command line we could upgrade eight plug-ins in under 30 minutes which otherwise would have taken more than two hours. Make sure to run the emcli in a pre-requisite check mode before doing the actual deployment such as shown in the screenshot below.
Also note that if your OMS is on Linux platform, you’ll need to apply one-off patch 13638422 after applying BP1 on the OMS to get the ‘deploy_plugin_on_server’ emcli verb. For BP1 on other platforms (e.g. Windows) this patch is included in BP1 itself.
5. From Linux OMS don’t push agents on other platforms without necessary patches
A very common use case is the deployment of agents on non-Linux platform from a Linux OMS with BP1. Since you have Windows/Solaris agent software (with BP1) available via self update, you might tend to assume that, all you need to do is simply push the Windows/Solaris agents from BP1 Linux OMS but that’s not the right way to do. You have to apply few patches on OMS and plug-ins before pushing the agent, follow the instructions from the Oracle® Enterprise Manager Bundle Patch 1 Application Guide.
6. Read the right documentation
Last but surely not the least, it is vital that you go through the Oracle® Enterprise Manager Bundle Patch 1 Application Guide, before you begin with the BP1 process. This guide provides step by step instructions for applying BP1 including pre-requisite checks, recommendations, and troubleshooting steps.
In addition to the documentation, we suggest to refer the following key resources published by Oracle.
- Recorded Webcast - Oracle Enterprise Manager Cloud Control 188.8.131.52 Bundle Patch1
- Presentation - Overview of Bundle Patch1 application for Enterprise Manager 12c
- My Oracle Support Note - Enterprise Manager Cloud Control 184.108.40.206 Bundle Patch 1 Known Issues [ID 1395640.1]
These few simple tips can make your experience with BP1 a lot smoother. In future entries, we’ll discuss the best practices for major updates for Oracle Enterprise Manager 12c as and when those are available.
Tuesday Mar 06, 2012
By Anand Akela on Mar 06, 2012
Oracle Enterprise Manager Ops Center allows you to update your Solaris systems with patches available from My Oracle Support (MOS).
Like always in life, there are multiple ways to perform a given task and the same is true for Ops Center.
Juergen Fleischer, Senior IT/Product Architect , Oracle Enterprise manager Ops center provided the content for this blog to guide you through different ways to perform Oracle Solaris patching depending on deployment scenarios.
Scenario 1 - Applying a single Patch to an Asset
Let's start with installing just a single patch to a system. To perform this task you would select the OS Asset and pick the action 'View/Modify Catalog' from the right hand side Actions panel.
From the pop-up screen, you can search for the patchid, see which revision is already installed and select a newer one if required.
Here is a MOS how-to document describing this in all detail:
Scenario 2 - Applying multiple patches to several systems
If you have to apply a list of patches to multiple systems every now and then, creating an Update Profile would be the best method, as once you have created the Profile it can be used many times ensuring the exact same patches in the list are applied each and every time.
Update Profiles are located in the 'Plan Management' section. Update Profiles can be used in two ways: either you select a single or a group of OS assets and pick the action 'New Update OS Job'. Or, you pick the Update Profile in the Plan Management section and select 'New Update OS Job'. The wizard will allow you to select one or more target assets or groups.
Here is a MOS how-to with all the details:
Scenario 3 - Regular Baseline Patching
For regular Baseline Patching 'Update Profiles' can be based on given patchsets which are made available by the Ops Center Knowledge Base (KB).
The KB offers two different patchsets, the monthly released Solaris Baselines (based on Oracle's internal EIS-DVD) and the current or archived versions of the "Recommended Patchset for Solaris". These are updated whenever a new critical patch gets released. Every quarter, one of these Recommended Patchsets for Solaris will be renamed as the 'Critical Patch Update' in line with standard Oracle practice. It's up to the Customer's patching policy and strategy to determine which patchsets should be used and how often they should be applied.
Scenario 4 - Latest & Greatest patchset
Finally, if required, Customers can select what is called "Latest & Greatest" patchset. These are all the latest available patches for all installed packages. To perform this task, use the 'Host Compliance Report' and tick the Security & Bug Fixes check box.
More details can be found in this blog entry
or in this MOS how-to document:
So far, we have talked about various scenarios around applying a single patch or multiple patches. These patches can be applied on a running system or by using LiveUpgrade (LU). LU allows creating Alternate Boot Environment (ABE), Synchronizing boot environments, Patching the ABE and then Activating the ABE.
For detailed examples and howto examples:
Before using LiveUpgrade, please verify that the latest LU-Patch (sparc: 121430, x86: 121431) is installed on the running system.
Furthermore, when payching zones always make use of the parallel zone patching feature, independent if using LU or not. Following blog entry describes this very well :
Thursday Feb 23, 2012
By Scott McNeil on Feb 23, 2012
In this month's Oracle Enterprise Manager 12c InDepth Newsletter, Leng Tan, VP of Development for Database Manageability, discusses some of the issues facing IT today. In the interview, Leng talks about the ways administrators can address and overcome these challenges using Oracle Enterprise Manager 12c Database Lifecycle Management solution. Be sure to read the article to learn more!
To get the latest issue of the Oracle Enterprise Manager 12c InDepth Newsletter, subscribe here.
Latest information and perspectives on Oracle Enterprise Manager.
- Fast Recovery Area for Archive Destination
- Focus on Oracle Applications Management at Collaborate14
- Monitoring Archive Area % Used on Cluster Databases
- WEBCAST: Accelerate Database Testing for Improved Agility
- Steps to Fast Track your Database Cloud implementation on Exadata
- VIDEO: Nationwide Deploys Database Applications 600% Faster
- Oracle Enterprise Manager Helps Manage Systems for Gaia Mission
- Oracle Enterprise Manager at Collaborate 14
- IOUG Oracle EM SIG Techcast: Managing Oracle Enterprise Manager 12c with Oracle Clusterware
- Oracle Enterprise Manager Snap Clone Webcast Replay and Slides