My Oracle Support Banner

OSM Upgrade 7.0.3 To 7.2.0.3 Failed (Doc ID 1495307.1)

Last updated on FEBRUARY 14, 2014

Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 and later
Information in this document applies to any platform.

Goal

During the upgrade from OSM 7.0.3 to OSM 7.2.0 the following errors encountered:

BUILD FAILED
C:\OSM7203\Database\dbinstall\install\instplb.xml:47: com.mslv.install.db.util.DbManagerException: ORA-12801: error signaled in parallel query server P044
ORA-00018: maximum number of sessions exceeded
sql: CREATE UNIQUE INDEX XPKOM_ORDER_FLOW_COORDINATOR_T ON om_order_flow_coordinator_t(
  COORD_SET_ID)
TABLESPACE ORDER_INDEX
LOCAL
PARALLEL NOLOGGINGNested Exception: ORA-12801: error signaled in parallel query server P044
ORA-00018: maximum number of sessions exceeded
Nested Exception: java.sql.SQLException: ORA-12801: error signaled in parallel query server P044
ORA-00018: maximum number of sessions exceeded

    at com.mslv.install.db.util.SqlHelper.execute(SqlHelper.java:198)
    at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processSqlStatement(AbstractObjectRootProxyImpl.java:408)
    at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processSql(AbstractObjectRootProxyImpl.java:397)
    at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processDDL(AbstractObjectRootProxyImpl.java:224)
    at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processObject(AbstractObjectRootProxyImpl.java:168)
    at com.mslv.install.db.processor.ApplicationProcessor.startRedefinition(ApplicationProcessor.java:519)
    at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processDDL(AbstractObjectRootProxyImpl.java:214)
    at com.mslv.install.db.load.impl.AbstractObjectRootProxyImpl.processObject(AbstractObjectRootProxyImpl.java:168)
    at com.mslv.install.db.processor.ApplicationProcessor.processMigrationActions(ApplicationProcessor.java:644)
    at com.mslv.install.db.processor.ApplicationProcessor.importApplicationItems(ApplicationProcessor.java:453)
    at com.mslv.install.db.processor.ApplicationProcessor.upgradeApplicationModel(ApplicationProcessor.java:748)
    at com.mslv.install.db.processor.ApplicationProcessor.importApplicationModel(ApplicationProcessor.java:143)
    at com.mslv.install.db.ImportDBTask.execute(ImportDBTask.java:39)
    at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
    at sun.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
    at org.apache.tools.ant.Task.perform(Task.java:348)
    at org.apache.tools.ant.Target.execute(Target.java:390)
    at org.apache.tools.ant.Target.performTasks(Target.java:411)
    at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1397)
    at org.apache.tools.ant.Project.executeTarget(Project.java:1366)
    at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
    at org.apache.tools.ant.Project.executeTargets(Project.java:1249)
    at com.mslv.oms.installation.AntExecAction.run(AntExecAction.java:352)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: ORA-12801: error signaled in parallel query server P044
ORA-00018: maximum number of sessions exceeded

   

Solution

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
Goal
Solution
References


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