Return
-
Title
Seeing ORA-00922 errors within the management server log files where creating obs_ tables -
Description
Within the Managenent server log files the Oracle error ORA-00922 messages appear when creating any obs_ tables. -
Cause
This issue is being caused after incorrectly following details within KB 127614.
-
Resolution
Within the storage-parameters.config.cfg file under $FGL_HOME\config the word OVERFLOW should only be on the aggregate-iot & scalar-iot entries."obs_metric_aggregate" : "${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED)","obs_metric_scalar" : "${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED)","obs_string" : "${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED)","obs_binary" : "${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED)","obs_metric_aggregate-iot" : "ORGANIZATION INDEX COMPRESS 2 ${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED) OVERFLOW ";"obs_metric_scalar-iot" : "ORGANIZATION INDEX COMPRESS 2 ${tablespace.clause} PCTFREE 0 STORAGE (NEXT 10M MAXEXTENTS UNLIMITED) OVERFLOW";