Error when installing or migrating Database (ORA-00439).

Document ID : KB000029703
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Receiving an ORA-00439 error when installing a new EM under Oracle or migrating from Postgres to Oracle database. The schematools.log returns ORA-00439: feature not enabled: Partitioning, when trying to install the schema.

[ERROR] [main] [com.wily.apm.dbutil.SqlExecutor] Sql error in file: createtables-oracle-9.7.0.0.sql
java.sql.SQLException: 
ORA-00439: feature not enabled: Partitioning
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.executeUpdateInternal(OracleStatement.java:1814)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277)
at com.wily.apm.dbutil.SqlExecutor.executeSql(SqlExecutor.java:258)
at com.wily.apm.dbutil.SqlExecutor.executeSqlStatement(SqlExecutor.java:219)
at com.wily.apm.dbutil.SqlExecutor.executeSqlFile(SqlExecutor.java:194)
at com.wily.apm.dbutil.SqlExecutor.executeSqlFile(SqlExecutor.java:141)
at com.wily.apm.dbutil.SqlExecutor.executeSqlFile(SqlExecutor.java:115)
at com.wily.apm.dbtools.createschema.CreateSchema.createSchema(CreateSchema.java:151)
at com.wily.apm.dbtools.createschema.CreateSchema.main(CreateSchema.java:109)

Solution:

When using the Oracle database, it must be with Partitioning enabled. Otherwise, it will not work.

The way to check it is with the below SQL statement, the return value is TRUE or FALSE:

SQL> select * FROM V$OPTION WHERE PARAMETER='Partitioning';

 

You should work with your Database administrator to correct this and restart the intallation/migration.