Experiences with Oracle Database 10g on z/OS

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.