Upgrade of the OSM Schema Failed With the Error - ORA-00922: missing or invalid option
(Doc ID 1618349.1)
Last updated on MARCH 27, 2023
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
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 |