Category Archives: Enterprise Manager

Deploying an Agent from a Windows 12.1.0.4 OMS fails

I’ve just setup a new Oracle Enterprise Manager Cloud Control 12.1.0.4 on Windows Server 2008 R2 for Customer. It’s a small one system setup, which will be used to monitor a few Oracle Databases on Windows and Linux. After the successful setup I’ve tried to deploy agents from the console, using the AgentPull. I have already performed this several times successfully. But somehow it does not work with 12.1.0.4. It fails while creating the plugin archive…

Creation of the plugin archive “e:/oracle/product/gc_inst/em/EMGC_OMS1/sysman/agentpush//plugins/windows_x64/12.1.0.4.0_PluginsOneoffs_233.zip” failed. Check the log file e:/oracle/product/gc_inst/em/EMGC_OMS1/sysman/agentpush/logs/EMAgentPushLogger.log for more details

Solution

It seems, that 12.1.0.4 on windows does have issues creating the agent image when OMS_HOME is on a different drive than SCRATCHPATH.
In my installation the OMS_HOME is on drive D: whereas SCRATCHPATH is on drive C:. The solution is straight forward. I’ve just have to reconfigure the SCRATCHPATH in ssPaths_msplats.properties.

cd $OMS_HOME\oui\prov\resources\
cp ssPaths_msplats.properties ssPaths_msplats.properties.bck

vi ssPaths_msplats.properties

SCRATCHPATH=C:/tmpada

SCRATCHPATH=D:/tmpada

As soon as this has change you may re-deploy the agent from the console.

References

More details to this issue can be found in the MOS note and the related Bug / Patch:

  • EM 12c R4: Installing / Deploying An Agent from a Windows 12.1.0.4 OMS fails when the OMS ORACLE_HOME is not installed on the ‘C:’ drive [1681463.1]
  • GET_AGENTIMAGE SHOULD WORK WHEN OMSHOME IS IN DRIVE DIFFERENT FROM SCRATCHPATH 18938561

Enterprise Manager Cloud Control 12c Release 4

A bit less than a year after Oracle Enterprise Manager Cloud Control 12c Release 3 has been released, Oracle has now released the latest version of its Enterprise Manager Cloud Control. The new release is immediately available for all supported platforms on OTN Oracle Enterprise Manager downloads or via the following direct links:

What’s New in 12.1.0.4

According the online documentation this release includes the following new features:

    Framework and Infrastructure

  • Updated Management Repository Page
  • Enterprise Manager Page Performance Page
  • Incident Management Actions in System Dashboard
  • BI Publisher 11.1.1.7 Integration
  • Integrated Installation of Business Information Publisher with Enterprise Manager 12c
  • Security Console
  • SSH Key Credential Support in Preferred Credentials
  • Global Preferred Credentials
  • Private Roles
  • Default and Bulk Apply Privilege Delegation Template
  • Fine Grained Aggregate Target Type Privilege Enhancement
  • Job System Enhancements
  • Enhanced Customization of Patching Procedures
  • Agent-Side Check Based Rule and Secure Technical Implementation Guide Compliance
  • Plug-in Management
    Services Management

  • New Create Wizard for Services
  • Support for REST and WADL for Web Service Beacon Tests
    Enterprise Monitoring and Incident Management Features

  • Advanced Thresholds Management
  • Metric Alert Message Customization
  • Metric Collection Schedule Enhancements
  • Time-Based Static Thresholds
  • Repository-Side Metric Extensions
  • Metrics Enhancements
  • Incident Management Updates in 12.1.0.4
  • Notification Enhancements
  • Enhanced Target Down Detection
    Fusion Application Management Features

  • Oracle Fusion Applications Plug-in 12.1.0.6 Features
    Database Management Features

  • Database Plug-in 12.1.0.6 Features
    Middleware Management Features

  • Fusion Middleware Plug-in 12.1.0.6 Features
    Exadata Features

  • Exadata Plug-in 12.1.0.5
  • Exadata Plug-in 12.1.0.6
    Cloud Management Features

  • Cloud Management Plug-in 12.1.0.8 Features
  • Chargeback and Consolidation Planner Plug-in 12.1.0.6 Features
  • Virtual Infrastructure Plug-in 12.1.0.1
  • Cloud Framework Plug-in 12.1.0.1
    Lifecycle Management

  • Scheduling Patch Preparation, Deployment, and Switchback

Resources

Links all around the Enterprise Manager, software, presentations and documentation:

Requirements

The requirements are similar to those from release 2 and release 3. Only the hardware requirements have been adjusted slightly. The evaluation / simple installation needs something less, whereas the advanced installations requires in general more memory and disk space. The following excerpt has been taken from Oracle® Enterprise Manager Cloud Control Basic Installation Guide.

  • OS requirements: Oracle Linux 6, Oracle Linux 5.x, Red Hat Enterprise Linux 5.x, SUSE Linux Enterprise 10, SUSE Linux Enterprise 11, Asianux Server 3
  • Hardware Requirments OMS (small) : 2 Cores, 6 GB RAM 8 GB RAM with ADPFoot 1 , JVMDFoot 2, 18 GB Hard Disk Space or 21 GB Hard Disk Space with ADP, JVMD

Enterprise Manager Cloud Control 12c Release 3

Oracle just released Enterprise Manager Cloud Control 12c Release 3. (see Oracle Enterprise Manager Downloads ) for all supported platforms. Is assume this release is related to Oracle Database 12c which has been released about a week ago.

The new release can immediately be downloaded downloaded on OTN for the following platforms:

What’s New in 12.1.0.3

According the online documentation this release includes the following new features:

    Framework and Infrastructure

  • Simplified OMS Disaster Recovery
  • System Dashboard Enhancements
  • LDAP Integration Enhancements
  • Administrator Entitlement Summary Page
  • Auditing Enhancements
  • Enterprise Manager Command Line Interface With Scripting Option
  • Administrator Entitlement Summary Page
    Enterprise Monitoring and Incident Management Features

  • Flexible Editing of Administration Group Hierarchy
  • Metric Extensions Enhancements
  • All Metrics Chart Enhancements
  • Incident Manager Updates in 12.1.0.3
  • Target Down Root Cause Analysis
  • SLA Management Enhancements
  • Service Target Dashboard

Fusion Application Management Features

  • Oracle Fusion Applications Plug-in 12.1.0.4 Features

Database Management Features

  • Performance Diagnostics Enhancements

Middleware Management Features

  • Fusion Middleware Plug-in 12.1.0.4 Features
  • Application Replay Enhancements

Exadata Features

  • Exadata Plug-in

Siebel Features

  • Siebel Plug-in 12.1.0.3

Extensibility

  • Support for SQL Server 2012 (32-bit / 64-bit)

Cloud Management Features

  • Cloud Management Plug-in 12.1.0.5 Features
  • Cloud Management Plug-in 12.1.0.6 Features
  • Virtualization Management Plug-in 12.1.0.5 Features

Lifecycle Management Features

  • Change Activity Planner
  • Offline Patching – Uploading Patches to the Software Library Directly from Remote Patch Repositories

Resources

Links all around the Enterprise Manager, software, presentations and documentation:

Requirements

The requirements are still the same as for 12c release 1 and release 2. The following excerpt has been taken from Oracle® Enterprise Manager Cloud Control Basic Installation Guide.

  • OS requirements: Oracle Linux 6, Oracle Linux 5.x, Red Hat Enterprise Linux 5.x, SUSE Linux Enterprise 10, SUSE Linux Enterprise 11, Asianux Server 3
  • Hardware Requirments OMS (small) : 2 Cores, 4 GB RAM 6 GB RAM with ADPFoot 1 , JVMDFoot 2, 10 GB Hard Disk Space or 14GB Hard Disk Space with ADP, JVMD

Pivot query on Automatic Workload Repository

I’ve just tried to get a few information from the Automatic Workload Repository (AWR). I actually wanted to put together an overview of various system metrics from DBA_HIST_SYSMETRIC_SUMMARY to create a chart. Unfortunately the data is stored as name/value pairs and not in columns. So it’s time again to convert rows to columns. There are several more or less difficult solutions for any kind of oracle release. Enclosed I’ll show a simple variant for Oracle 11g with PIVOT.

In my query I’m interested in the metrics Current Logons Count, Process Limit Usage (%) and Session Limit Usage (%). A description of these and other metrics can be found in the EM 12c online documentation Database-Related Metrics Reference Manual. The AWR view DBA_HIST_SYSMETRIC_SUMMARY is explained in the Oracle Database Reference.

Simple query with name / value pairs.

col  METRIC_NAME FOR a25
ALTER SESSION SET nls_date_format='DD.MM.YYYY HH24:MI:SS';
SELECT
    SNAP_ID,
    END_TIME,
    METRIC_NAME,
    MAXVAL
FROM
    DBA_HIST_SYSMETRIC_SUMMARY
WHERE
    METRIC_NAME IN ('Current Logons Count','Process Limit %','Session Limit %')
ORDER BY SNAP_ID;
   SNAP_ID END_TIME            METRIC_NAME                   MAXVAL
---------- ------------------- ------------------------- ----------
       589 03.06.2013 00:21:44 Process Limit %           31,7142857
       589 03.06.2013 00:21:44 Current Logons Count             110
       589 03.06.2013 00:21:44 Session Limit %           22,2222222
       590 03.06.2013 01:20:44 Process Limit %           14,8571429
       590 03.06.2013 01:20:44 Current Logons Count              51
       590 03.06.2013 01:20:44 Session Limit %           11,8055556
       591 03.06.2013 02:21:44 Session Limit %           11,6319444
       591 03.06.2013 02:21:44 Process Limit %           14,2857143
       591 03.06.2013 02:21:44 Current Logons Count              49
       592 03.06.2013 03:20:44 Current Logons Count              47
       592 03.06.2013 03:20:44 Process Limit %           13,7142857
       592 03.06.2013 03:20:44 Session Limit %           11,1111111
...

Lets query the same data with a PIVOT query.

SELECT
    *
FROM
    (SELECT
        SNAP_ID,
        END_TIME,
        METRIC_NAME,
        MAXVAL
    FROM
        DBA_HIST_SYSMETRIC_SUMMARY)
pivot
   ( MAX(MAXVAL)
   FOR METRIC_NAME IN ('Current Logons Count' ,'Process Limit %','Session Limit %'))
ORDER BY SNAP_ID;
   SNAP_ID END_TIME            'Current Logons Count' 'Process Limit %' 'Session Limit %'
---------- ------------------- ---------------------- ----------------- -----------------
       589 03.06.2013 00:21:44                    110        31,7142857        22,2222222
       590 03.06.2013 01:20:44                     51        14,8571429        11,8055556
       591 03.06.2013 02:21:44                     49        14,2857143        11,6319444
       592 03.06.2013 03:20:44                     47        13,7142857        11,1111111
       593 03.06.2013 04:21:44                     47        13,7142857           10,9375
       594 03.06.2013 05:21:44                     49        14,2857143        11,2847222
       595 03.06.2013 06:21:44                     48                14        11,2847222
       596 03.06.2013 07:21:44                     49        14,2857143        11,2847222
       597 03.06.2013 08:21:44                     48                14        11,2847222
       598 03.06.2013 09:21:45                     49        14,2857143        11,2847222
       599 03.06.2013 10:21:45                     47        13,7142857           10,9375
...

Et voilà, the result can now be used to create a fancy excel chart.

Other solutions with DECODE, CASE or SYS_CONNECT_BY_PATH are also possible. These would even run on older Oracle releases.

Enterprise Manager Cloud Control 12c Release 2

Today Oracle announced the general availability of Enterprise Manager Cloud Control 12c Release 2. (see press release Oracle Enterprise Manager 12c Release 2 Now Available ) The release introduces a bunch of new and improve capabilities for deploying and managing business applications in an enterprise private cloud, such as Java Platform-as-a-Service (PaaS), enhanced business application management, and integrated hardware-software management for Oracle Exalogic Elastic Cloud.

General availability means in this case, that the new binaries can be downloaded on OTN for Linux x86-64 (64-bit), Linux x86 (32-bit), Solaris Operating System (SPARC), Solaris Operating System (x86-64), IBM AIX on POWER Systems (64-bit) and Windows x86-64 (64-bit)

What’s New in 12.1.0.2

According the online documentation this release includes the following new features:

  • Framework and Infrastructure
  • EM CLI Verbs Available in the Software Library
  • Stage Operation
  • Enhanced Repository Page
  • New Oracle Management Service Page
  • Consolidated Agent Management Page
  • Dynamic Groups
  • Support for BI Publisher 11.1.6.0
  • Better Support for Changing WebLogic Server Demonstration Certificates
  • EM CLI Tracking and Setup
  • Support for Properties for Enterprise Manager Administrators

  • Enterprise Monitoring and Incident Management Features
    • Search in Administration Group Hierarchy
    • Monitoring Templates and Template Collections Enhancements
    • Grant Edit or Full Privileges on Metric Extensions
    • Monitoring Templates and Template Collections Enhancements
    • Incident Manager Updates

  • Fusion Middleware Plug-in 12.1.0.3 Features
  • Application Management Features
    • Oracle Fusion Applications Plug-in 12.1.0.3 Features

  • Cloud Management Features
    • Cloud Management Plug-in 12.1.0.4 Features
    • Virtualization Management Plug-in 12.1.0.3 Features

  • Heterogeneous (Non-Oracle) Management
    • Metadata Plug-In Support

    Resources

    Links all around the Enterprise Manager, software, presentations and documentation:

    Requirements

    The requirements are still the same as for 12c release 1. The following excerpt has been taken from Oracle® Enterprise Manager Cloud Control Basic Installation Guide.

    • OS Requirments: Oracle Linux 6, Oracle Linux 5.x, Red Hat Enterprise Linux 5.x, SUSE Linux Enterprise 10, SUSE Linux Enterprise 11, Asianux Server 3
    • Hardware Requirments OMS (small) : 2 Cores, 4 GB RAM 6 GB RAM with ADPFoot 1 , JVMDFoot 2, 10 GB Hard Disk Space or 14GB Hard Disk Space with ADP, JVMD

    As soon as I find time I’ll install this new release….

    Oracle Released EM 12c Cloud Control for Solaris

    As Oracle announce in there MOS Note 793512.1 EM 12c Cloud Control will be release in Q4. I would have bet it comes on 31 December, but Oracle just released EM12c for SPARC Solaris as well as for Solaris x86_64. I’ve just stated to download the software. Like for Linux there also two ZIP archive for each solaris release. Total size for each OS is almost 6GB. In addition to EM12c you have to download Oracle database 11g if you haven’t done it yet.

    Ok, here are the links and information related to EM12c for Solaris:

    Beside the EM12c downloads, there are also EM12c agents as separate download for Linux x86 (32-bit), Linux x86-64 (64-bit), Solaris Operating System (SPARC) and Solaris Operating System (x86-64) available. Download URL’s and documentation is available at the OTN page Enterprise Manager Agent Downloads. Each agent is about 250MB but these files can not be used to install a fresh 12.1 agent. This file will be used by 12.1 Self Update feature in offline mode. For information on using the Self Update feature, refer to the Oracle Enterprise Manager Cloud Control Administrator’s Guide.

    Mmh, now I just need a solaris test box to start with EM12c…

    Howto change SYSMAN password in 12C Cloud Control

    I was on leave for the past few weeks. After digging through tons of e-mails I finally found time to look into EM 12 Cloud Control. Unfortunately, I’ve forgotten my SYSMAN password and the EM 12c test installation is no longer running. As you say: “Holidays where one forgets everything, must be good holidays.”

    So far so good, but what about my problems. Lets start with EM 12c which is not running. I started the VM from scratch. After login in over ssh I’ve realized that the EM 12c infrastructure is running. To my surprise the installer configured the start / stop script gcstartup in /etc/init.d and the corresponding rc directories. The script exists already since EM 10g but I’ve never used it. Unfortunately nobody created the start / stop script for the database and the listener. As soon as starting them manually I’ve just have to bounce the EM 12c to be up and ready again. It is not enough to just start the database. Restarting or starting the OMS is also necessary due to the fact that the OMS is not started when the database is not available during the startup of EM 12c. Oracle described this in a MOS Note EM Cloud Control 12c OMS not able to start after server reboot [1367876.1]

    My second problem is quite a common issue. You’ll find some notes on how to change the SYSMAN password for EM 10/11g, DB Console and new as well for EM 12c. Basically it is done in a similar way as in EM 11g. It is just a little easier because it is not necessary to do the change in two steps. You may use use emctl to change the SYSMAN password for the OMS infrastructure and well the database account. That’s also what you can specify the SYS password when using emctl.

    1. Stop all OMS: emctl stop oms
    2. Change the password: emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd sys user password -new_pwd new sysman password
    3. Stop the Admin server and restart all OMS: emctl stop oms -all; emctl start oms

    An example output:

    emctl config oms -change_repos_pwd -use_sys_pwd -sys_pwd manager -new_pwd tiger
    Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.1.0
    Copyright (c) 1996, 2011 Oracle Corporation. ALL rights reserved.
    Changing passwords IN backend ...
    Passwords changed IN backend successfully.
    Updating repository password IN Credential Store...
    Successfully updated Repository password IN Credential Store.
    Restart ALL the OMSs USING 'emctl stop oms -all' AND 'emctl start oms'.
    Successfully changed repository password.

    More information on these topic’s can be found in the following MOS notes:

    • 12C Cloud Control: Steps to Modify the SYSMAN Password at OMS and Repository [1365930.1]
    • How to Change the Password of SYSMAN User in 10g and 11g Grid Control? [270516.1]
    • EM Cloud Control 12c OMS not able to start after server reboot [1367876.1]