Goldengate Monitor Installation Error : ORA-00439: Feature Not Enabled: Partitioning (Doc ID 2406430.1)

Last updated on DECEMBER 12, 2019

Applies to:

Symptoms

During installation Oracle goldengate monitor faced ORA-00439: feature not enabled: Partitioning error as mentioned below.Ignoring error and pressing continue did not work.

Error Detail:

MSK 2018 rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 439SQLState:67000 Message: ORA-00439: feature not enabled: Partitioning

Error encountered executing SQL statement FileName: '/ora/ggmon/middleware/12.2/oggmon/common/sql/oggmon/scripts/Oracle/create-schema.sql' LineNumber: '29'
SQL Statement: [CREATE TABLE mps_history (ID NUMBER(10) NOT NULL, mp_type VARCHAR2(31) NULL, string_array_value CLOB NULL, string_value VARCHAR2(4000) NULL, double_value NUMBER(19,4) NULL, connection_value NUMBER(10) NULL, mp_date TIMESTAMP NULL, boolean_value NUMBER(1) default 0 NULL, long_value NUMBER(19) NULL, float_value NUMBER(19,4) NULL, status_value NUMBER(10) NULL, date_value TIMESTAMP NULL, int_value NUMBER(10) NULL, mp_id NUMBER(10) NULL, PRIMARY KEY (ID)) PARTITION BY RANGE (mp_date) INTERVAL(NUMTOYMINTERVAL(1, 'MONTH')) (PARTITION MPS_HISTORY_1 VALUES LESS THAN (to_date('2001-01-01', 'YYYY-MM-DD')))]
java.sql.SQLException: ORA-00439: feature not enabled: Partitioning

GoldenGate Monitor :
Release Version: 12.2.1.2.171115
Build Label: OGGMON_12.2.1.2.0_PLATFORMS_RELEASE

Repository database :
Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

Oracle GoldenGate Command Interpreter for Oracle
Version 12.3.0.1.2 OGGCORE_12.3.0.1.0_PLATFORMS_171208.0005_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 8 2017 21:13:00

Changes

Got "ORA-00439: feature not enabled: Partitioning" error during Oracle goldengate monitor installation.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.