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
GOSTARIA DE UM MANUAL SOBRE ADMINISTRAÇÃO DE BANCO DE DADOS 9I
Uma boa dica eh ums cds de videos Aulas tem no mercadolivre.