Hi,
Oracle Version : 10.2.0.1
Operating system: Linux
When i saw the status of the dbconsole it is working fine.But when i am trying to connect to OEM i was unable to connect .
[oracle@vtl3199db ~]$ emctl status dbconsole
TZ set to Asia/Calcutta
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://vtl3199db:1158/em/console/aboutApplication
Oracle Enterprise Manager 10g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/10.2.0/db_1/vtl3199db_capture/sysman/log
[oracle@vtl3199db ~]$
And the log file contains
2009-09-29 15:48:35,736 [SeverityLoad http://vtl3199db:3938/emd/main] ERROR eml.XMLLoader markFileAsError.733 - Failed to load B0000000001.xml because of errors; moving to errors directory
2009-09-29 15:48:35,934 [HttpRequestHandler-7037649] ERROR eml.FxferRecv doPost.817 - Upload repsonse header :-ERROR-400|ORA-01861: literal does not match format string
-
2009-09-29 16:03:03,203 [XMLLoader0 00000000015.xml] ERROR XMLLoader.Splitter onEndUpload.1600 - Failed to commit last upload times..Exception caught.. ORA-01861: literal does not match format string
2009-09-29 16:03:03,204 [XMLLoader0 00000000015.xml] WARN eml.XMLLoader LoadFiles.611 - Marking the file for retry : 00000000015.xml after receiving exception : ORA-01861: literal does not match format string
2009-09-29 16:03:03,205 [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:1575)
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)
2009-09-29 16:03:03,209 [XMLLoader0] WARN eml.XMLLoader run.1218 - Resetting connection upon receiving an ORA-01861 : YYYY-MM-DD HH24:MI:SS