Enterprise Manager

Running local (not GC) EM in a 10.2.0.1 DB and the exception at the bottom of this post started occurring regularly in emoms.log about 15 days ago, after having had no problems for the prior 15 months. The start of this error seems to coincide with alert conditions (i.e. tablespace full) not being reported. According to agent status, uploads are occurring regularly.

Obviously, something in the environment changed (although no files in .../sysman/config have been changed). Any help would be greatly appreciated.

Thanks,

David


------------------------------------------------------------------------------------------------
status agent output
------------------------------------------------------------------------------------------------
emctl status agent
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 10.1.0.4.1
OMS Version : 10.1.0.4.0
Protocol Version : 10.1.0.2.0
Agent Home : /orasw/app/oracle/product/10.2.0/....
Agent binaries : /orasw/app/oracle/product/10.2.0
Agent Process ID : 19766
Parent Process ID : 17878
Agent URL : http://....:3938/emd/main
Started at : 2007-10-25 14:44:19
Started by user : oracle
Last Reload : 2007-10-25 14:57:49
Last successful upload : 2007-10-26 12:48:38
Total Megabytes of XML files uploaded so far : 10.91
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0.00
Available disk space on upload filesystem : 66.07%
---------------------------------------------------------------
Agent is Running and Ready


------------------------------------------------------------------------------------------------
status dbconsole output
------------------------------------------------------------------------------------------------
emctl status dbconsole <
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://...:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.

------------------------------------------------------------------------------------------------
Snippet from emoms.log
------------------------------------------------------------------------------------------------
2007-10-10 12:59:36,842 [XMLLoader0 00000325526.xml] WARN eml.XMLLoader LoadFiles.611 - Marking the file for retry : 00000325526.xml after receiving exception : ORA-01861: literal does not match format string

2007-10-10 12:59:36,843 [XMLLoader0] ERROR eml.XMLLoader run.1184 - Exception caught while loading: ORA-01861: literal does not match format string

java.sql.SQLException: ORA-01861: literal does not match format string

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:954)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1260)
at oracle.jdbc.driver.OraclePreparedStatement.sendBatch(OraclePreparedStatement.java:3607)
at oracle.sysman.util.jdbc.PreparedStatementWrapper.sendBatch(PreparedStatementWrapper.java:119)
at oracle.sysman.emdrep.dbjava.loader.XMLLoaderContext.flushAllStatements(XMLLoaderContext.java:823)
at oracle.sysman.emdrep.dbjava.loader.XMLDocumentSplitter.onEndUpload(XMLDocumentSplitter.java:1471)
at oracle.sysman.emdrep.dbjava.loader.XMLDocumentSplitter.endElement(XMLDocumentSplitter.java:779)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1211)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:300)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:267)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:149)
at oracle.sysman.emdrep.dbjava.loader.XMLDocumentSplitter.split(XMLDocumentSplitter.java:373)
at oracle.sysman.emdrep.dbjava.loader.XMLLoaderContext.loadFromStream(XMLLoaderContext.java:1082)
at oracle.sysman.emdrep.dbjava.loader.XMLLoader.LoadFile(XMLLoader.java:443)
at oracle.sysman.emdrep.dbjava.loader.XMLLoader.LoadFiles(XMLLoader.java:596)
at oracle.sysman.emdrep.dbjava.loader.XMLLoader.run(XMLLoader.java:1150)
at java.lang.Thread.run(Thread.java:534)