Goldengate Monitor Installation Error : ORA-00439: Feature Not Enabled: Partitioning
(Doc ID 2406430.1)
Last updated on DECEMBER 12, 2019
Applies to:
Management Pack for Oracle GoldenGate - Version 12.2.1.2.0 and laterInformation in this document applies to any platform.
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
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 |