Unable To Create A Database Schema Using Oracle OSM 7.2.0.10.2 Installer (Doc ID 2164935.1)

Last updated on AUGUST 05, 2016

Applies to:

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

Goal

While trying to create database schema using OSM 7.2.0.10.2 installer, we are receiving the following exception in the logs and the installation is failing. What could be the reason?

Nested Exception: ORA-24344: success with compilation error
ORA-06512: at line 79
Nested Exception: java.sql.SQLException: ORA-24344: success with compilation
error
ORA-06512: at line 79

at com.mslv.install.db.util.SqlHelper.executeCall(SqlHelper.java:235)
at
com.mslv.install.db.util.SqlHelper.executePreparedCall(SqlHelper.java:830)
at com.mslv.install.db.util.SqlHelper.compileSchema(SqlHelper.java:792)
at
oracle.communications.ordermanagement.install.db.plan.CompileTypeActionProcess
or.processImpl(CompileTypeActionProcessor.java:24)
at
oracle.communications.ordermanagement.install.db.plan.InstallActionProcessor.p
rocess(InstallActionProcessor.java:29)
... 18 more
Caused by: java.sql.SQLException: ORA-24344: success with compilation error
ORA-06512: at line 79

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.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)

at
oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.ja
va:1005)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1
307)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedState
ment.java:3449)
at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.jav
a:3550)
at
oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.jav
a:4693)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatem
entWrapper.java:1086)
at com.mslv.install.db.util.SqlHelper.executeCall(SqlHelper.java:227)
 

Solution

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