Friday Mar 16, 2012
Oracle Enterprise Manager content at Collaborate 12 - the only user-driven and user-run Oracle conference
By Anand Akela on Mar 16, 2012
From April 22-26, 2012, Oracle takes Las Vegas. Thousands of Oracle professionals will descend upon the Mandalay Bay Convention Center for a weeks worth of education sessions, networking opportunities and more, at the only user-driven and user-run Oracle conference - COLLABORATE 12.
This is one of the best opportunities for you to learn more about Oracle technology including Oracle Enterprise Manager. Here is a summary of an impressive line-up of Oracle Enterprise Manager related content at COLLABORATE 12.
- Stability in Real World with SQL Plan Management
- Upgrading to Oracle Enterprise Manager 12c - Best Practices
- Making OEM Sing and Dance with EMCLI
- Oracle Real Application Testing: A look under the hood
- Optimizing Oracle E-Business Suite on Exadata
- Experiences with OracleVM 3 and Grid Control in an Oracle BIEE environment.
- Right Cloud-- How to Avoid the False Cloud by using Oracle Technologies
- Forgetting something? Standarize your database monitoring environment with Enterprise Manager 11g
- Implementing E-Business Suite R12 in a Federal Cloud - Lessons Learned
- Cloud Computing Boot Camp: New DBA Features in Oracle Enterprise Manager Cloud Control 12c
- Oracle Enterprise Manager 12c, Whats Changed, Whats New?
- Monitoring a WebCenter Content Deployment with Enterprise Manager
- Enterprise Manager 12c Cloud Control: New Features and Best Practices (for IOUG registrants only)
- Roadmap Session: Total Cloud Control with Oracle Enterprise Manager 12c
- Real World Performance (complimentary for IOUG registrants only)
- Database-as-a-Service: Enterprise Cloud in Three Simple Steps
- Bullet-proof Your Enterprise, SOA & Cloud Investments Using Oracle Enterprise Gateway
- What’s New for Oracle WebLogic Management: Capabilities that Scripting Cannot Provide
- Exadata Boot Camp: Complete Oracle Exadata Management with Oracle Enterprise Manager
Stay connected with Oracle Enterprise Manager :Twitter | Facebook | YouTube | Linkedin | Newsletter
Thursday Mar 08, 2012
By Anand Akela on Mar 08, 2012
IT professionals are excited by the technical advantages of cloud computing, and Line of Business managers look to the cloud as a driver of business growth, efficiency, and productivity. By transforming IT into a business-centric provider of services that users can access from anywhere, Oracle Enterprise Manager 12c helps you build a more agile, efficient, and innovative enterprise.
For more information, please go to Oracle Enterprise Manager web page or follow us at :Twitter | Facebook | YouTube | Linkedin | Newsletter
Wednesday Mar 07, 2012
By user810030 on Mar 07, 2012
We'd like to take this opportunity to congratulate Acolade Consulting in becoming one of the first within the Oracle PartnerNetwork (OPN) to achieve the Oracle Enterprise Manager Application Quality Management (Oracle EM AQM) OPN Specialization. OPN Specialized Partners are differentiated in the marketplace, gaining a competitive edge and access to broader and larger solution opportunities
Rajesh Krishnan, Practice Director, Acolade Consulting with Patricia Nance,
GM Oracle Alliances and Channels at a recent partner recognizition event in Sydney.
Partner organizations achieving Oracle EM AQM specialization have demonstrated proficiency in providing Application Testing and Quality Management Solution and Services with Oracle technology. Customers can locate Partners proficient with Oracle EM AQM in the OPN Solutions Catalog to help them test packaged, Web, and SOA applications and ensure quality, scalability, and availability of applications and their infrastructure.
The Oracle EM AQM solution consists of these distinct functional capabilities:
- Oracle Application Testing Suite – comprised of Oracle Test Manager, Functional Testing for automation testing, and Load Testing for stress, volume and performance testing
- Oracle Real Application Testing – for maintaining application quality when there is a infrastructure change or database upgrade.
- Oracle Application Replay - for generating production workloads against web and Oracle applications under test, which are identical to production.
- Oracle Data Masking – for maintaining high level of data security by scrambling test data and maintaining end to end data integrity
Utilizing the Oracle EM AQM Solution, Partners can help customers manage their entire quality assurance (QA) process, including defining test requirements, creating and executing automated and manual test cases, tracking defects, performing load tests and database tests.
And as always, Stay Connected:
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 :
Friday Mar 02, 2012
Application Testing in the Cloud Made Easy - Questions and Answers Series from the Oracle Enterprise Management Online Forum
By user810030 on Mar 02, 2012
- Test starter kit for Oracle’s Siebel CRM applications. This provides you pre-built scripts for functional and load testing for easier and more efficient testing for your Siebel CRM implementations. This complements our EBS test starter kits already available.
- Deeper integration with Oracle Enterprise Manager’s middleware and database diagnostics such as ADDM and AWR reports that will improve testing efficiency and productivity by enabling testers to detect performance bottlenecks faster and with less effort.
- Finally, we support structured, business-driven testing based on testing industry most widely adopted methodology, TMap. TMap is industry leading risk-based approach for structured software testing that helps you manage and standardize test processes.
Q. Do you support synthetic workloads for load testing?
A. Yes. Oracle Load Testing is a load/performance test tool for synthetic load testing. Oracle Load Testing can test any web based application as well as Oracle packaged applications like Oracle EBS, Siebel, Oracle Fusion applications, JD Edwards, Peoplesoft, Hyperion and others. It is also possible to SOA/Web services based test or synthtetic database testing for Oracle databases
Q. Does the data masking solution work for non-Oracle Databases?
Q. Can Sensitive Data Discovery be customized for my own data structures?
A. If it is in a supported oracle database then yes.
A. All current supported DB are supported for subsetting, We do support 10g R2 as well. There is plan to support 9i R2 but only in clone then subset and not inline subset.
A. All http and nca protocol (forms) are supported.
A. You can find more information about the automatic script generation for ATS /Oracle Load Testing in the documentation in your installation directory of ATS ([Install directory]/docs/en) OpenScriptUserGuide.pdf - Section 3.2.7 for RUEI In case you have not installed ATS, you can download the documentation from this location: http://download.oracle.com/otn/nt/apptesting/oats-docs-9.31.0036.zip
A. The testing accelerators for Oracle Load Testing or Oracle Functional Testing supports: EBS 11i & R12, Siebel 7.7 or higher. It also support any version of Oracle Fusion Applications
A. All current supported DB are supported for sub setting, We do support 10g R2 as well. There is plan to support 9i R2 but only in clone then subset and not inline subset.
A. 126.96.36.199.0 and above currently
A. You cannot select your own protocols.
A. We will not maintain 100 % cardinality but we will be close. and We an additional check if masking is introducing change in execution plans.
A. It depends in what you are trying to archive with your testing. If you have infrastructure updates only, meaning database or application server changes, then Application Replay is a really good solution for you, but if you have changes in your application, you should use Application Testing Suite
Thursday Mar 01, 2012
Sushil Kumar, VP,Product Strategy and Business development,Oracle shares highlights of new Oracle Enterprise Manager 12c update
By Anand Akela on Mar 01, 2012
Yesterday ( Feb. 29, 2012), Oracle announced the Oracle Enterprise Manager 12c Bundle patch 1 and 188.8.131.52 Plug-in updates. The new "Bundle Patch" contains numerous bug fixes, performance improvements and new features to improve Oracle Enterprise Manager Cloud Control 12c customer experience .
Sushil Kumar, VP, Product
Strategy and Business development, Oracle Enterprise Manager, shared the highlights of the new
"Bundle Patch" with me earlier today. In this blog, I captured my discussion with Sushil.
The new “Bundle Patch” is a pretty significant update to Oracle Enterprise Manager 12c bits released at Oracle Open World in October, 2012. It contains over 3000 bug fixes and includes some brand new functionality such as Weblogic and Fusion Apps Patching, Exadata out of place patching, etc. We recommend customers, who are considering to go live with EM 12c in production in the next few months, to pick up this mandatory update.
Even though we are calling this update a "Bundle Patch", an updated Enterprise Manager Base Platform Full Installer is made available for download on Oracle Technology Network (OTN). Any customer who downloads the 12c bit as of February 29, 2012, will automatically get these updates as a part of the base install. In another words, if you download the EM 12c product by clicking on “for Linux x86 (64 bit) (With Bundle Patch)” link from the OTN Download center (see the screen shot below) and do a fresh install, you will have all the updates required and no additional patches need to be applied to get these updates.
If you have not already discovered a large number of targets, defined admin groups and monitoring templates or defined compliance policies and rules, etc. with previously released Oracle Enterprise Manager 12c bit, then a fresh install with the updated installer is the way to go. The option of “patching” a site running on previously released EM bits exists , but, it may be worth the pain only if you have already put in a lot of time and effort setting up your EM 12c environment based on the previously released bits.
We are working closely with the early adopter customers of Oracle Enterprise Manager 12c to make sure that they can update in a smoothest possible manner. If you were not part of the EM 12c early adopter program, please work with your Oracle support .
The other exciting announcement with the release of EM 12c iPhone app that Scott blogged about yesterday. This is in response to the strong customer demand to make EM accessible from mobile devices. The new app primarily exposes the incident management functionality but we will add more features to it moving forward.
Finally, we want to highlight that the only supported version of Oracle BI Publisher with EM 12c is 184.108.40.206 and it is linked from the EM 12c download page. Please do not use the latest version 220.127.116.11 of BI publisher with EM 12c since that may render your environment unusable. We do have plans to support 18.104.22.168 in the near future, but, as of now, please download the BI publisher version that is linked off the EM 12c download page on OTN.
Please share your feedback by providing your comments on this blog, using #em12c tag on twitter and other social media channel following the links below.
By Jonathan Klein on Mar 01, 2012
To start with, the agent maintains detailed statistics around each operation being performed and can report on these automatically in a top 'N' style report hourly. This is called the Top Metric Report and can be enabled via the property topMetricReporter=true in the emd.properties file. Once enabled, reports are automatically produced hourly and can also be requested on demand. Reports are maintained for a period of 24 hours.
The reports are stored in xml inside of the agent state home (available in $EMSTATEDIR/sysman/emd/topMetrics). They are also available from the agent metric browser, where a report can be requested to be generated as well.
The report provides detailed information regarding the top consuming cpu targets and/or metrics enabling customers to decide if collections are occurring too frequently. Customers can then modify the Oracle default collection frequencies.
The agent home page in the enterprise manager console has been redesigned to provide specific performance information about the agent. There are three main panels to be review.
The first is the performance panel. It contains 3 key performance indicators (KPI's) of the agent. They are:
Upload transfer time for 1KB measured in milliseconds (this metric is the graphed values)
Time spent on average per collection as a percentage of the declared collection interval
Agent heartbeat round trip time measured in milliseconds.
An example is shown below.
The upload transfer time is simply a measure of how long on average its taking to perform the round trip between the agent and loading sub-system. The time includes not only the http communication time but the time to load into the repository.
The % of collection measures on average how long metrics are taking to collect as a percentage of their declared interval. For instance, if a metric takes 1 second to collect and its interval was to be collected every 30 seconds, then the percentage is 1/30 or about 3%. The rolled up number is computed across all metrics running and is re-evaluated by the agent every minute. The expectation is that the overall percentage will be low.If targets experience issues causing collections to take longer or the agent itself is not performing well, the expectation is that the percentage would increase.
Finally the heartbeat round trip is a measure similar to the upload in concept – a measurement of how long it's taking to send a certain amount of data; but given that these heartbeats (or pings) are typically constant in size, the measure is just the total round trip time.
If either the upload or ping times are increasing, then this could be an indicator of a network performance issue or the oracle management server itself experiencing some performance issue.
The second panel is the usage panel. It also contains 3 KPI's:
Number of requests made by the console of the agent (called Dispatched Actions) (this is the graphed data set)
Number of collections scheduled to be run for the next hour.
Number of jobs currently running on the agent
The usage panel reflects work being requested of the agent, either from console actions (real-time metric requests for example or jobs being submitted) as well as the work queue of the agent (i.e. the number of collections to be run for the next hour).
The final panel is the resource panel. There are 5 KPI's here:
percentage of the java heap in use (graphed)
approximate cpu usage (graphed)
current megabytes of the java heap in use
the maximum number of megabytes of the java heap used
a rolling load average of the cpu usage
First, let me explain the java heap statistics. The heap is sized to a specified maximum. The percentage of the heap used is a measure against that maximum. Current represents the current amount used and the maximum is the highest recorded value (not the absolute declared maximum). For instance, if the declared maximum is 100MB and the maximum ever observed is 80MB, then at some point in time 80% of the available heap was in use. Its fully expected that the percentage of the heap would follow the classic 'saw-tooth' pattern seen below.Java virtual machines allocate memory from the heap and then run garbage collection (GC) to free up space. If the trend line is flat, then no leaks would be evident. Its recommended that the maximum ever observed is no greater than 95% of the declared maximum, as that would potentially lead to either excessive GC or out of memory exceptions.
The cpu statistics are a representation of the current cpu being used and the 'load average' – a rolling weighted average of the last 15 minutes of cpu consumed.
My next blog will continue on the theme of using additional services to diagnosis current and/or potential issues with the agent.
Latest information and perspectives on Oracle Enterprise Manager.
- RMAN Backups using Cloud Control
- Consolidated Database Replay: Playing Nice Together
- Webcast: Database Cloning in Minutes using Oracle Enterprise Manager 12c Database as a Service Snap Clone
- Cloud Odyssey in London
- Managing Pluggable Database as a Service: Questions and Answers
- Munhowen to Reduce Maintenance Costs and TCO by More Than 50 Percent
- Oracle Database 2 Day + Performance Tuning Guide
- Cisco Improves Service Quality with Self-Managing Automation
- Infographic: Database Manageability—Getting Ahead of the Curve
- Demo: Setting Up a Database Cloud Self Service Portal for Data Cloning Using Snap Clone