2 Installing Oracle Rdb Extension for Enterprise Manager 10g EMAgent

The Rdb EMAgent Extension installation script is located in the top level directory into which the backup saveset was extracted. This script checks to ensure that Oracle Enterprise Manager 10g is installed on the system, creates additional required directories under the ORA_ROOT:[SYSMAN] directory tree, and copies the scripts used to gather information from Oracle Rdb entity targets to their appropriate directories. The logical ORA_ROOT must be defined in order for the installation to complete successfully.

The installation script should run to completion in less than one minute.

Issue these commands to run the script:

    $ set default <disk>:[temp]
    $ @install.com

where <disk> is the disk name you used in the extract procedure.

The EMAgent runs scripts against each known target on a periodic basis to collect statistical information. This information is then sent to the Management Server component of the Oracle Enterprise Manager where it is stored in the Management Repository.

For Oracle Rdb Databases entity targets, the EMAgent can upload over 80 sets of metrics comprising over 1000 individual statistics. The 80-plus sets have been divided into 10 metric groups each of which can be enabled or disabled for collection. By default, only two groups are enabled for collection, but this may be altered during or after the installation process.

The following is a list of these metric groups, their default ON or OFF status, and their frequency of collection if ON.

• Summary Metrics [ON : 5 Minutes]
• AIJ General Information, Journals, Space Metrics [ON : 5 Minutes]
• Other Journaling Metrics [OFF]
• I/O Metrics [OFF]
• Locking by Type Metrics [OFF]
• Locking by Field Metrics [OFF]
• Index Metrics [OFF]
• Object by Type Metrics [OFF]
• Object by Field Metrics [OFF]
• Process Metrics [OFF]

The installation procedure displays the above list of metric groups and allows you to toggle the ON / OFF status of any of the groups. If you choose to enable a metric group, you are also prompted for how often the metric group statistics should be collected. The collection frequency can be between one and 120 minutes inclusive.

During the enabling / disabling phase of the installation procedure, a List option is available that lists all the metric sets in each group. Each of these metric sets corresponds closely, but not exactly, to the metric sets available via the RMU/SHOW STATISTICS command.

The metric groups you select and the collection frequency you enter will apply to ALL Oracle Rdb database targets on your system. They cannot be adjusted on a per-database basis.

2.5 Restarting the EMAgent

After the Rdb EMAgent Extension installation has run to completion, you must restart the EMAgent. This is accomplished by stopping and then starting the EMAgent using the emctl command from the Oracle system manager account as follows:

    $ emctl stop agent

    Oracle Enterprise Manager 10g Release 10.1.0.3.0.
    Copyright (c) 1996, 2004 Oracle Corporation.  All rights reserved.
    Stopping agent ... stopped.
    $
    $ emctl start agent
    Oracle Enterprise Manager 10g Release 10.1.0.3.0.
    Copyright (c) 1996, 2004 Oracle Corporation.  All rights reserved.
          EMAgent status running as PID 2B8B4407...
    Response From Agent: running
    Agent Version     : 10.1.0.3.0
    OMS Version       : 10.2.0.2.0
    Protocol Version  : 10.1.0.3.0
    Agent Home        : /ora10g/oracle/mynode_ora10g
    Agent binaries    : /ORA10G/ORACLE
    Agent Process ID  : 730547207
    Parent Process ID : 0
    Agent URL         : http://mynode.mycompany.com:1830/emd/main
    Started at        : 2005-07-25 15:36:22
    Started by user   : ORA10G
    Last Reload       : 2005-07-25 15:36:22
    Last successful upload                       : (none)
    Last attempted upload                        : (none)
    Total Megabytes of XML files uploaded so far :     0.00
    Number of XML files pending upload           :        3
    Size of XML files pending upload(MB)         :     0.60
    Available disk space on upload filesystem    :    59.34%
    $  

    $ emctl status agent
    Oracle Enterprise Manager 10g Release 10.1.0.3.0.
    Copyright (c) 1996, 2004 Oracle Corporation.  All rights reserved.
    ---------------------------------------------------------------
    Agent Version     : 10.1.0.3.0
    OMS Version       : 10.2.0.2.0
    Protocol Version  : 10.1.0.3.0
    Agent Home        : /ora10g/oracle/mynode_ora10g
    Agent binaries    : /ORA10G/ORACLE
    Agent Process ID  : 543481717
    Parent Process ID : 0
    Agent URL         : http://mynode.mycompany.com:1830/emd/main
    Started at        : 2007-04-23 14:48:41
    Started by user   : ORA10G
    Last Reload       : 2007-04-23 14:48:41
    Last successful upload                       : 2007-04-23 14:58:51
    Total Megabytes of XML files uploaded so far :     1.45
    Number of XML files pending upload           :        0
    Size of XML files pending upload(MB)         :     0.00
    Available disk space on upload filesystem    :    31.47%
    ---------------------------------------------------------------
    Agent is Running and Ready

    $ set default disk:[temp]
    $ @install

    Oracle Rdb Extension for Oracle Enterprise Manager Agent 10g, Release 7.2.1.0 Installation
    Copyright (c) 1999,2008, Oracle Corporation.  All Rights Reserved.

    Verifying Oracle Enterprise Manager Agent 10g installation...
    Completed verification.

    Prompting for Rdb statistics to collect...

    +--------------------
    | Oracle Rdb Extension for Enterprise Manager 10g
    | SELECT METRICS for the Oracle Rdb Database Entity Type
    |

    The Oracle Enterprise Manager 10g Agent runs scripts against each known
    target on a periodic basis to collect statistical information.  This
    information is then sent to the Management Server component of the
    Oracle Enterprise Manager where it is then stored into the Management
    Repository.

    By default, only two of the available metric groups are enabled.  Using the
    following menu, you may enable or disable any of the metric groups and
    set a desired interval frequency.

    The menu lists all the available metric groups and whether or not they
    have been enabled.  Entering the menu option number associated with the
    metric group will toggle it to ON or OFF.  If the metric group 
    is toggled to ON, you will be prompted for how often (in minutes) the
    metric group statistics should be collected.

    Upon exiting this command procedure, the XML definition files used by
    the EMAgent for gathering statistics from Oracle Rdb Database
    targets will automatically be generated based on the metric groups you 
    have chosen.

    Press RETURN to continue: 

    +--------------------
    | Oracle Rdb Extension for Enterprise Manager 10g
    | SELECT METRICS for the Oracle Rdb Database Entity Type
    |
       1.  Summary Metrics [ON : 5 Minutes]
       2.  AIJ General Statistic Information, Journals, Space Utilization Metrics [ON : 5 Minutes]
       3.  Other Journaling Metrics [OFF]
       4.  I/O Metrics [OFF]
       5.  Locking by Type Metrics [OFF]
       6.  Locking by Field Metrics [OFF]
       7.  Index Metrics [OFF]
       8.  Object by Type Metrics [OFF]
       9.  Object by Field Metrics [OFF]
      10.  Process Metrics [OFF

       L.  List Metrics per Group
       H.  Help
       E.  Exit and Generate XML Definitions

      Enter metric number to toggle or other menu option:  
                                    
10
      Enter Collection Frequency in Minutes (1 to 120) for Process Metrics [10]:  
                                    
15

    +--------------------
    | Oracle Rdb Extension for Enterprise Manager 10g
    | SELECT METRICS for the Oracle Rdb Database Entity Type
    |
       1.  Summary Metrics [ON : 5 Minutes]
       2.  AIJ General Statistic Information, Journals, Space Utilization Metrics [ON : 5 Minutes]
       3.  Other Journaling Metrics [OFF]
       4.  I/O Metrics [OFF]
       5.  Locking by Type Metrics [OFF]
       6.  Locking by Field Metrics [OFF]
       7.  Index Metrics [OFF]
       8.  Object by Type Metrics [OFF]
       9.  Object by Field Metrics [OFF]
      10.  Process Metrics [ON :  
                                    
15 Minutes]

       L.  List Metrics per Group
       H.  Help
       E.  Exit and Generate XML Definitions

      Enter metric number to toggle or other menu option:  
                                    
E

    Generating XML files...
    Completed XML file generation.
    Completed statistics selection.

    Creating directories...
    Completed directory creation.

    Copying XML definition files...
    Copying Rdb statistic collection scripts...
    Copying User Guide documentation files...
    Copying Install Guide documentation files...

    Completed copying.

    Automatic discovery of extension target types (such as Oracle Rdb Databases,
    Oracle Rdb Monitors, etc.) is not possible with the current release of Enterprise
    Manager Grid Control.  To add an Oracle Rdb Database, Oracle Rdb Monitor, etc.
    entity target to your Oracle Enterprise Manager Grid Control System, you will
    have to manually add them using the Oracle Enterprise Manager Grid Control
    web-based interface.  While viewing the home page for the EMAgent for this host, use
    the "Add Monitored Target" link to perform a target discovery task.

    User Guide:    ora_root:[sysman.admin.scripts.emx.rdb.documentation.userguide]toc.htm
    Install Guide: ora_root:[sysman.admin.scripts.emx.rdb.documentation.installguide]toc.htm

    Completed installation.
    $
                                  

---

Previous Next

Copyright © 1996, 2008, Oracle. All rights reserved.

Contents Index