Enterprise Manager 10g – Database Control

2

Posted on : 27-04-2006 | By : .rafa | In : Banco de Dados, Oracle

Ae pessoal estava tendo um problema com o Enterprise Manager 10g - Database Control, onde instalei com o meu linux RedHat AS4 como localhost o nome da maquina e depois fui alterar para o nome correto e todas as configurações da rede.
O site de administração do Oracle não logava mais e pelo visto ele nao usa o listner e tnsnames do servidor e sim... outros arquivos para conexões do site.
Como ontem acabei descobrindo como alterar isto vou mostrar aqui.
Variaveis de ambiente:
ORACLE_BACKUP=/u01/backup
ORACLE_HOME=/u01/app/oracle/product/10.2.0
ORACLE_SID=orcLnx5
HOSTNAME=servOrcLnx5

1º passo
dentro do diretório $ORACLE_HOME/$HOSTNAME_$ORACLE_SID/sysman/emd/
editei o arquivo <target.xml> e os campos em VERDE sãos os que podem ser alterados
<Targets AGENT_SEED="941217312">
<Target TYPE="oracle_emd" NAME="servOrcLnx5:3938"/>
<Target TYPE="host" NAME="servOrcLnx5"/>
<Target TYPE="oracle_database" NAME="orcLnx5">
<Property NAME="MachineName" VALUE="servOrcLnx5"/>
<Property NAME="Port" VALUE="1521"/>
<Property NAME="SID" VALUE="orcLnx5"/>
<Property NAME="OracleHome" VALUE="/u01/app/oracle/product/10.2.0"/>
<Property NAME="UserName" VALUE="1988243f1da4e5c2" ENCRYPTED="TRUE"/>
<Property NAME="password" VALUE="d75209823f94369a" ENCRYPTED="TRUE"/>
</Target>
<Target TYPE="oracle_listener" NAME="LISTENER_servOrcLnx5">
<Property NAME="Machine" VALUE="servOrcLnx5"/>
<Property NAME="LsnrName" VALUE="LISTENER"/>
<Property NAME="Port" VALUE="1521"/>
<Property NAME="OracleHome" VALUE="/u01/app/oracle/product/10.2.0"/>
<Property NAME="ListenerOraDir" VALUE="/u01/app/oracle/product/10.2.0/network/admin"/>
</Target>
</Targets>

2º passo
dentro do diretório $ORACLE_HOME/$HOSTNAME_$ORACLE_SID/sysman/config/
A. editei o arquivo <emd.proprieties> e os campos em VERDE sãos os que podem ser alterados

#
# perl executable directory
#
perlBin=/u01/app/oracle/product/10.2.0/perl/bin

#
# script directory
#
scriptsDir=/u01/app/oracle/product/10.2.0/sysman/admin/scripts

#
# emd Root directory(read-only location). Metrics should not create files
# under this directory
#
emdRoot=/u01/app/oracle/product/10.2.0

#
# agent Root directory(writeable).
# Use this property to base any temporary file creation.
#
agentStateDir=/u01/app/oracle/product/10.2.0/servOrcLnx5_orcLnx5

#
# Chronos root directory
#
chronosRoot=/u01/app/oracle/product/10.2.0/servOrcLnx5_orcLnx5/sysman/emd/chronos

#
# OMS Upload URL
#
# if there is no receiving OMS or if you wish to disable the UploadManager
# please set this value to empty or comment out below line
#
REPOSITORY_URL=http://servOrcLnx5:1158/em/upload/

#
# Proxy settings used for fetchlets. not applicable for uploader.
#
#proxyHost=www-proxy.us.oracle.com
#proxyPort=80
#dontProxyFor=.us.oracle.com

#
# If it is necessary to go through an http proxy server to get to the
# repository, uncomment the following two lines
#
#REPOSITORY_PROXYHOST=
#REPOSITORY_PROXYPORT=
#REPOSITORY_PROXYREALM=%EM_REPOS_PROXYREALM%
#REPOSITORY_PROXYUSER=%EM_REPOS_PROXYUSER%
#REPOSITORY_PROXYPWD=%EM_REPOS_PROXYPWD%

#
# This string is used by the agent to connect to remote targets
# ***IMPORTANT*** Do not change the contents of this setting. Only the
# install should modify this value.
#
agentSeed=941217312

#
# This string is used by the agent to determine which algorithm to use for encrypted data
# The string value will be same as the release version
#
agentVersion=10.1.0.4.0

#
# How long, in minutes, collector will wait until next load.
#
UploadInterval=5

#
# If an upload fails, we want to backoff by UploadFailBackoff
# percentage more each time for each successive upload failure
# e.g. if we start the retry at 1 minute. If we fail in our next
# upload attempt, we try again 1minute 12 seconds later etc.
#
#

UploadFailBackoffPct= 20

#
# Maximum amount of time, in seconds, upload will wait for response from
# repository before timing out.
# 0 means infinite.
#
UploadTimeout=1800

#
# Timeout for upload a file, HealthMonitor will abort the EMD process if
# UploadManager does not finish uploading one file within this time
# Unit is minite, the default value is 1 hour ( 15 Min)
#
#UploadMaxTime=15

#
# How big the file the collector will upload (in KB)
# the actual file size could be slightly bigger.
# This is only a guidance.
#
UploadFileSize=2048

#
# The maximum number of megabytes(MB) the upload manager will support in the
# upload directory before temporarily being disabled
#
UploadMaxBytesXML=50

#
# The maximum number of files the upload manager will support in the
# upload directory before temporarily being disabled
#
UploadMaxNumberXML=5000

#
# The maximum amount (%) of disk space that can be used on the EMD filesystem
# before the following is disabled:
# - Collection of data (upload manager)
# - Logging and tracing

UploadMaxDiskUsedPct=98

#
# The amount (%) of disk space that can be used on the EMD filesystem
# before the following is re-enabled after being disabled previously:
# - Collection of data (upload manager)
# - Logging and tracing

UploadMaxDiskUsedPctFloor=95

# Time out for the Agent to think that the access to the database could be
# hung. The Agent would not allow more threads to go and hang with a database
# if any one access to the database does not return within DbHangTimeout
# seconds.
# The more the timeout more the possibility of allowing more threads
# to be hung in the EMD with a bad database.it is specified in seconds.
#DbHangTimeout=200

#
# The script to run if disk space usage exceeds parameters or if certain other
# error conditions occur.
#
#emdFailureScript=emdfail.command

#
# The location of the file that contains the root certificate.
#
emdRootCertLoc=/u01/app/oracle/product/10.2.0/servOrcLnx5_orcLnx5/sysman/config/b64LocalCertificate.txt
internetCertLoc=/u01/app/oracle/product/10.2.0/servOrcLnx5_orcLnx5/sysman/config/b64InternetCertificate.txt

#
# The download URL for the EMD Oracle Wallet and its local file location.
#
# Note: Ensure that this URL references a valid port number at which the
# console is available on http
#
emdWalletSrcUrl=http://servOrcLnx5:1158/em/wallets/emd
emdWalletDest=/u01/app/oracle/product/10.2.0/servOrcLnx5_orcLnx5/sysman/config/server

#
# The email address for out-of-band notifications
#
emd_email_address=rafael@xxxxxx.com.br
emd_email_gateway=192.168.x.x

#
# The return email address for out-of-band notifications
#
emd_from_email_address=

#
# EMD main servlet URL
#
EMD_URL=http://servOrcLnx5:3938/emd/main
#
# Whether the EMD should listen on all NICs on the current host (the default)
# or just the NIC associated with the hostname in EMD_URL
#
AgentListenOnAllNICs=TRUE

#
# This parameter indicates the thread model to use. uncomment one of the
# following ThreadPoolModel line to indicate the model, agent need to use.
# SMALL if number of targets is less than 11.
# MEDIUM if number of targets is from 11 to 50.
# LARGE if number of targets is greater than 50.
# This parameter can be overriden by 'MaxThreads' which indicates the maximum
# number of threads that CEMD can have running at any point of time. User can
# mostly use the other parameter ThreadPoolModel to indicate what model for the
# agent to use.
#
# ThreadPoolModel = SMALL
# ThreadPoolModel = MEDIUM
# ThreadPoolModel = LARGE
#

# This parameter indicates the stack size, threads have to be created with.
# we can set it to 0 to use the OS default value.
#
# In some version of solaris(such as 2.9 ) specify a stack size may cause Java Hotspot warning
# when JVM is used.
#
NormalThreadStackSize=0
#

#Signals that users want to ignore.
#It can be one or combination of SIGTERM, SIGINT
# The signals can listed with ',' as delimiter.
#IgnoreSignals=

#
# This property is NO LONGER USED for host config collection (instead, hostConfigClasspath is used).
# If noone else uses it, it can be removed.
#
ouiLoc=/u01/app/oracle/product/10.2.0/oui

#
# Classpath for host config collection
# VERY IMPORTANT NOTE: If you change the host config classpath entries in this section, you HAVE
# to change the HOST_CONFIG_TEST_CLASSPATH entry in the utl/emdwqaenv file too.
#
# NOTE: if the location of emd_java.jar and/or log4j-core.jar is changed
# make sure that appropriate changes are also made
# to the CLASSPATH variable in this file if necessary

# PORTING NOTE: Check OUI-required jar files for OUI APIs to work. They could be different on your platform.
# Also, our version of xmlparserv2.jar must be compatible with the one OUI expects (both OUI and ECM use XML parser).
hostConfigClasspath=/u01/app/oracle/product/10.2.0/oui/jlib/xmlparserv2.jar:/u01/app/oracle/product/10.2.0/oui/ jlib/OraInstaller.jar:/u01/app/oracle/product/10.2.0/oui/jlib/srvm.jar:/u01/app/oracle/product/10.2.0/oui/jlib/ share.jar:/u01/app/oracle/product/10.2.0/sysman/jlib/emd_java.jar:/u01/app/oracle/product/10.2.0/sysman/jlib/log4j-core.jar /> # JAVA HOME required for JavaExt metric calls
JAVA_HOME=/u01/app/oracle/product/10.2.0/jdk/jre

# CLASSPATH required for JavaExt metric calls
CLASSPATH=/u01/app/oracle/product/10.2.0/sysman/jlib/emd_java.jar:/u01/app/oracle/product/10.2.0/opmn/lib/ons.jar:/u01/ app/oracle/product/10.2.0/lib/xmlparserv2.jar:/u01/app/oracle/product/10.2.0/sysman/jlib/log4j-core.jar:/u01/app/oracle/p roduct/10.2.0/oc4j/j2ee/home/lib/http_client.jar:/u01/app/oracle/product/10.2.0/lib/dms.jar:/u01/app/oracle/product/ 10.2.0/lib/dmsEmd.jar:/u01/app/oracle/product/10.2.0/jlib/share.jar:/u01/app/oracle/product/10.2.0/jdbc/lib/ ojdbc14dms.jar:/u01/app/oracle/product/10.2.0/jlib/jssl-1_1.jar:/u01/app/oracle/product/10.2.0/jlib/ javax-ssl-1_1.jar:/u01/app/oracle/product/10.2.0/jlib/ojmisc.jar:/u01/app/oracle/product/10.2.0/lib/em_test.jar:/u01/ app/oracle/product/10.2.0/jlib/ojmisc.jar:/u01/app/oracle/product/10.2.0/jlib/repository.jar:/u01/app/oracle/ product/10.2.0/opmn/lib/optic.jar

#
# this is the java option
#
#JAVA_OPTIONS=-Xmx128m

#
# These are the optional Java flags for the in-process Java
# Native Interface (JNI)
#
agentJavaDefines=-Doracle.dms.refresh.wait.time=1000 -DUrlTiming.UseJSSE=true

#
# When set to true, the emd.log and emd.trc file will be appended by a pid
# For example:
# emd_15789.log
# emd_15789.trc
#
# By default, it is not set for regression test purpose.
#
# After installed, please uncomment this line because when EMD is restarted,
# previous log information will be lost if not set to true.
#
#LogFileWithPID=true

# Default log file maximum size before rolling in Kilobytes
LogFileMaxSize=4096

# Maximum number of log file roll files to maintain before deletion
LogFileMaxRolls=4

# Default trace file maximum size before rolling in Kilobytes
TrcFileMaxSize=4096

# Maximum number of trace file roll files to maintain before deletion
TrcFileMaxRolls=4

#
# To enable the metric browser, uncomment the following line
# This is a reloadable parameter
#
#enableMetricBrowser=true

#
# To disable Remote operations (non-reachable agent) uncomment the following
# line:
#
#disableRemoteOperations=true

#
# add an additional admin path from which the agent will read additional
# target metadata. The specified path should have the mandatory 4 directories
# under it. 1. metadata 2. scripts 3. default_collection 4. discover
#
#altAdminPath=

#
# The health monitor executes callbacks in a separate thread. if for some
# reason the threads spawned from health monitor to execute callbacks are
# hung, the agent could run out of resource and freeze.
# so when the current thread count spawned from the Health monitor reaches
# this limit, the agent is bounced. the default is set to 5.
#
#MaxHealthMonitorThreads=5
#

#
# dynamicPropsComputeTimeout default to 30s
dynamicPropsComputeTimeout=60

#
# emagent perl tracing levels
# supported levels: DEBUG, INFO, WARN, ERROR
# default level is ERROR
#
EMAGENT_PERL_TRACE_LEVEL=ERROR

#
# other optional parameters for perl tracing
#
# EMAGENT_PERL_TRACE_DIR default to $ORACLE_HOME/sysman/log
#EMAGENT_PERL_TRACE_DIR=
#
# EMAGENT_PERL_TRACE_FILESIZE default to 5M
#EMAGENT_PERL_TRACE_FILESIZE=5
#

#
# this section define the logging level for each component,
# it is "reloadable", you can change the level at runtime to reset
# the logging level, but if you remove the line, it will not be
# changed.

tracelevel.main=WARN
tracelevel.emSDK.xml=WARN
tracelevel.emSDK.utl=WARN
tracelevel.ResMonitor=WARN
tracelevel.Dispatcher=WARN
tracelevel.ThreadPool=WARN
tracelevel.pingManager=WARN
tracelevel.collector=WARN
tracelevel.http=WARN
tracelevel.ssl=WARN
tracelevel.ssl.io=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

# The following three properties are for HTTP timeout
# Timeout value for reading Http primary header, default is 30 seconds.
httpTimeoutPrimaryHeader=30

# Timeout value for reading http secondary headers, default is 30 seconds
httpTimeoutSecondaryHeaders=30

# Timeout value for reading http body, default is 60 seconds.
httpTimeoutBody=60
omsRecvDir=/u01/app/oracle/product/10.2.0/servOrcLnx5_orcLnx5/sysman/recv
agentTZRegion=Brazil/East

<fim do arquivo>
E faça a mesma verificação no arquivos
emomslogging.properties

emagentlogging.properties

emoms.properties

Comments

GOSTARIA DE UM MANUAL SOBRE ADMINISTRAÇÃO DE BANCO DE DADOS 9I

Uma boa dica eh ums cds de videos Aulas tem no mercadolivre.

Post a comment

*