The following error appears in the Foglight Management Server (FMS) log file:
---
2020-04-07 10:24:02.957 ERROR [QuartzScheduler.StorageManager_Worker-1] com.quest.nitro.service.persistence.obs.storage.StorageManagerService - An error occurred while creating table obs_string_0471: java.lang.RuntimeException: java.sql.SQLException: ORA-60019: Creating initial extent of size 14 in tablespace of extent size 8
---
The FMS database (Oracle) is not able to create tables and throwing ORA-60019.
The result of the following queries is 0:
select table_name from all_tables where table_name like 'OBS_BINARY%';
select table_name from all_tables where table_name like 'OBS_STRING%';
Database parameter DB_SECUREFILE is set to PREFERRED.
Oracle database version is 12c.
If the Oracle database is a dedicate database for Foglight only, you can change the database parameter DB_SECUREFILE to NEVER.
Connect to the Foglight database as sysdba user and run this command:
ALTER SYSTEM SET db_securefile='NEVER' SCOPE=BOTH;
If the Oracle database is used by other applications too, please contact your DBA and/or Oracle support and clarify the impact for the other applications when changing this parameter.
