Chat now with support
Chat with Support

Foglight 5.9.8 - Upgrade Guide

Understand product versions Best practices Upgrade the Foglight Management Server Upgrade the Foglight Agent Manager Upgrade the Application Monitoring cartridges Upgrade the Database cartridges Upgrade the End User Management cartridges Upgrading the Infrastructure Management cartridges Upgrade the Integration cartridges Upgrade the cartridges in a federated or High Availability (HA) environment Appendix: Deploying an agent package using the browser interface

Upgrade the Management Server with an Oracle RAC database

This section provides instructions for upgrading Oracle® RAC-based installations and any other environments where the Management Server oracle-ds.xml files were customized. The oracle-ds.xml file is replaced by the datasource-oracle.properites file in the Management Server 5.9.x, so the Management Sever merges the connection URL and connection properties during the upgrade.

If you encounter the warning message “A special configuration has been found in <backup_oracle_datasource>, please manually merge your configuration from this file to <new_oracle_datasource> and then click Next to continue with the upgrade.” during the upgrade, open the backup of $fmshome/state/backup/<version>/server/jboss/conf/oracle-ds.xml where lists the configured connection properties, and then add these connection properties manually to the $fmshome/config/datasource/ file. For example, you see the following line in the oracle-ds.xml file, <connection-property name="oracle.jdbc.implicitStatementCacheSize">${oracle.jdbc.implicitStatementCacheSize:50}</connection-property>”, open the file and add this line “”.

NOTE: Make sure to add the db. prefix before the original connection-property name, when you add the connection properties in the new file.
Save the oracle-ds.xml and server.config files.
TIP: The Management Server backs up the previous oracle-ds.xml and server.config files after the upgrade. You may find the backup files under $fmshome/state/backup/<version>/server/jboss/conf/oracle-ds.xml and $fmshome/state/backup/<version>/config/server.config.

Oracle database users

A Management Server 5.9.x using an Oracle® database makes use of stored procedures in the Oracle database. When upgrading from a version earlier than 5.6.2 to version 5.6.2 or later, the procedures are created during the upgrade process. To allow the upgrade process to create the stored procedures, a DBA user must first assign the CREATE PROCEDURE privilege to the database user used by Foglight.

where <foglight> is the name of the database user used by the Foglight application

If the upgrade process is run without assigning the CREATE PROCEDURE privilege to the Oracle database user, the database upgrade will fail with the following error:

The Oracle database user has not been assigned the CREATE PROCEDURE privilege.

Once the CREATE PROCEDURE privilege is assigned to the database user, the database upgrade process can be run manually by invoking the foglight_db_upgrade script.

Database changes

This section provides a list of the database changes from Foglight 5.6.2 through Foglight 5.9.x.

For new Management Server 5.7.6 (and later) installations, the embedded MySQL® database was replaced with an embedded PostgreSQL® database. Upgrades to Foglight Management Servers 5.7.6 with an existing embedded MySQL database are not affected. The existing database is retained during the upgrade.

An upgrade from version 5.6.5 of the Management Server to version 5.6.7 changes the database in the following ways:

Sequence SEQ_O*

Altered cache size to 10000


An upgrade from version 5.6.4 of the Management Server to version 5.6.5 changes the database in the following ways:


Table added


An upgrade from version 5.6.2 of the Management Server to version 5.6.3 changes the database in the following ways:


Table added



Upgrade the Foglight Agent Manager

This section describes the procedure for upgrading the Foglight Agent Manager (FglAM). The latest version of the Agent Manager is 5.9.x.

Remote updates of the Agent Manager are deployed from the Management Server. Local access to Agent Manager clients is typically not required to perform an upgrade.

For more details, see these topics:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating