My Oracle Support Banner

EM 13c : OMSCA Recover Failed With ORA-25153: Temporary Tablespace is Empty (Doc ID 3024031.1)

Last updated on MAY 21, 2024

Applies to:

Enterprise Manager Base Platform - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In Enterprise Manager (EM) Cloud Control 13c, while trying to migrate OMS from one Host to another host with different Host name, at PluginCA step, it is failing with the below error:

OMS_HOME/cfgtoollogs/pluginca/gcinstall_<timestamp>/configplugin_deploy_timestamp.trc

2024-05-20 22:37:31,603 [EMMetadataService:Thread-17] INFO sysman.PostMRSLogger - Done generating intermediate XSD at <OMS_INSTANCE_HOME>/em/EMGC_OMS1/sysman/tmp/Intermediate_xsds/eventSpecificCustmzn/internal_addon/event_specific_custmzn.xsd_internal_addon from stream sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@55af4cb1
2024-05-20 22:37:31,616 [EMMetadataService:Thread-21] INFO sysman.PostMRSLogger - Done generating intermediate XSD at <OMS_INSTANCE_HOME>/em/EMGC_OMS1/sysman/tmp/Intermediate_xsds/storeTargetType/internal_addon/TargetMetadata.xsd_internal_addon from stream sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@3c13896b
2024-05-20 22:37:31,625 [EMMetadataService:Thread-12] INFO sysman.PostMRSLogger - Done generating intermediate XSD at <OMS_INSTANCE_HOME>/em/EMGC_OMS1/sysman/tmp/Intermediate_xsds/ComparisonTemplate/internal_addon/ecm_comparison_template.xsd_internal_addon from stream sun.net.www.protocol.jar.JarURLConnection$JarURLInputStream@fdf00e0
2024-05-20 22:37:31,635 [EMMetadataService:Thread-17] ERROR sysman.PostMRSLogger - ERROR in customization registration ! Could not save customization data to repository. Please ensure that the corresponding eventClass is loaded correctly before registering this xml.ORA-25153: Temporary Tablespace is Empty

java.sql.SQLException: ORA-25153: Temporary Tablespace is Empty

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:456) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:451) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8TTILob.processError(T4C8TTILob.java:838) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4C8TTIClob.createTemporaryLob(T4C8TTIClob.java:543) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.T4CConnection.createTemporaryClob(T4CConnection.java:4653) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.sql.CLOB.createTemporary(CLOB.java:789) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatement.setStringForClobCritical(OraclePreparedStatement.java:5066) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OracleCallableStatement.setStringForClob(OracleCallableStatement.java:2518) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.driver.OraclePreparedStatementWrapper.setStringForClob(OraclePreparedStatementWrapper.java:1193) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.sysman.core.app.events.parser.EventSpecificCustmznParserHandler.saveCustXMLInRepository(EventSpecificCustmznParserHandler.java:678) [emCoreConsole.jar:?]
at oracle.sysman.core.app.events.parser.EventSpecificCustmznParserHandler.validateAndSaveXml(EventSpecificCustmznParserHandler.java:647) [emCoreConsole.jar:?]
at oracle.sysman.core.app.events.parser.EventSpecificCustmznParserHandler.parse(EventSpecificCustmznParserHandler.java:407) [emCoreConsole.jar:?]
at oracle.sysman.core.app.events.parser.EventSpecificCustmznParserHandler.parse(EventSpecificCustmznParserHandler.java:161) [emCoreConsole.jar:?]
at oracle.sysman.core.common.extensibility.metadata.EMMetadataServiceInfo.parseMdInstance(EMMetadataServiceInfo.java:867) [emCoreCommon.jar:?]
at oracle.sysman.core.common.extensibility.metadata.EMMetadataServiceInfo.registerPostRepSchemaMetadata(EMMetadataServiceInfo.java:456) [emCoreCommon.jar:?]
at oracle.sysman.core.common.extensibility.metadata.EMMetadataServiceInfo.registerMetadataForPlugin(EMMetadataServiceInfo.java:344) [emCoreCommon.jar:?]
at oracle.sysman.core.common.extensibility.metadata.MRSExecutor.run(MRSExecutor.java:100) [emCoreCommon.jar:?]
at oracle.sysman.util.threadPoolManager.WorkerThread.run(Worker.java:311) [emCoreSDKImpl.jar:?]
2024-05-20 22:37:31,641 [EMMetadataService:Thread-17] ERROR sysman.PostMRSLogger - Error parsing event specific cust XML
oracle.sysman.core.app.events.parser.EventClassParseException: ERROR in event specific customization registration ! SQLException
at oracle.sysman.core.app.events.parser.EventSpecificCustmznParserHandler.saveCustXMLInRepository(EventSpecificCustmznParserHandler.java:694) ~[emCoreConsole.jar:?]
at oracle.sysman.core.app.events.parser.EventSpecificCustmznParserHandler.validateAndSaveXml(EventSpecificCustmznParserHandler.java:647) ~[emCoreConsole.jar:?]
at oracle.sysman.core.app.events.parser.EventSpecificCustmznParserHandler.parse(EventSpecificCustmznParserHandler.java:407) ~[emCoreConsole.jar:?]
at oracle.sysman.core.app.events.parser.EventSpecificCustmznParserHandler.parse(EventSpecificCustmznParserHandler.java:161) [emCoreConsole.jar:?]
at oracle.sysman.core.common.extensibility.metadata.EMMetadataServiceInfo.parseMdInstance(EMMetadataServiceInfo.java:867) [emCoreCommon.jar:?]
at oracle.sysman.core.common.extensibility.metadata.EMMetadataServiceInfo.registerPostRepSchemaMetadata(EMMetadataServiceInfo.java:456) [emCoreCommon.jar:?]
at oracle.sysman.core.common.extensibility.metadata.EMMetadataServiceInfo.registerMetadataForPlugin(EMMetadataServiceInfo.java:344) [emCoreCommon.jar:?]
at oracle.sysman.core.common.extensibility.metadata.MRSExecutor.run(MRSExecutor.java:100) [emCoreCommon.jar:?]
at oracle.sysman.util.threadPoolManager.WorkerThread.run(Worker.java:311) [emCoreSDKImpl.jar:?]
Caused by: java.sql.SQLException: ORA-25153: Temporary Tablespace is Empty

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.