My Oracle Support Banner

ERROR: "ORA-00439: feature not enabled: In-Memory Column Store" Or "ORA-00922: missing or invalid option" When Attempting to Upgrade Oracle 12c Database to P6 EPPM R19.12 (Doc ID 2629388.1)

Last updated on SEPTEMBER 09, 2020

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 19.12 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade to P6 EPPM R19.12,
the following error occurs.

ERROR
-----------------------
ORA-00439: feature not enabled: In-Memory Column Store
ORA-06512: at line 7
SQL Query:
DECLARE
tbl_exists INTEGER;
BEGIN
SELECT COUNT(*) INTO tbl_exists FROM user_tables WHERE table_name =
UPPER('SAFETYDATE');
IF tbl_exists = 0
THEN
EXECUTE IMMEDIATE 'CREATE TABLE SAFETYDATE(
setting_name varchar2(30 CHAR) NOT NULL,
setting_value DATE NULL
,CONSTRAINT pk_setting_name PRIMARY KEY (setting_name) )
TABLESPACE PMDB_DAT1
STORAGE (INITIAL 1M NEXT 1M MAXEXTENTS UNLIMITED PCTINCREASE 0)
INMEMORY
';
END IF;
END;

=============================================================

(ORA-00922: missing or invalid option
ORA-06512: at line 7
)
SQL Query:
DECLARE
  tbl_exists INTEGER;
 BEGIN
  SELECT COUNT(*) INTO tbl_exists FROM user_tables WHERE table_name =
UPPER('SAFETYDATE');
  IF tbl_exists = 0
  THEN
  EXECUTE IMMEDIATE 'CREATE TABLE SAFETYDATE(
  setting_name varchar2(30 CHAR) NOT NULL,
  setting_value DATE NULL
 ,CONSTRAINT pk_setting_name PRIMARY KEY (setting_name) )
 TABLESPACE PMDB_DAT1
  STORAGE (INITIAL 1M NEXT 1M MAXEXTENTS UNLIMITED PCTINCREASE 0)
 INMEMORY
 ';
  END IF;
 END;


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Run dbsetup.bat for upgrade to P6 EPPM R19.12
  2. Complete the wizard with database details
  3. Error occurs during the "Perform core upgrade" step

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
References


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