110 Experiences Installing Oracle Database 10g on z/OS
8.1 Introduction to intelligent agents and OEM
Intelligent agents are autonomous because they function without requiring that
the Oracle Enterprise Manager console or Management Server be running. The
primary communications path from the Oracle Management Server to the
database instance is through the intelligent agent, the agent that services and
Oracle instances can run when the database is down. This allows the intelligent
agent to start and shut down instances. It can also perform administrative tasks
and run applications without direct intervention from the DBA. It can detect errors
and issue predetermined corrective actions to resolve the problem. All job and
event messages are queued, enabling the work to take place when the OMS is
not active.
8.2 Configuring the intelligent agent
The intelligent agent that ran in UNIX Systems Services is now known as the
Management Agent and has undergone significant changes. Among these are
the fact that the only parameter file that remains from the old setup is ORATAB.
There are two new configuration files that need to be modified, emd.properties
and target.xml.
As in the past the Management Agent is set to run independent of the network
connections to the Oracle Management Server (OMS) and the database it is
managing. What this means is that it continues to run and monitor the database
and environment even when not connected to OMS or the database. It needs to
function in this manner to allow it to know what is happening to the database
environment should the network go down, as well as working independent of the
database because it is used to manage the database.
Note: The configuration files contained in this document are only samples to be
used after modification for your environment.
Here is the environment we set up and the steps we completed to configure the
Oracle Management Agent on MVS03:
򐂰 The base Management Agent install is done by the Oracle Universal Installer
(OUI).
򐂰 Our .profile file contains the following:
export ORACLE_HOME=/oracle/v10gPB/OHome1
export ORA_NLS32=/oracle/v10gPB/OHome1/ocommon/nls/admin/data
export ORA_NLS33=$ORA_NLS32
export ORA_NLS=$ORA_NLS32
export TNS_ADMIN=$ORACLE_HOME
export ORATAB=$ORACLE_HOME/network/admin/oratab
Chapter 8. Installing the Intelligent Agent 111
export TWO_TASK="(ADDRESS=(PROTOCOL=XM)(SUBSYS=MGSS)(SERVICE=MG10))"
export LIBPATH=$ORACLE_HOME/lib:$LIBPATH
export PATH=$ORACLE_HOME/bin:$PATH
Note: $ORACLE_HOME is /oracle/v10gPB/OHome1.
ORATAB file will be in $ORACLE_HOME/network/admin/oratab
򐂰 There are three files that undergo configuration during the install process, but
will need more configuration:
emd.properties in $ORACLE_HOME/sysman/config
targets.xml will be entered with a very basic start in
$ORACLE_HOME/sysman/emd
oratab in $ORACLE_HOME/network/admin/oratab
򐂰 ORATAB remains the same as before:
MG10:/oracle/v10gPB/OHome1/:N
Where: MG10 is the database instance to be monitored.
/oracle/v10gPB/Ohome1 is the Oracle Home directory. N means the
database is not to be started when the agent is started.
򐂰 TARGE TS.XM L
Example 8-1 shows a sample of the TARGETS.XML file
Example 8-1 The TARGETS.XML file
<Targets AGENT_SEED="229596192">
<Targets TYPE="oracle_emd" NAME="mvs03.us.oracle.com:1571"
VERSION="1.0"/>
<Targets TYPE="host" NAME="mvs03.us.oracle.com" VERSION="1.0"/>
<Targets TYPE="oracle_database" NAME="MG10" VERSION="1.0">
<Property NAME="MachineName" VALUE="mvs03.us.orace.com"/>
<Property NAME="Port" VALUE="1569"/>
<Property NAME="SID" VALUE="MG10"/>
<Property NAME="ConnectDescriptor"
VALUE="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=mvs03.us
.oracle.com)(PORT=1569)))(CONNECT_DATA=(SID=MG10))"/>
<Property NAME="OracleHome" VALUE="ORACLE/v10gPB/OHome1/"/>
<Property NAME="Username" VALUE="DBSNMP"/>
<Property NAME="password" VALUE="DBSNMP" ENCRYPTED="FALSE"/>
<Property NAME="Role" VALUE="NORMAL"/>
</Targets>
</Targets>
112 Experiences Installing Oracle Database 10g on z/OS
򐂰 EMD.PROPERTIES:
Example 8-2 shows the entries in the file EMD.PROPERTIES.
Example 8-2 Sample EMD.PROPERTIES file
perlBin=/oracle/v10gPB/OHome1/perl/bin
scriptsDir=/oracle/v10gPB/OHome1/sysman/admin/scripts
emdRoot=/oracle/v10gPB/OHome1
agentStateDir=/oracle/v10gPB/OHome1
chronosRoot=/oracle/v10gPB/OHome1/sysman/emd/chronos
# This was one of the parmeters that needed configuration, it
points
# to the Oracle Management Server. This must be valid or the OMS
does
# not know about the agent
REPOSITORY_URL=http://OEM:7777/em/upload/
#proxyHost=www-proxy.us.oracle.com
#proxyPort=80
#dontProxyFor=.us.oracle.com
#REPOSITORY_PROXYHOST=
#REPOSITORY_PROXYPORT=
# This seed number must match the number in the target.xml
# This was also a field that was modified
agentSeed=229596192
agentVersion=10.1.0.2.0
UploadInterval=15
UploadFailBackoffPct= 20
UploadTimeout=1800
#UploadMaxTime=15
UploadFileSize=2048
UploadMaxBytesXML=50
UploadMaxNumberXML=5000
UploadMaxDiskUsedPct=98
UploadMaxDiskUsedPctFloor=95
#DbHangTimeout=200
#emdFailureScript=emdfail.command
emdRootCertLoc=/oracle/v10gPB/OHome1/sysman/config/b64LocalCertifica
te.txt
internetCertLoc=/oracle/v10gPB/OHome1/sysman/config/b64InternetCerti
ficate.txt
emdWalletSrcUrl=http://mvs03.us.oracle.com:4889/em/wallets/emd
emdWalletDest=/oracle/v10gPB/OHome1/sysman/config/server
emd_email_address=
emd_email_gateway=
emd_from_email_address=
Chapter 8. Installing the Intelligent Agent 113
# This was configured for this managment agent you need a port
#
EMD_URL=http://mvs03.us.oracle.com:1571/emd/main/
AgentListenOnAllNICs=TRUE
# ThreadPoolModel = SMALL
# ThreadPoolModel = MEDIUM
# ThreadPoolModel = LARGE
NormalThreadStackSize=0
#IgnoreSignals=
ouiLoc=/oracle/v10gPB/OHome1/oui
hostConfigClasspath=/oracle/v10gPB/OHome1/oui/jlib/xmlparserv2.jar:/
oracle/v10gPB/OHome1/oui/jlib/OraInstaller.jar:/oracle/v10gPB/OHome1
/oui/jlib/srvm.jar:/oracle/v10gPB/OHome1/oui/jlib/share.jar:/oracle/
v10gPB/OHome1/sysman/jlib/emd_java.jar:/oracle/v10gPB/OHome1/sysman/
jlib/log4j-core.jar
JAVA_HOME=/oracle/v10gPB/OHome1/jdk
CLASSPATH=/oracle/v10gPB/OHome1/sysman/jlib/emd_java.jar:/oracle/v10
gPB/OHome1/opmn/lib/ons.jar:/oracle/v10gPB/OHome1/lib/xmlparserv2.ja
r:/oracle/v10gPB/OHome1/sysman/jlib/log4j-core.jar:/oracle/v10gPB/OH
ome1/j2ee/home/lib/http_client.jar:/oracle/v10gPB/OHome1/lib/dms.jar
:/oracle/v10gPB/OHome1/lib/dmsEmd.jar:/oracle/v10gPB/OHome1/jlib/sha
re.jar:/oracle/v10gPB/OHome1/jdbc/lib/ojdbc14dms.jar:/oracle/v10gPB/
OHome1/jlib/jssl-1_1.jar:/oracle/v10gPB/OHome1/jlib/javax-ssl-1_1.ja
r:/oracle/v10gPB/OHome1/jlib/ojmisc.jar:/oracle/v10gPB/OHome1/lib/em
_test.jar:/oracle/v10gPB/OHome1/jlib/ojmisc.jar:/oracle/v10gPB/OHome
1/jlib/repository.jar:/oracle/v10gPB/OHome1/opmn/lib/optic.jar
#JAVA_OPTIONS=-Xmx128m
agentJavaDefines=-Doracle.dms.refresh.wait.time=1000
-DUrlTiming.UseJSSE=true
#LogFileWithPID=true
LogFileMaxSize=4096
LogFileMaxRolls=4
TrcFileMaxSize=4096
TrcFileMaxRolls=4
#enableMetricBrowser=true
#disableRemoteOperations=true
#altAdminPath=<additional admin path>
#MaxHealthMonitorThreads=5
#
EMAGENT_PERL_TRACE_LEVEL=ERROR
#EMAGENT_PERL_TRACE_DIR=
#EMAGENT_PERL_TRACE_FILESIZE=5
tracelevel.main=WARN
tracelevel.emSDK.xml=WARN
114 Experiences Installing Oracle Database 10g on z/OS
tracelevel.emSDK.utl=WARN
tracelevel.ResMonitor=WARN
tracelevel.Dispatcher=WARN
tracelevel.ThreadPool=WARN
tracelevel.pingManager=WARN
tracelevel.collector=WARN
tracelevel.http=WARN
tracelevel.blackouts=WARN
tracelevel.upload=WARN
tracelevel.command=WARN
tracelevel.reload=WARN
tracelevel.scheduler=WARN
tracelevel.Authentication=WARN
tracelevel.metadata=WARN
tracelevel.targets=WARN
tracelevel.TargetManager=WARN
tracelevel.engine=WARN
tracelevel.javaproc=WARN
tracelevel.vpxoci=WARN
tracelevel.javavm=WARN
tracelevel.fetchlets=WARN
tracelevel.fetchlets.os=WARN
tracelevel.fetchlets.osline=WARN
tracelevel.fetchlets.oslinetok=WARN
tracelevel.fetchlets.UDM=WARN
tracelevel.fetchlets.sql=WARN
tracelevel.fetchlets.url=WARN
tracelevel.fetchlets.urllines=WARN
tracelevel.fetchlets.urllinetoken=WARN
tracelevel.fetchlets.URLTiming=WARN
tracelevel.fetchlets.propEcho=WARN
tracelevel.fetchlets.readFromFile=WARN
tracelevel.fetchlets.readMultFromFile=WARN
tracelevel.fetchlets.throwable=WARN
tracelevel.fetchlets.resourceGrab=WARN
tracelevel.fetchlets.emSDK=WARN
agentTZRegion=PST
Note: There are several comments in the sample for this file. They have been
removed for this example to increase readablility. The comments remaining
are related to modifications made to the file.

Get Experiences with Oracle Database 10g on z/OS now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.