I have an Oracle 10.2.0.0
without Grid Control on a Solaris 10.
But on the main screen it says something like (translated) "agent connection with instance" and "status: not available"
1. What agent is this? I think the emagent, that gets all the data from the instance to show metrics on the website. Or is it some gc agent, that's often talked about herein?
2. When I restart the dbconsole, everything looks fine in the em. But after several minutes, the error is shown and the two metrics of the CPU and the active sessions show no data any more.
Everything works fine after the start of the dbconsole. Why does this error come after a few minutes?
I already checked the following (some according to threads I found here in the forum):
1. emctl status dbconsole --> positiv
2. emdctl status agent -->
Error opening logfile for output in nmeula_new
Error opening logfile for output in nmeula_new
Error connecting to http://oraserver:/emd/main/
3. tail /oracle/ora10g/sysman/log/emdctl.trc -->
2010-12-15 10:28:52 Thread-1 WARN http: snmehl_connect: connect failed to (oraserver:3938): Verbindung abgewiesen (error = 146)
(translated: Connection refused)
4. tail /oracle/ora10g/oradb/sysman/log/emagent.trc -->
2010-12-16 08:48:18 Thread-10999 ERROR fetchlets.wbem: No username specified for WBEM fetchlet.
2010-12-16 08:48:18 Thread-10999 ERROR engine: [host,oraserver,UserResourceUsage] : nmeegd_GetMetricData failed : No username specified for WBEM fetchlet.
2010-12-16 08:48:26 Thread-11002 ERROR fetchlets.sql: Obtained more than 1 row for getting session id and serial number. hence discarding it..
2010-12-16 08:51:35 Thread-11032 ERROR fetchlets.sql: Obtained more than 1 row for getting session id and serial number. hence discarding it..
5. tail /oracle/ora10g/oradb/sysman/log/emagent.log -->
2010-12-15 14:33:49 Thread-1 Starting Agent 10.1.0.4.1 from /oracle/ora10g (00701)
2010-12-15 14:33:50 Thread-1 EMAgent started successfully (00702)
6. the contents of /oracle/ora10g/oradb/sysman/config/emd.properties -->
perlBin=/oracle/ora10g/perl/bin
scriptsDir=/oracle/ora10g/sysman/admin/scripts
emdRoot=/oracle/ora10g
agentStateDir=/oracle/ora10g
chronosRoot=/oracle/ora10g/sysman/emd/chronos
REPOSITORY_URL=http://oraserver:4889/em/upload/
agentSeed=683500608
agentVersion=10.1.0.4.0
UploadInterval=5
UploadFailBackoffPct= 20
UploadTimeout=1800
UploadFileSize=2048
UploadMaxBytesXML=50
UploadMaxNumberXML=5000
UploadMaxDiskUsedPct=98
UploadMaxDiskUsedPctFloor=95
emdRootCertLoc=/oracle/ora10g/sysman/config/b64LocalCertificate.txt
internetCertLoc=/oracle/ora10g/sysman/config/b64InternetCertificate.txt
emdWalletSrcUrl=http://oraserver:4889/em/wallets/emd
emdWalletDest=/oracle/ora10g/sysman/config/server
emd_email_address=
emd_email_gateway=
emd_from_email_address=
EMD_URL=http://oraserver:/emd/main/
AgentListenOnAllNICs=TRUE
NormalThreadStackSize=0
ouiLoc=/oracle/ora10g/oui
hostConfigClasspath=/oracle/ora10g/oui/jlib/xmlparserv2.jar:/oracle/ora10g/oui/jlib/OraInstaller.jar:/oracle/ora10g/oui/jlib/srvm.jar:/oracle/ora10g/oui/jlib/share.jar:/oracle/ora10g/sysman/jlib/emd_java.jar:/oracle/ora10g/sysman/jlib/log4j-core.jar
JAVA_HOME=/oracle/ora10g/jdk/jre
CLASSPATH=/oracle/ora10g/sysman/jlib/emd_java.jar:/oracle/ora10g/opmn/lib/ons.jar:/oracle/ora10g/lib/xmlparserv2.jar:/oracle/ora10g/sysman/jlib/log4j-core.jar:/oracle/ora10g/oc4j/j2ee/home/lib/http_client.jar:/oracle/ora10g/lib/dms.jar:/oracle/ora10g/lib/dmsEmd.jar:/oracle/ora10g/jlib/share.jar:/oracle/ora10g/jdbc/lib/ojdbc14dms.jar:/oracle/ora10g/jlib/jssl-1_1.jar:/oracle/ora10g/jlib/javax-ssl-1_1.jar:/oracle/ora10g/jlib/ojmisc.jar:/oracle/ora10g/lib/em_test.jar:/oracle/ora10g/jlib/ojmisc.jar:/oracle/ora10g/jlib/repository.jar:/oracle/ora10g/opmn/lib/optic.jar
agentJavaDefines=-Doracle.dms.refresh.wait.time=1000 -DUrlTiming.UseJSSE=true
LogFileMaxSize=4096
LogFileMaxRolls=4
TrcFileMaxSize=4096
TrcFileMaxRolls=4
dynamicPropsComputeTimeout=60
EMAGENT_PERL_TRACE_LEVEL=ERROR
.
some tracelevel- settings
.
httpTimeoutPrimaryHeader=30
httpTimeoutSecondaryHeaders=30
httpTimeoutBody=60
What else can I do to determine and correct the error source?