My Oracle Support Banner

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

Last updated on JULY 23, 2018

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
July 23, 2018 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


Changes

 

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
Changes
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.