Error ERROR XMLLoader.Handler updateLobColumns.718 - Error in deleting temporary LOB files Closed LOB java.io.IOException: Closed LOB repeatedly stored in the OMS 10.2.0.5 file emoms.trc (Doc ID 1091332.1)

Last updated on AUGUST 22, 2013

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
Checked for relevance on 22-Aug-2013

Symptoms

In Enterprise Manager Grid Control 10.2.0.5, the following error is displayed repeatedly in the OMS file ORACLE_HOME/sysman/log/emoms.trc:

2011-06-17 12:06:25,328 [XMLLoader0 10000000012.xml] ERROR XMLLoader.Handler updateLobColumns.718 - Error in deleting temporary LOB files Closed LOB
java.io.IOException: Closed LOB
at oracle.jdbc.driver.DatabaseError.SQLToIOException(DatabaseError.java:569)
at oracle.jdbc.driver.OracleClobWriter.ensureOpen(OracleClobWriter.java:249)
at oracle.jdbc.driver.OracleClobWriter.flush(OracleClobWriter.java:180)
at oracle.sysman.emdrep.dbjava.loader.MultiTableInsertHandler.updateLobColumns(MultiTableInsertHandler.java:709)
at oracle.sysman.emdrep.dbjava.loader.MultiTableInsertHandler.handleRow(MultiTableInsertHandler.java:219)
at oracle.sysman.emdrep.dbjava.loader.XMLLoaderContext.handleSubDocument(XMLLoaderContext.java:2378)
at oracle.sysman.emdrep.dbjava.loader.XMLDocumentSplitter.endElement(XMLDocumentSplitter.java:931)
at oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1257)
at oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:314)
at oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:281)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:195)
at oracle.sysman.emdrep.dbjava.loader.XMLDocumentSplitter.split(XMLDocumentSplitter.java:481)
at oracle.sysman.emdrep.dbjava.loader.XMLLoaderContext.loadFromStream(XMLLoaderContext.java:1902)
at oracle.sysman.emdrep.dbjava.loader.XMLLoader.LoadFile(XMLLoader.java:613)
at oracle.sysman.emdrep.dbjava.loader.XMLLoader.LoadFiles(XMLLoader.java:754)
at oracle.sysman.emdrep.dbjava.loader.XMLLoader.run(XMLLoader.java:1417)
at java.lang.Thread.run(Thread.java:534)

Changes

The Enterprise Manager Grid Control was upgraded to 10.2.0.5.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms