Chat now with support
Chat with Support

Foglight Evolve 9.0 - Installing Foglight on Windows with an External Oracle Database

Before Installing Foglight Installing Foglight
Preparing to install Installing a new version of the Management Server Installed directories Foglight settings HP patch checking tool Uninstalling Foglight Upgrading the Management Server Installing Foglight FAQ
Running the Management Server Installing and Upgrading Cartridges Installing Agents

Manual database configuration

If you chose Manually create the repository database while installing the Management Server for use with an external database, there are two ways in which you can configure the database before starting the Management Server. Choose the one that best suits your needs:

Option 1 - Run the Foglight database tool to configure the database

Run Foglight’s database tool from the command line after exiting the installer. The database tool is located in the <foglight_home>\client\ directory.

NOTE: The tool creates the -Ddb.schema.username user when you run the command.

Option 2 - Run SQL scripts to configure the database

If you clicked Create during the database installation step, the SQL scripts in the <foglight_home>\scripts\sql directory are prepared with the provided configuration options. There are four SQL files for each database type ([dbtype]):

You can review these scripts before running them.

If custom tablespaces are configured in the storage-config.xml, as described in the Performance Tuning Field Guide, the database administrator must edit the oracle_create_db.sql script and add grants for the custom tablespaces. These grants are similar to the ones that grant a quota on the USERS tablespace. For example:

NOTE: In the example above, replace the italicized text (for example, SOME_CUSTOM_DATA_TABLESPACENAME_HERE) with the actual custom tablespace names defined in the storage-config.xml file.

You must run the configured scripts against the database using a third-party tool.

Run the .sql scripts by issuing the following commands in the order shown:
This script must be run under an account with administrator privileges (for example, sys), because you require system access to execute it. Replace <DBA_username> and <DBA_password> with the user name and password for the database administrator account.
This script must be run under an account with administrator privileges (for example, sys), because you require system access to execute it. Replace <DBA_username> and <DBA_password> with the user name and password for the database administrator account.

After you have run all four scripts, you can start the Management Server. Proceed to Starting and stopping the Management Server.

Initializing the database

Initializing the database

For external databases, once the database has been successfully initialized, you can run Foglight.

Related Documents