Optimize Oracle WebLogic performance/manageability: Oracle EM12c

Screen Shot 2012-10-01 at 9.34.03 AM

For those of you who are still not aware; the days of EM being just a nice Database monitoring tool are way behind us. Curious to know what managing the complete stack means, might have persuade you to join this session by Nicole Haba (Oracle) and Ishaq Mohammed (Pacific Gas & Electric).

IMG_0098

Nicole starts with pointing out some of the challenges we have when trying to monitor and manage the Middleware Stack.

These include:

  • Monitoring & Diagnostics
    • Multiple Domain Discovery
    • Out-of-Box Monitoring
    • Metric Extensions
    • Administration Groups & Template Collections
    • Incident & Problem Management
    • Business Application Management
    • Middleware Diagnostics Advisor
    • JVM Diagnostics
    • Log Viewer
  • Administration
    • Credential Management
    • Record WLST scripts
    • System MBean Browser
    • Configure Log File Settings
    • Change Center
    • JDBC Data Source Management
    • Process Control
    • Selective Tracking
  • Configuration Management
    • Automated Asset Directory
    • Compare Configurations
    • Search Configurations
    • Compliance Management
    • Custom Configurations
    • Synchronize Configurations
    • Config Change History
  • Lifecycle Management
    • Cloning Domains
    • Patch Automation

Nicole introduces some Hints and Tips… :

Like: How can we discover multiple domains in EM? Simply create a csv file containing the specs of all domains to be discovered and use EMCLI to perform the discovery, using the csv as input parameter file.

IMG_0081

Using the Middleware Diagnostics Advisor to identify and resolve performance issues

IMG_0087

I must admit after conducting several EM12c Bootcamps, I am a MDA fan myself…

Enforcing standards by cloning WebLogic Domains. Exactly as we are used to working with “Golden Images” of Database Homes, the same goes for WebLogic domains.

Uploading binaries to the EM Software Library (a central location in EM to store images like OS, Database, Middleware and Applications) to allow provisioning of these to new servers and by that enforcing standardization.

IMG_0089

Next Ishaq Mohammed gives us an insight of the challenges at Pacific Gas & Electric and the way they implemented EM12c to monitor and manage the middleware stack.

IMG_0092

Several challenges motivated PG&E to start EM12c implementation, including:

  • 20% increase of WebLogic landscape over next 12 months with same number of administrators
  • Unawareness of performance problems until end users complain
  • Manual deployments of software being much too time-consuming, error prone, leading to inconsistent  non-standard configurations

Key Use cases included:

  • Administration Groups and Template Collections – to enforce standard monitoring settings
  • Middleware Diagnostics Advisor – To allow for fast root cause analysis
  • JVM Diagnostics – For application to disk drilldown
  • Provisioning Profiles and Cloning WebLogic Domains – to enforce standard domain deployment

IMG_0103

IMG_0106

Using Provisioning Profiles and Cloning of WebLogic Domains allowed for SSL-Enabled WebLogic Domains with OSB deployed as well as SSL-Enabled Weblogic Domain with WebLogic Portal deployed.

It also supports the differentiation of provisioning profiles in case of dev, test or production situations.

Customized Deployment Procedures were created to provision OSB domains and WebLogic Portal domains.

Initially the EM console has been used for launching deployment procedures, to be later replaced with EMCLI.

Ishaq concludes with some final steps finalise the project including: the creation of custom reports using BI Publisher, the patching of WebLogic Servers across multiple domains, the monitoring to Service Level Agreements and the implementation of Business Transaction Management (BTM).

I must say a very interesting customer story appreciated by many in the audience.

Setup Database as a Service using EM12c DB Plugin 12.1.0.3

15 February, an update of some Plugins was released.

The new version of the DB plugin (12.1.0.3) includes several new features in the area of diagnostics, High Availability, Manageability, RAC and Grid Infrastructure, Security etc.

The list of new plugins include the brand new plugin “Oracle Storage Management Framework”, enabling Snap Clone functionality leveraging the “Snapshot” and Copy features of the underlying storage. The new and updated plugins are packaged with new features including “Testing as a Service”, “Snap Clone”, “Schema as a Service” and “RMAN based Database Provisioning”.

This document describes an example of the setup of the Database Cloud, by using a Service Template that is based on a DBCA template. It also shows an example of the execution of a request made by a user in the Self Service Portal, using the newly created Service Template.

Setup Database as a Service using EM12c – DB Plugin 12.1.0.3

Setup Database as a Service using EM12c

I have been struggling for some time to complete this paper on the setup of DBaaS. Actually everything went fine, except for the final step where a Self Service Portal user requested for a new Database. After some analysis it appears that the integration I did immediate after the installation of my EM12c box with OVM Manager 3.1, was the “stand in the way” to successfully complete this final step.

After removing the integration between EM12c and OVM Manager 3.1 I finally managed to execute a successful Database request from the Self Service Portal. So, take care when working in a similar setup and trying to the DBaaS setup!

Resolution was with full assistance of Oracle Support (thanks to them).  A bug was registered and will be subject for a fix.

Anyway, please find here the paper describing the full setup using EM12c – 12.1.0.2 (+PSU1). Have fun reading it.

Setup Database as a Service using EM12c