Skip Headers
Oracle® Database System Administration Guide
10g Release 2 (10.2) for IBM z/OS (OS/390)

Part Number B25398-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

13 Oracle Enterprise Manager Management Agent

This chapter introduces the Oracle Enterprise Manager Management Agent, and provides configuration information.

The following topics are included:

13.1 Overview

The Oracle Management Agent runs jobs and events sent by the Oracle Enterprise Manager and can start up and shut down a database. It can function regardless of the status of the network connection, and it can run even if the database is down. It enables the database abministrator to monitor and control a database from a central location on the network.

The Management Agent is controlled using a command in the z/OS UNIX System Services shell environment. Currently, it is the only component of Oracle Enterprise Manager that is implemented for Oracle Database for z/OS. For more information on the Management Agent, refer to the Oracle Enterprise Manager Book Set.

13.2 Configuring the Management Agent

The Management Agent is installed with Oracle Database for z/OS. Oracle Universal Installer also configures most of the required parameters.

For the Management Agent to work correctly on z/OS, the following changes must be made to the system:

To complete the configuration, the following three files need additional customization:

<?xml version = "1.0"?>
<Targets AGENT_SEED="153361320">
 <Target TYPE="oracle_emd" NAME="local_host:port" VERSION="1.0"
 <Target TYPE="host" NAME="local_host" VERSION="1.0"/>
 <Target TYPE="oracle_database" NAME="DB_sid" VERSION="1.0">
  <Property NAME="MachineName" VALUE="local_host"/>
  <Property NAME="Port" VALUE="DB_port"/>
  <Property NAME="SID" VALUE="DB_sid"/>
  <Property NAME="ConnectDescriptor" VALUE="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(local_host)(PORT=DB_port)))(CONNECT_DA TA=(SID=DB_sid)))"/>
  <Property NAME="OracleHome" VALUE="oracle_home"/>
  <Property NAME="UserName" VALUE="DBSNMP"/>
  <Property NAME="password" VALUE="password" ENCRYPTED="FALSE"/>
  <Property NAME="Role" VALUE="NORMAL"/>
 </Target>
</Targets>

Variables for the previous example are defined as follows:

Table 13-1 Variable Descriptions for Code Example

Variable Description

AGENT_SEED=

The value of this parameter should be the same as that of the agentseed parameter in the emd.properties file

local_host

Host of the EMD_URL

port

Port number of the EMD_URL

oracle_database

Oracle instance on the local system or a remote system


The following variables for the previous example can be obtained from the tnsnames.ora file for the instance being monitored. They are defined as follows:

Table 13-2 Variable Descriptions for Code Example

Variable Description

local_host

Local host name of the system (for example, mvs05.us.oracle.com)

DB_port

Port on which the instance is listening

DB_sid

Instance ID of the Oracle instance. Corresponds to the dbname parameter in the init.ora file

oracle_home

Location of the Oracle database software

UserName

DBSNMP database user account

password

DBSNMP database user account password

Once the Management Agent starts up, it alters the targets.xml file to encrypt this password.


13.3 Controlling the Management Agent

You use the emctl command to control the Management Agent. For a description of this and other Management Agent commands, refer to the Oracle Enterprise Manager Advanced Configuration manual.

To issue this command, first log in to the z/OS UNIX System Services environment as the user who owns the Management Agent code. This user also needs DBA privileges.

Set up environment variables in the ENV file located in the Oracle home directory.

To start the Management Agent, use the following command:

$ emctl start agent

To query the status of agent, use the following command:

$ emctl status agent

To upload the information of Management Agent to the Management Service, use the following command:

$ emctl upload

The host information appears at the Management Service location. you need to upload the information only if the status of the agent is not automatically updated.

To stop the Management Agent, use the following command:

$ emctl stop agent

The log files and tracing information will be written to the ORACLE_HOME/sysman/log file.