Upgrade of the OSM Schema Failed With the Error - ORA-00922: missing or invalid option (Doc ID 1618349.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 to 7.3.5.0.0 [Release 7.2 to 7.3.0]
Information in this document applies to any platform.
July 15, 2015 Checking for relevance, this note is still useful
Sept 27, 2017 Checking for relevance

Symptoms

Patch OSM 7.2.0.8 installer could not upgrade existing OSM 7.2.0.4 schema because of the following errors:

16:21:56,415 DEBUG [DbApplicationInfo] procedure
16:21:56,415 DEBUG [DbApplicationInfo] function
16:21:56,415 DEBUG [DbApplicationInfo] packageBody
16:21:56,501 ERROR [ImportDBTask] Import of database model failed
com.mslv.install.db.util.DbManagerException: Cannot create database schema.Nested Exception: ORA-00922: missing or invalid option
Nested Exception: java.sql.SQLException: ORA-00922: missing or invalid option

at com.mslv.install.db.application.definition.DbSchema.createSchema(DbSchema.java:95)
at com.mslv.install.db.processor.ApplicationProcessor.createNonExistingDbSchemas(ApplicationProcessor.java:686)
at com.mslv.install.db.processor.ApplicationProcessor.importApplicationModel(ApplicationProcessor.java:123)
at com.mslv.install.db.ImportDBTask.execute(ImportDBTask.java:39)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
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(Thread.java:637)
Caused by: java.sql.SQLException: ORA-00922: missing or invalid option

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1882)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1847)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
at com.mslv.install.db.application.definition.DbSchema.createSchema(DbSchema.java:93)
... 17 more


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