-
Title
Foglight Console Installation missing 'Advanced' option when at configuring Foglight database -
Description
Foglight Console Installation missing 'Advanced' option when at configuring Foglight database step. We would like to configure Custom Tablespaces in the Foglight database and we must run the Foglight Console ( -i ) install.
-
Cause
"Advanced" foglight database configuration options are not available in console installs. Use the gui install or go through workaround below.
-
Resolution
Workaround: see FoglightPerformanceTuning_Field.pdf guide, section "Configuring Custom Tablespaces" which you can go through after the console install to configure the Tablespaces like you would in the GUI install. The section is listed below, but please see the actual guide for the most updated information.Custom Tablespaces
You can create custom tablespaces by modifying thestorage-config.xmlfile, which is
located in theconfigdirectory of the installation.
To create custom tablespaces:
1Openstorage-config.xml.
2Locate the<configuration-destination>tag and replace the
<default />tag with:
<tablespace data= ’CUSTDATA’ index=’CUSTINDEX’ lob=’CUSTLOB’
/>
where CUSTDATA, CUSTINDEX, and CUSTLOB are the names of your custom
tablespaces
NoteThese names are examples. You can name your custom tablespaces whatever you
want.
This creates all of the PERSISTENCE tables and a SCRIPT_SANDBOX table in
the CUSTDATA tablespace.
3After you have modified thestorage-config.xmlfile, go to thebindirectory and
runfoglight_db_upgrade.shmanually to update the database. All of the new
tables are created.