Monday Apr 29, 2013

Creating a generic service with emcli ( Oracle Enterprise Manager Command Line Interface )

This blog walks you through the steps to create an Enterprise Manager Cloud Control 12c generic service using the command line API emcli.  At the end of the walk through you will have created a service consisting of;
  • A Host, an Oracle Fusion Middleware Farm, a Database and a Listener
  • HTTP and JDBC Service Test

  • System based performance and usage metrics

  • Service based performance metrics

The following emcli verbs will be used during the exercise;

For this exercise we need to create an XML file consisting of the service test definitions and substitution variables.  The documentation for the create_service verb implies that we can specify separate files in the -input_file parameter, one for the tests and one for the variables; however the documentation is wrong and this is being addressed by (Bug 16329952).

The XML schema definition transaction-template.xsd, contains the definition for both variables and template files, however we recommend that you create a template from an existing service definition using the UI and then use the emcli verb extract_template_tests command to extract a pre-existing template, however if you are comfortable with XML file creation then you can review the examples template.xml and variables.xml.

Creating a template from an existing service definition

Using the UI navigate to Enterprise > Monitoring > Monitoring Templates

Click on the Create button

Click on Target for the Copy Monitoring Settings using option button and enter the name of an existing service that you want to copy and then click Continue.

In the next screen provide the Name of the template and click OK; this will accept the defaults that were provided from the target being copied.


Extract the service test definition from the template using emcli.

emcli extract_template_tests \
    -templateName="myTemplate" \
    -templateType=generic_service \
    -output_file=myTemplate.xml

At this point you need to edit the file myTemplate.xml and ensure that you have the correct values for the substitution variables at the top of the file.

<variables>
   <variable name="HOST1" value="myserver.company.com"/>
   <variable name="PASSWORD1" value="thepassword"/>
   <variable name="PORT1" value="7799"/>
   <variable name="PROTOCOL1" value="http"/>
</variables>

Create the System and Service definition

Now we can start by creating the system definition.

emcli create_system \
    -name="mySystem" \
    -add_members="EMGC_GCDomain:oracle_ias_farm" \
    -add_members="emrep.company.com:oracle_database:key_member" \
    -add_members="LISTENER_myserver.company.com:oracle_listener:key_member" \
    -add_members="myserver.company.com:host:key_member" \
    -timezone_region="PST8PDT" \
    -availabilty_type="ALL"

Before we can create the service we must first ensure that we have a beacon to replay the tests.  Create a beacon on an existing agent.

emcli add_target \
    -name="myBeacon" \
    -type="oracle_beacon" \
    -host="myserver.company.com"

Now we are ready to create the service.

emcli create_service \
    -name="myService" \
    -type="generic_service" \
    -availType="test" \
    -availOp="or" \
    -timezone_region="PST8PDT" \
    -systemname="mySystem" \
    -systemtype="generic_system" \
    -input_file=template:"/u01/app/oracle/home/myTemplate.xml" \
    -beacons="myBeacon:Y" \
    -keycomponents="emrep.company.com:oracle_database"

NOTE: Although -timezone_region is optional if it is not specified then the availability computation of the targets will fail and the service and its tests will always show status pending.  Therefore you MUST specify the timezone_region parameter (Bug 16344350).

Additionally if you try to create a service with a name that has been used before it will fail with the error;

Oracle Error :ORA-20233: Target with guid CB9DED6762A117EC708709489C883230 does not exist

This is fixed by Patch 10096491.

We can now create a bunch of Usage and Performance metrics for the service definition that we can alert on.  The key to these metrics is the MGMT$METRIC_COLLECTION view, from this view you will use the METRIC_NAME and METRIC_COLUMN field for the metric definitions for each target type. First we will create the Usage metrics which can only be based on the system definition and not the service.

Let’s add a Usage metric based on the Active HTTP Requests across all targets on the system definition.

emcli set_metric_promotion \
    -name="myService" \
    -type="generic_service" \
    -category=Usage \
    -basedOn=system \
    -aggFunction=AVG \
    -promotedMetricKey="Active HTTP Requests" \
    -metricName="ohs_server" \
    -column="request.active" \
    -depTargetType="oracle_apache" \
    -depTargets="/EMGC_GCDomain/instance1/ohs1" \
    -threshold="125;100;GT" \
    -mode=CREATE

Now one for the Average Active Sessions for the database targets in the system.

emcli set_metric_promotion \
    -name="myService" \
    -type="generic_service" \
    -category=Usage \
    -basedOn=system \
    -aggFunction=AVG \
    -promotedMetricKey="Average Active Sessions" \
    -metricName="instance_throughput" \
    -column="avg_active_sessions" \
    -depTargetType="oracle_database" \
    -depTargets="emrep.company.com" \
    -threshold="150;125;GT" \
    -mode=CREATE

Next the Performance metrics, the first one based on the system definition for CPU Utilization (%).

emcli set_metric_promotion \
    -name="myService" \
    -type="generic_service" \
    -category=Performance \
    -basedOn=system \
    -aggFunction=AVG \
    -depTargetType="host" \
    -depTargets="myserver.company.com" \
    -metricName="Load" \
    -column="cpuUtil" \
    -promotedMetricKey="CPU Utilization (%)" \
    -threshold="80;70;GE" \
    -mode=CREATE

The second based on the Total Time (ms) for the JDBC test

emcli set_metric_promotion \
    -name="myService" \
    -type="generic_service" \
    -category=Performance \
    -basedOn=test \
    -aggFunction=AVG \
    -testname="Database Login" \
    -testtype="JDBC" \
    -beacons="myBeacon" \
    -promotedMetricKey="Total Time (ms)" \
    -column="total_time" \
    -metricName="jdbc_response" \
    -metricLevel=TXN \
    -threshold="200;100;GT" \
    -mode=CREATE

The third based on the Perceived Total Time (ms) for the Homepage test

emcli set_metric_promotion \
    -name="myService" \
    -type="generic_service" \
    -category=Performance \
    -basedOn=test \
    -aggFunction=AVG \
    -testname="Homepage" \
    -testtype="HTTP" \
    -beacons="myBeacon" \
    -promotedMetricKey="Perceived Total Time (ms)" \
    -column="avg_response_time" \
    -metricName="http_response" \
    -metricLevel=TXN \
    -threshold="12000;6000;GT" \
    -mode=CREATE

At this point the Service homepage in Cloud Control looks like;

You will notice it does not show a chart, the metrics do not appear however if you navigate to Usage or Performance metrics page and click OK the metrics appear on the chart and you have to do this for both Usage and Performance.


Thursday Apr 11, 2013

Qualcomm Deploys Application Changes Faster with Oracle Enterprise Manager

Listen in as Qualcomm talks about saving time and energy by making application changes faster through Oracle Enterprise Manager.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager Cloud Control12c Mobile app

Tuesday Apr 09, 2013

Reminder: Submit Proposals for OpenWorld 2013 San Francisco by April 12th!

Friendly reminder to Oracle Enterprise Manager customers, partners, User Group SIG members, ACEs and other ecosystem participants that this week is the LAST WEEK to submit proposals for the 2013 Oracle OpenWorld Call for Proposals.  At last year's OpenWorld, we had a record number of both submissions and accepted sessions throughout the event, and would like to do so again this year.  So, please, if you have an Oracle Enterprise Manager implementation, best practice, extensibility or business results story you'd like to share -- we want to hear about it!  

The OpenWorld 2013 Call for Proposals will close on Friday, April 12, at 11:59 p.m. PDT .

You can find more information at:  http://www.oracle.com/openworld/call-for-papers/information/index.html

We look forward to reviewing your submissions! 

Thursday Apr 04, 2013

Oracle Enterprise Manager Cloud Control 12c for Exalogic: Setting up Apps-to-Disk Monitoring

Exalogic is the logical choice for running Business Applications and provides an excellent consolidation platform hosting wide range of application workloads. It’s important to have a comprehensive Apps-to-Disk monitoring of Exalogic system enabled including monitoring of business applications, software and hardware components together from a single Oracle Enterprise Manager Cloud Control 12c console.

There are two Exalogic configuration flavors specifically in the way Exalogic is implemented 1) Virtualized or 2) Non-virtualized/physical configuration. More details on system configuration with each Exalogic release are described in this MOS note here.

In this blog post, we will cover important steps that are required to enable Oracle Enterprise Manager Cloud Control (CC) 12c as a centralized monitoring platform with Apps-to-Disk visibility for either configuration of Exalogic.

Setting up Oracle Enterprise Manager Cloud Control 12c for monitoring virtualized Exalogic stack 

  • Setup your EM CC 12cR2 site with latest PSU if not already done. Refer to EM 12cR2  install/upgrade guide here
  • Deploy EM CC 12cR2 agent on Exalogic Control Ops Center Enterprise Controller(EC) vServer
  • Export Ops Center Enterprise Controller trust certificate and import it to Enterprise Manager Cloud Control Management Agent
    • Ops Center Certificate should be imported to agent running on Ops Center Enterprise Controller.
    • Steps to Export and import the certificate here
      It's recommended to use emctl to import - emctl secure add_trust_cert_to_jks -trust_certs_loc $CERT_LOC/oc.crt -password welcome -alias <alias_name>
    • Restart the agent after importing the certificate
  • Deploy EM CC 12cR2 agent on OVM Manager(OVMM) vServer. Deploy Oracle Virtualization (VT) plug-in on OMS if not already done and on agent installed on OVM Manager vServer.
  • Configure OVMM for read-only access [Mandatory]. Steps to configure OVMM for read-only access are here. If OVMM was registered with EM CC prior to performing this mandatory configuration then you must run synchronize operation from OVMM target menu in EM CC [Important]. Note – vDC operations are done via Exalogic Control that has embedded EM Ops Center pre-installed in the Exalogic system. Refer to Exalogic Administrator’s guide here
  • Register OVMM in EM CC site by following EM CC Cloud Administrator’s guide here . It’s recommended to use the same EM CC 12cR2 agent deployed on the OVMM vServer during the OVMM registration process.
  • Deploy and configure EM CC ZFS plug-in by referring to ZFS plug-in installation guide here. It’s recommended to use the agent deployed on Ops Center Enterprise Controller vServer for discovering ZFS Storage Appliance target.
  • Deploy and configure EM CC Engineered System Healthchecks plug-in by referring to plug-In Installation Guide here. It’s recommended to use the agent deployed on Ops Center Enterprise Controller vServer for discovering Healthchecks target.
  • Discover Exalogic system using Targets -> Systems UI and select deployment type ‘Virtual’ and use agent deployed on Exalogic Enterprise Controller for Exalogic targets discovery.
  • Configure Exalogic Guest Base Template and Exalogic network by referring to following guide here and deploy agents on guest vServers
  • FMW, Apps targets and Application stack should be discovered in EM CC. In case of Oracle Applications on Exalogic, it’s recommended to have respective Apps plug-ins (FA, EBS, PSFT, Siebel etc) deployed and configured. Refer to Applications Management pack collateral here.

EM CC Plug-Ins required in case of virtualized Exalogic configuration –

  • Fusion Middleware (FMW) Plug-in [Default plug-in and deployed out-of-box] - enables overall Exalogic stack management. Exalogic monitoring for virtualized configuration was introduced in FMW 12.1.0.3 plug-in (EM 12cR2 release)
  • Oracle Virtualization (VT) Plug-in – enables Virtual Targets monitoring integration. VT monitoring integration for Exalogic was introduced in VT 12.1.0.3 plug-in (EM12cR2 release)
  • ZFS plug-in – enables ZFS target monitoring
  • Engineered System Healthchecks plug-in – enables Exachk integration in EM CC
  • Oracle Applications plug-ins (FA, EBS, PSFT, Siebel etc) – enables respective Application Management capabilities

Setting up EM CC 12c for monitoring non-virtualized/physical Exalogic stack

  • Setup your EM CC 12cR2 site with latest PSU if not already done. Refer to EM 12cR2  install/upgrade guide here
  • Deploy EM 12cR2 agents on all Compute Nodes. 
  • Discover Exalogic system via Targets -> Systems UI and select deployment type 'Physical’ and use any of the agents deployed on compute nodes for Exalogic targets discovery
  • Setup your EM Ops Center (OC) 12c site if not already done. Refer to EM OC 12c installation guide for Linux OS here and in case of Solaris OS here
  • Discover Exalogic infrastructure targets in EM OC 12c by following EM OC feature reference guide here
  • Deploy Exalogic Elastic Cloud Infrastructure (EECI) plug-in on EM CC OMS and management agent installed on OC Enterprise Controller server. Refer to EECI Plug in Install guide here for details and it’s also recommended to apply EECI plug-in patch 14214742. Each infrastructure component must be already discovered and managed in EM OC in previous step. Availability, performance and configuration Metrics for infrastructure components related to are collected by EM CC agent through EM OC JMX client.
  • Configure EM OC Enterprise Controller and EM CC repository connection by following EM OC Plug in guide here
  • Discover ‘Elastic Cloud Infrastructure’ target via Setup -> ‘Add Target’ -> ‘Add Targets Manually’ option and using agent deployed on Ops Center Enterprise Controller
  • Deploy and configure EM CC ZFS plug-in by referring to ZFS plug-in installation guide here. It’s recommended to use the agent deployed on EM OC Enterprise Controller server for discovering ZFS Storage Appliance target.
  • Deploy and configure EM CC Engineered System Healthchecks plug-in by referring to plug-In installation Guide here. It’s recommended to use the agent deployed on EM OC Enterprise Controller server for discovering Healthchecks target.
  • FMW, Apps targets and Application stack should be discovered in EM CC.In case of Oracle Applications on Exalogic, it’s recommended to have respective Apps plug-ins (FA, EBS, PSFT, Siebel etc) deployed and configured. Refer to Applications Management pack collateral here.

EM CC Plug-Ins required in case of non-virtualized/physical Exalogic configuration –

  • Fusion Middleware (FMW) Plug-in [Default plug-in and deployed out-of-box]  – enables overall Exalogic stack management.
  • Exalogic Elastic Cloud Infrastructure (EECI) plug-in - enables Exalogic rack infrastructure components monitoring in EM CC
  • ZFS plug-in – enables ZFS target monitoring
  • Engineered System Healthchecks plug-in – enables Exachk integration in EM CC 
  • Oracle Applications plug-ins (FA, EBS, PSFT, Siebel etc) – enables respective Application Management capabilities


Additional Collateral -


Contributed by Gagan Chawla, Saurabh Sachdev and
Sumit Choudhary

Stay Connected:
Twitter | Facebook | YouTube | Linkedin | Newsletter

Tuesday Apr 02, 2013

COLLABORATE13 - @IOUG Forum : Oracle Enterprise Manager SIG - Birds of a Feather

IOUG Oracle Enterprise Manager Special Interest Group (SIG) presents "Birds of Feather" event at Collaborate 2013 in Denver on Wednesday, April 10th at 9:30AM-10:30AM Mountain Time .

Join the event to ask your questions about Oracle Enterprise Manager to the user group and Oracle experts , provide feedback to product team, share best practices and learn how can you participate in the ongoing Oracle Enterprise Manager Special Interest Group (SIG) activities. We will have many SIG members, Collaborate speakers and Oracle Enterprise Manager experts attend the event.

Location :  Mile High Ballroom 4F , Colorado Convention Center

Date : Wednesday, April 10th

Time : 9:30AM-10:30AM Mountain Time

You can also join the event virtually via twitter using hash tag #em12c on twitter.com or by going to tweetchat.com/room/em12c . Use #C13DEN for Collaborate event as appropriate.

Please RSVP for the event at http://tweetvite.com/event/3fvg


About

Latest information and perspectives on Oracle Enterprise Manager.

Related Blogs




Search

Archives
« April 2013 »
SunMonTueWedThuFriSat
 
1
3
5
6
7
8
10
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
30
    
       
Today