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";
Leave a Comment
Users who read this article also read
- Product(s):
-
Foglight
5.6.11
- Topic(s):
- Configuration
- Article History:
- Created on: 2/26/2015
Last Update on: 3/29/2016
- Author:
- Rob Shipway
- Search All Articles
-