The Hunger Site

Wednesday, March 27, 2013

Great Grassroots Charity in India


Dear Friends,

This is a great grassroots charity in India. Please Help.

They build an entire bore well for only a few thousand rupees. 


This is a photo of a well the Enterprise Manager Blog sponsored:



Please write directly to Mr. Rao below if you wish to give water to the thirsty poor people. God Bless.

Regards,

Porus.

Contact Details:

N.Srinivasa Rao
Executive Secretary
Chaitanya Educational and Rural Development Society
H.No: 3-68/1, 5th Lane
Pandaripuram
Chilakaluripet - 522616
Guntur District
A.P, INDIA

Ph.No. (Off) : +91-8647-252333


Wednesday, March 13, 2013

March 2013 Issue of EM Newsletter

My Enterprise Manager Cloud Control 12c book has been mentioned prominently in the March 2013 issue of the Enterprise Manager Newsletter from Oracle, which goes out to thousands of subscribers:


Oracle Information InDepth: Oracle Enterprise Manager Edition

Regards,

Porus.

Monday, February 25, 2013

New Release of Oracle Enterprise Manager Introduces Key Enhancements for Deploying and Managing Clouds


By Sudip Datta on Feb 24, 2013


It has been a little more than a year, since we released our first cloud management features as a part of Oracle Enterprise Manager 12c. As customers started adopting our solution for a broad spectrum of workloads including production, QA, and development needs, we gained invaluable experience into the various use cases and requirements. Based on that experience, Oracle has released new and updated Management Plug-ins that precisely address the above requirements, ultimately leading to faster time-to-market for IT services delivery. In addition to providing enhanced cloud management support, the plug-ins extend Enterprise Manager'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). See "New Plug-in Features" below for additional details.
NEW PLUG-IN FEATURES:

+ Database as a Service (DBaaS):

    A sophisticated Database as a Service solution needs to cater to a variety of use cases:
•    A developer or a project owner requiring a new database service  with or without seed data
•    QA requiring a full database refresh for intense load testing
•    QA requiring to create multiple clones for functional testing on subset of data

The current release of Oracle Enterprise Manager Cloud Control 12c offers new capabilities and support for managing database cloud services in all the above cases. It comes with out-of-box capabilities such as schema-as-a-service for extreme database consolidation and database cloning through Snap Clone or RMAN Backups. These capabilities provide an optimum utilization of development and database resources, giving customers more flexibility and control in managing the database lifecycle.

While some applications need dedicated databases, small home-grown applications can often share the database instance with other applications. Schema as a Service allows DBAs to consolidate multiple applications in the same database and offer logical slices of database to the end-users such as developers, thereby preventing database sprawl. They can enforce certain performance guarantee to these services by leveraging database Resource Manager, which prevents a particular user over-consuming the underlying compute resources.  End-users can therefore request schema services from the self-service application without stepping on one another. Schema as a Service significantly reduces the administrative and maintenance overhead since only a limited number of such databases need to be managed and patched.

Cloning databases got significantly easier with the new plug-in. A new feature called “Snap Clone” really makes it snappy (terabytes of data can be cloned in a matter of minutes). The feature helps clone a database by leveraging the underlying “Copy on Write” technology offered by storage technologies, such as Netapp and ZFS Storage Appliance. DBAs can set up a “test master” database by refreshing a production database and mark the “test master” as the source of functional clones. Self-service users can create multiple copies  of the test-master in minutes without consuming additional space beyond what’s needed to make localized updates. This can be really beneficial for applications where the testing is primarily read-only and is limited to a subset of the data. Users can also take backups (snapshots) of their database and “time travel” across snapshots to restore the database to an earlier incarnation in a matter of minutes.

For more involved testing, such as testing production loads with lots of updates, Oracle Enterprise Manager also supports a full clone using the RMAN technology.

The following picture highlights the various use cases of DBaaS that Oracle Enterprise Manager addresses. While each of these have specific applicability, Oracle Enterprise Manager handles all these use cases comprehensively.
+ Infrastructure as a Service (IaaS): Oracle Enterprise Manager Cloud Control 12c has added support for building and managing Infrastructure as a Service clouds based on the latest Oracle VM 3.2.1 release. The updated kernel and enhanced storage management features in Oracle VM 3.2.1 make it an ideal foundation for building a secure, scalable, enterprise-class infrastructure cloud. The newly released Oracle Enterprise Manager Management Plug-ins for Oracle Virtualization and Oracle Cloud provide comprehensive support for setting up the cloud infrastructure, deploying Oracle virtual assemblies and Oracle VM templates, and monitoring and managing the health of the cloud.
+ Testing as a Service (TaaS): Any enterprise application needs extensive testing before changes are rolled into production. Testing is a time-consuming process, can take weeks owing to delays in provisioning the full application stack to run the test on. QA is often left waiting on IT to provide the infrastructure and platform and sometimes this wait itself can account for 50% of the total testing cycle. Currently, no integrated solution exists that handle the provisioning and testing phases of the overall testing process leading to significant process delays and poor efficiency.

Oracle Enterprise Manager 12c introduces Testing as a Service, a new cloud platform for delivering automated application testing services. A self-service solution designed for private clouds, TaaS orchestrates the testing process end-to-end by automating provisioning of complete test labs (applications, test tools and assets comprising scripts and scenarios), execution of load and functional tests and rich application monitoring and diagnostics. It also includes a sophisticated chargeback facility and the ability to perform deeper diagnostics in context of testing.

TaaS makes it possible to significantly reduce testing time and costs without compromising quality, and enables organizations to be more agile in delivering critical business applications. One can find more details on TaaS here.


Oracle Enterprise Manager’s cloud management features are also enabled through a set of powerful RESTful APIs, which are summarized in this presentation. These APIs can be consumed from custom or 3rd party orchestration frameworks. In the new release, one can also orchestrate these APIs using an Oracle Enterprise manager provided framework called Blueprints. Using Blueprints, one can orchestrate the provisioning of a multi-layered application (such as the one shown below). One can download the documentation and sample code for the blueprints from here.




+ New Management Plug-Ins:  The following new and updated plug-Ins are now available as part of this release. In addition to providing new and enhanced functionality as mentioned above, the plug-ins incorporate numerous bug fixes.

Plug-In Name / Version
*Enterprise Manager for Oracle Database (DB) 12.1.0.3 (new)
*Enterprise Manager for Oracle Virtualization (VT) 12.1.0.4 (new)
*Enterprise Manager Storage Management Framework (SMF) 12.1.0.1 (new)
*Enterprise Manager for Oracle Cloud (SSA) 12.1.0.5 (new)


Read More:
* New book: Building and Managing a Cloud Using Oracle Enterprise Manager 12c (Oracle Press)

*Cloud Management page on OTN

*Enterprise Manager 12c: Cloud Management Pack for DB Datasheet

*Enterprise Manager 12c: The Nerve Center of Oracle Cloud Technical White Paper

Thursday, January 31, 2013

Good Feedback


Good Feedback on my book from a reader in the USA:
"I must  mention that this is THE book I have ever read and digested in the field of cloud control through Oracle Enterprise Manager, I am very impressed how categorically  it has explained the core details."
Thanks Friend.
http://www.packtpub.com/oracle-enterprise-manager-12c-cloud-control/book



Thursday, January 17, 2013

Answers to Your Common Database Performance Questions



An Interview with Oracle Database Manageability Expert, Deba Chatterjee
Throughout the year we hear from lots of customers and get many questions about managing Oracle Database. In this blog, I thought I would try and provide some answers to common diagnostics and tuning questions with the help of our product manager and residence expert for Oracle Database Manageability, Deba Chatterjee. Deba has a wealth of database performance tuning experience both inside and outside of Oracle managing large data warehouses. Deba is responsible for Oracle Diagnostics Pack for Database and Oracle Tuning Pack for Database. I recently sat down with Deba and had a chat about database manageability.
Scott McNeil: Deba, we get many people asking questions about database performance—many still don't know about all the deep diagnostics capabilities Oracle Enterprise Manager 12c has to offer for Oracle Database. Capabilities such as; Compare Period ADDM, Real-Time ADDM, Active Session History (ASH) Analytics Real-Time SQL Monitoring, using Metric Extensions, and SQL Tuning Advisor—how do customers get all these capabilities for their database?
Deba Chatterjee: We recently ran a webcast: Maximize Oracle Database Performance with Oracle Enterprise Manager 12c: Top 10 Tips and Tricks that explains how many of these features work. I highly recommend people watch the webcast to get a better understanding of the capabilities you mentioned. But the short answer is: for Compare Period ADDM, Real-Time ADDM, Metric Extensions you need to license Oracle Enterprise Manager 12c Diagnostics Pack for Database. For Real-Time SQL Monitoring, SQL Tuning Advisor, you will need the Oracle Tuning Pack for Database.
Scott McNeil: Another question customers repeatedly ask is around Cloud Control and Database Control. Deba, can you explain the difference between Oracle Enterprise Manager Cloud Control 12c (formerly Grid Control) and Database Control.
Deba Chatterjee: Although they belong to the same family of products there is a fundamental difference between the two. Database Control can be used to manage only a single database with which it has been configured, while Oracle Enterprise Manager Cloud Control 12c allows you to manage all your databases under the same centralized management console. Plus Cloud Control lets you manage not only all your databases but your entire application and technology stack too, whether it's in a private cloud or in a traditional environment.
How do you modify the Metric Value History retention in Enterprise Manager? For example; Enterprise Manager only shows the last 7 days, how do you display longer than 7 days?
Deba Chatterjee: There are various retention times based on the type of metric data:
  • Raw metric data: default retention time is 7 days
  • Hourly aggregated metric data: default retention is 31 days
  • Daily aggregated metric data: default retention is 12 months
Refer to the documentation here, if you want to change the default retention time.
For Compare Period ADDM, how do you relate that in the context of system load?
Deba Chatterjee: In the resource usage tab, you can check the system CPU, Memory, I/O and interconnect (for RAC databases) utilizations across the 2 comparison periods in the same database.
Does Compare Period ADDM take into account the average read and average write in order to identify why the variance is happening in performance?
Deba Chatterjee: Compare Period ADDM uses database time to compare the performance across two periods. It does not compare based on average read or write times.
Does Enterprise Manager have the ability to create customized performance graphs? For example; can you create a graph for CPU usage in the last 24 hours on a given Host?
Deba Chatterjee: This is possible through the information publisher or BI publisher reports. As for the CPU usage, the chart is available out-of-the box in the target page for hosts.
How do you connect to the database itself when it’s hung and won't allow any extra connections? Do you use command line? Can you use ADDM even though the database is hung?
Deba Chatterjee: When the database is hung, you can connect to it using the diagnostic connection mode in Real-Time ADDM. The agent that is used to monitor the database makes the connection. No, command line is used. You have to use Real-Time ADDM for the connection.
Is Oracle Enterprise Manager 12c compatible with older versions of the database?
Deba Chatterjee: You can use Oracle Enterprise Manager 12c to monitor Oracle Database versions: 9.2.0.8, 10.1.0.5, 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, 11.2.0.2, and 11.2.0.3.
Is SQL Performance Analyzer part of Oracle Database 11g or do you need to use Oracle Enterprise Manager 12c?
Deba Chatterjee: SQL Performance Analyzer is built into the database and provides command line APIs. However, Oracle Enterprise Manager 12c provides the complete orchestration needed to capture the SQL tuning set, run the performance trials, and then to create a performance comparison report.
How do you enable Enterprise Manager to monitor and send alerts to the DBAs for a "Runaway Query?”
Deba Chatterjee: You can use EM to monitor runaway queries and send alerts using Metric Extensions which rely on the data captured in SQL Monitoring. The method was explained in this webcast presentation.
How do you create a report for all the SQL running in an instance during a 30 minute timeframe? Can you export this to a spreadsheet?
Deba Chatterjee: ASH stores sampled (1 seconds in memory or 10 seconds on-disk) SQL. However ASH is meant to capture the high load SQL statements so it won’t have all SQL statements.
Do you recommend enabling automatic gathering of SQL baselines as a preventative measure of SQL regression?
Deba Chatterjee: No. This would be overkill. Identify the queries that frequently change plans and then create SQL plan baselines.
If a server has multiple database instances, what is the best way to effectively do resource allocation?
Deba Chatterjee: There is no silver bullet. Carefully study your database load and decide on use of services, instance caging and resource managers to manage load on servers.
When using SQL Performance Analyzer, do you create the baseline first before the code change is deployed or at peak DB time?
Deba Chatterjee: These are two different problems. While testing for Code change, the baseline should be created before the code is deployed. While testing for an upgrade scenario the baseline needs to be created at a peak DB time.
Is there a metric to monitor ASM disk group utilization at the cluster level?
Deba Chatterjee: Yes. ASM Disk Group Usage metric is what you can use. (See image below)
Can Oracle Enterprise Manager’s alerts be configured to monitor elements in the audit trail such as table creation or table drop?
Deba Chatterjee: Yes, these type of alerts can be configured using Metric Extensions.



Saturday, January 12, 2013

Printing Errata


I have received a copy of my new EM12c book
and while going through it, I found a printing error on page 308.
This is in Chapter 10 which is titled "Ease the Chaos with
Exadata Management". On page 308, there are two paragraphs on the page
(2nd and 3rd paragraphs from the top of the page) that mention that
the “BP1” patch is recommended. The same page also mentions in the fourth
paragraph that Release 2 is recommended. The paragraphs mentioning BP1
were supposed to be removed during the final edit, however due to a
edtorial slip they were not. This is confusing to the reader since
there are two conflicting recommendations on the same page. So,
I have decided to make things clear to the reader.

The paragraphs that should be ignored/removed are as follows:

"For Exadata discovery, the Enterprise Manager Cloud Control 12cinstallation is
recommended to be on Bundle Patch 1(BP1)if it is not already on that patch level.
Note that applying the BP1 will not change the EM12cversion, since it is not a new
release or even a patch set of Enterprise Manager. The method to verify that the bundle
patch has been applied is to use the opatch utility in the OMS home. In the opatch
output, you should see that the BP1 patch has been applied, which is patch 13242773.

"Otherwise, please refer to the My Oracle Support(MOS)reference document for
applying the BP1 patch. The document ID is 1393173.1, and it is titled Enterprise
Manager Cloud Control Workbook for Applying Bundle Patch 1 (February 2012) and
12.1.0.2 Plugins."

Please ignore these paragraphs. I have asked for them to be removed in all
future printed versions of the book and also the e-book version.



Thursday, December 20, 2012

My new EM12c Book Now Available



Friends,

I am pleased to say that my new EM12c book has finally been published and is now available, both as a printed book and as an e-book. 

http://www.packtpub.com/oracle-enterprise-manager-12c-cloud-control/book
Oracle Enterprise Manager Cloud Control 12c: Managing Data Center Chaos


This is the first published EM12c book in the world. 


Among the many positive comments I have received, a DBA says "yes,i have already bought a copy of the book. Its really good ....Thanks for publishing such a Good book on Enterprise Manager 12c."

Please have a look at the updated chapter of contents:

Table of Contents
Preface
Chapter 1: Chaos at Data Centers 
Chapter 2: Enter Oracle Cloud Control
Chapter 3: Ease the Chaos with Performance Management
Chapter 4: Ease the Chaos with Configuration Management and Security Compliance
Chapter 5: Ease the Chaos with Automated Provisioning
Chapter 6: Ease the Chaos with Automated Patching
Chapter 7: Ease the Chaos with Change Management
Chapter 8: Ease the Chaos with Test Data Management
Chapter 9: Ease the Chaos with Data Masking
Chapter 10: Ease the Chaos with Exadata Management
Chapter 11: Real-life Examples and Case Studies, and It's a Wrap: The Future is the Cloud
Index

Preface

Chapter 1: Chaos at Data Centers
Team effort
Common solutions used in data centers
Summary

Chapter 2: Enter Oracle Cloud Control
The Grid – where the cloud came from
Overview of version 12c
Striking new features in 12c
Bonus sections

Chapter 3: Ease the Chaos with Performance Management
Laying the foundation
Top activity
Testing infrastructure changes
SQL Monitoring
Doctor in the database
Real-Time ADDM
Compare Period ADDM
Active Session History (ASH) analytics
Summary

Chapter 4: Ease the Chaos with Configuration Management and Security Compliance
Lifecycle management
Auto discovery
Inventory
Detailed configuration
Search capability
History and compares
Topology
Custom configurations
Client configurations
Compliance
Compliance library
Configuration and compliance reporting
Summary

Chapter 5: Ease the Chaos with Automated Provisioning
Lifecycle management
First steps: Software Library
Provisioning library
Provisioning profiles
Deployment procedures
Customization
Lock down
Configuration details
Compliance standards
Granting permissions to the Provisioning Operator
Running EM as the Provisioning Operator
Running the procedure
Other possibilities
Summary

Chapter 6: Ease the Chaos with Automated Patching
Recommended patches
Patch plan
Out-of-place patching
Pre-patching analysis
Deployment
Plan template
Patching roles
Refreshes
Other patching procedures
Reporting
Summary

Chapter 7: Ease the Chaos with Change Management
Change management
Schema comparison
Schema Change Plan
Schema synchronization
Synchronization rules and mode
Synchronization results
Executing the synchronization
Synchronization without a Change Plan
Data comparison
Continuous comparison
Use cases
Summary

Chapter 8: Ease the Chaos with Test Data Management
Test Data Management
Creating packages
Creating the Application Data Model
Data subsetting
Applications
Table rules
Rule parameters
Space estimates
Pre/Post subset script
Generate subset
Benefits and capabilities
Summary

Chapter 9: Ease the Chaos with Data Masking
Finding sensitive data
Creating data masking definitions
New capabilities
Adding columns to mask
Defining the masking format
Advanced options
Generated Script
Scheduling the job
Testing the results
Format library
Benefits and capabilities
Summary

Chapter 10: Ease the Chaos with Exadata Management
Meeting the challenges
Discovering Exadata
Adding the hosts
Adding non-host targets
Adding the cluster and databases
Monitoring and managing Exadata
Database machine resource utilization
Exadata grid
Infiniband network
Database performance pages
Total capabilities
Summary

Chapter 11: Real-life Examples and Case Studies, and It's a Wrap: The Future is the Cloud
Case study – telecom
Case study – pharmaceutical
Case study – computer manufacturer
Case study – online store
Case study – financial institution
Case study – university
Future of cloud computing
Summary

Index


You can get the book via the Packt website, or, if you prefer Amazon, the Paperback version is available, or the Kindle version. Packt also has a PDF version.


Enjoy the world of Enterprise Manager.

Regards,

Porus.


Disclaimer

Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.

Blog Archive