Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Extensibility

1 Extending Monitoring

• What You Get
• What is a Management Plug-in
• Management Plug-ins Available from the Oracle Technology Network
• Management Plug-in Lifecycle
• About the Extensibility Guide

2 Developing a Management Plug-in

• Designing Your Management Plug-in
• Developing Requisite Management Plug-in Files
  • Target Definition Files
    • Creating the target type metadata file.
    • Validate your new target type definitions.
    • Creating a Default Collection File
    • Adding SYSTEM Reports (Optional)
    • Adding Related Links to Target Home Pages
    • Additional Scripts and Binaries
  • Ensuring Accurate XML
  • Development Guidelines
    • Guidelines for Defining Target Metadata
    • Guidelines for Defining Collections
• Creating a Management Plug-In Archive
• Uploading the Management Plug-in Archive into Enterprise Manager
• Adding a Target Instance
• Viewing Results
• Troubleshooting Management Plug-ins

3 Validating XML

• What is ILINT?
  • What types of validation does ILINT perform?
    • Static XML Validation
    • Dynamic Validation
    • Metadata Version Checking
  • ILINT Output
• Before Using ILINT
• Using ILINT
  • ILINT Examples
    • Static Validation
    • Dynamic Validation
    • Checking Metadata Version Compatibility
    • Generating Syntactically Correct XML
  • Usage Notes

4 Adding Reports

• What You Get
  • Reports Page (Target Home Page)
  • Report Definitions Page
• Report Definition File
• Creating a Report Definition File
  • Report Definition File Development Process
  • Report Lifecycle: Updating Report Definitions
• PL/SQL Application Programmer Interface
  • PL/SQL Methods for Creating Report Definitions
    • mgmt_ip.create_report_definition
    • mgmt_ip.create_report_definition
    • mgmt_mp_homepage.add_report
    • mgmt_view_util.adjust_tz
  • PL/SQL Type Definitions
  • Element Parameters
    • Table Element Parameters
    • Chart Element
  • Metric Details Element
  • Text Element Parameters
  • Report-Wide Parameters
• Development Guidelines

5 Management Using Web Services and JMX

• Overview
• Monitoring Using Web Services in Enterprise Manager
  • Web Services Command Line Tool
    • Security
    • Syntax
    • Usage
• Monitoring JMX Applications Deployed on Oracle Application Servers
  • JMX Command Line Tool
    • Syntax
    • Usage
• Creating a Management Plug-in Archive
• Importing the Management Plug-in
• Deploying the Management Plug-in to the Management Agent
• Adding a Target Instance
  • Adding a Web Services Target Instance
  • Adding a JMX-instrumented J2EE Target Instance
• Viewing Monitored Metrics

Part II Reference

6 Management Repository Views

• Overview
• Monitoring Views
  • MGMT$METRIC_ERROR_HISTORY
  • MGMT$METRIC_ERROR_CURRENT
  • MGMT$TARGET_COMPONENTS
  • MGMT$BLACKOUT_HISTORY
  • MGMT$BLACKOUTS
  • MGMT$ALERT_ANNOTATIONS
  • MGMT$ALERT_NOTIF_LOG
  • MGMT$TARGET_METRIC_COLLECTIONS
  • MGMT$TARGET_METRIC_SETTINGS
  • MGMT$AVAILABILITY_CURRENT
  • MGMT$AVAILABILITY_HISTORY
  • MGMT$ALERT_CURRENT
  • MGMT$ALERT_HISTORY
  • MGMT$METRIC_DETAILS
  • MGMT$METRIC_CURRENT
  • MGMT$METRIC_HOURLY
  • MGMT$METRIC_DAILY
• Inventory Views
  • MGMT$TARGET
  • MGMT$TARGET_TYPE
  • MGMT$TARGET_TYPE_DEF
  • MGMT$TARGET_ASSOCIATIONS
  • MGMT$TARGET_MEMBERS
  • MGMT$TARGET_FLAT_MEMBERS
  • MGMT$TARGET_TYPE_PROPERTIES
  • MGMT$TARGET_PROPERTIES
  • MGMT$METRIC_CATEGORIES
• Policy Definition Views
  • MGMT$POLICIES
  • MGMT$POLICY_PARAMETERS
  • MGMT$POLICY_VIOLATION_CTXT
  • MGMT$TARGET_POLICY_EVAL_SUMM
  • MGMT$POLICY_VIOL_ANNOTATIONS
  • MGMT$POLICY_VIOL_NOTIF_LOG
• Policy Association Views
  • MGMT$TARGET_POLICIES
  • MGMT$TARGET_POLICY_SETTINGS
• Policy Violation Views
  • MGMT$POLICY_VIOLATION_CURRENT
  • MGMT$POLICY_VIOLATION_HISTORY
  • MGMT$POLICY_VIOLATION_CONTEXT
• Management Template Views
  • MGMT$TEMPLATES
  • MGMT$TEMPLATE_POLICY_SETTINGS
  • MGMT$TEMPLATE_METRICCOLLECTION
  • MGMT$TEMPLATE_METRIC_SETTINGS
• Job Views
  • MGMT$JOBS
  • MGMT$JOB_TARGETS
  • MGMT$JOB_EXECUTION_HISTORY
  • MGMT$JOB_STEP_HISTORY
  • MGMT$JOB_ANNOTATIONS
  • MGMT$JOB_NOTIFICATION_LOG
• Application Service Level Management Views
  • MGMT$CSM_REGION
  • MGMT$CSM_WATCHLIST
  • MGMT$CSM_METRIC_DETAILS
  • MGMT$CSM_MT_METRIC_DETAILS
  • MGMT$CSM_URL_HOURLY
  • MGMT$CSM_URL_DAILY
  • MGMT$CSM_URL_DIST_HOURLY
  • MGMT$CSM_URL_DIST_DAILY
  • MGMT$CSM_MT_URL_HOURLY
  • MGMT$CSM_MT_URL_DAILY
  • MGMT$CSM_MT_URL_DIST_HOURLY
  • MGMT$CSM_MT_URL_DIST_DAILY
  • MGMT$CSM_IP_HOURLY
  • MGMT$CSM_IP_DAILY
  • MGMT$CSM_IP_DIST_HOURLY
  • MGMT$CSM_IP_DIST_DAILY
  • MGMT$CSM_MT_IP_HOURLY
  • MGMT$CSM_MT_IP_DAILY
  • MGMT$CSM_MT_IP_DIST_HOURLY
  • MGMT$CSM_MT_IP_DIST_DAILY
  • MGMT$CSM_DOMAIN_HOURLY
  • MGMT$CSM_DOMAIN_DAILY
  • MGMT$CSM_DOMAIN_DIST_HOURLY
  • MGMT$CSM_DOMAIN_DIST_DAILY
  • MGMT$CSM_SUBNET_HOURLY
  • MGMT$CSM_SUBNET_DAILY
  • MGMT$CSM_SUBNET_DIST_HOURLY
  • MGMT$CSM_SUBNET_DIST_DAILY
  • MGMT$E2E_1DAY
  • MGMT$E2E_HOURLY
  • MGMT$E2E_RAW
• Configuration Views
  • MGMT$DB_TABLESPACES
  • MGMT$DB_DATAFILES
  • MGMT$DB_CONTROLFILES
  • MGMT$DB_DBNINSTANCEINFO
  • MGMT$DB_FEATUREUSAGE
  • MGMT$DB_INIT_PARAMS
  • MGMT$DB_LICENSE
  • MGMT$DB_REDOLOGS
  • MGMT$DB_ROLLBACK_SEGS
  • MGMT$DB_SGA
  • MGMT$DB_TABLESPACES
  • MGMT$DB_OPTIONS
• Oracle Home Patching Views
  • MGMT$EM_HOMES_PLATFORM
  • MGMT$HOMES_AFFECTED
  • MGMT$APPL_PATCH_AND_PATCHSET
  • MGMT$APPLIED_PATCHES
  • MGMT$APPLIED_PATCHSETS
• Linux Patching Views
  • MGMT$HOSTPATCH_HOSTS
  • MGMT$HOSTPATCH_GROUPS
  • MGMT$HOSTPATCH_GRP_COMPL_HIST
  • MGMT$HOSTPATCH_HOST_COMPL
• Security Views
  • MGMT$ESA_ALL_PRIVS_REPORT
  • MGMT$ESA_ANY_DICT_REPORT
  • MGMT$ESA_ANY_PRIV_REPORT
  • MGMT$ESA_AUDIT_SYSTEM_REPORT
  • MGMT$ESA_BECOME_USER_REPORT
  • MGMT$ESA_CATALOG_REPORT
  • MGMT$ESA_CONN_PRIV_REPORT
  • MGMT$ESA_CREATE_PRIV_REPORT
  • MGMT$ESA_DBA_GROUP_REPORT
  • MGMT$ESA_DBA_ROLE_REPORT
  • MGMT$ESA_DIRECT_PRIV_REPORT
  • MGMT$ESA_EXMPT_ACCESS_REPORT
  • MGMT$ESA_KEY_OBJECTS_REPORT
  • MGMT$ESA_OH_OWNERSHIP_REPORT
  • MGMT$ESA_OH_PERMISSION_REPORT
  • MGMT$ESA_POWER_PRIV_REPORT
  • MGMT$ESA_PUB_PRIV_REPORT
  • MGMT$ESA_SYS_PUB_PKG_REPORT
  • MGMT$ESA_TABSP_OWNERS_REPORT
  • MGMT$ESA_TRC_AUD_PERM_REPORT
  • MGMT$ESA_WITH_ADMIN_REPORT
  • MGMT$ESA_WITH_GRANT_REPORT
• Configuration Management Views
  • MGMT$CSA_COLLECTIONS
  • MGMT$CSA_FAILED
  • MGMT$CSA_HOST_OS_COMPONENTS
  • MGMT$CSA_HOST_SW
  • MGMT$CSA_HOST_COOKIES
  • MGMT$CSA_HOST_CUSTOM
  • MGMT$CSA_HOST_RULES
  • MGMT$CSA_HOST_CPUS
  • MGMT$CSA_HOST_IOCARDS
  • MGMT$CSA_HOST_NICS
  • MGMT$CSA_HOST_OS_PROPERTIES
  • MGMT$CSA_HOST_OS_FILESYSEMS
  • MGMT$ECM_CONFIG_HISTORY
  • MGMT$ECM_CONFIG_HISTORY_KEY1
  • MGMT$ECM_CONFIG_HISTORY_KEY2
  • MGMT$ECM_CONFIG_HISTORY_KEY3
  • MGMT$ECM_CONFIG_HISTORY_KEY4
  • MGMT$ECM_CONFIG_HISTORY_KEY5
  • MGMT$ECM_CONFIG_HISTORY_KEY6
  • MGMT$HW_NIC
  • MGMT$OS_COMPONENTS
  • MGMT$OS_FS_MOUNT
  • MGMT$OS_HW_SUMMARY
  • MGMT$OS_KERNEL_PARAMS
  • MGMT$OS_PATCHES
  • MGMT$OS_SUMMARY
  • MGMT$SOFTWARE_COMP_PATCHSET
  • MGMT$SOFTWARE_COMPONENT_ONEOFF
  • MGMT$SOFTWARE_COMPONENTS
  • MGMT$SOFTWARE_DEPENDENCIES
  • MGMT$SOFTWARE_HOMES
  • MGMT$SOFTWARE_ONEOFF_PATCHES
  • MGMT$SOFTWARE_OTHERS
  • MGMT$SOFTWARE_PATCHES_IN_HOMES
  • MGMT$SOFTWARE_PATCHSETS
• Database Cluster Views
  • MGMT$CLUSTER_INTERCONNECTS
  • MGMT$RACDB_INTERCONNECTS
  • MGMT$HA_BACKUP
• Storage Reporting Views
  • MGMT$STORAGE_REPORT_DATA
  • MGMT$STORAGE_REPORT_KEYS
  • MGMT$STORAGE_REPORT_PATHS
  • MGMT$STORAGE_REPORT_ISSUES
  • MGMT$STORAGE_REPORT_DISK
  • MGMT$STORAGE_REPORT_VOLUME
  • MGMT$STORAGE_REPORT_LOCALFS
  • MGMT$STORAGE_REPORT_NFS

7 Fetchlets

• OS Command Fetchlets
  • OS Fetchlet
  • OSLines Fetchlet (split into lines)
  • OSLineToken Fetchlet (tokenized lines)
• SQL Fetchlet
• SNMP Fetchlet
• URL Timing Fetchlet
• Dynamic Monitoring Service (DMS) Fetchlet
  • Advantages to Using DMS for Oracle Management Agent Integration
  • DMS Fetchlet/Oracle Management Agent Integration Instructions
    • Integrating DMS Data with the Management Agent
• HTTP Data Fetchlets
  • URL Fetchlet (raw)
  • URL Lines Fetchlet (split into lines)
  • URL Line Token Fetchlet (tokenized lines)
• URLXML Fetchlet
• WBEM Fetchlet
• JDBC Fetchlet
• OJMX/SOAP Fetchlet

Index