Upgrading FMS and getting database upgrade error on Oracle RAC. (4257340)

Unable to upgrade Oracle RAC Database to the latest Foglight Management Server (FMS) version.

Even providing the following command switch the connection errors is still there after updating the Foglight software:

$FGLHOME/bin/fms -Dfoglight.database.upgrade=true

FMS Log:

2013-10-16 15:39:42.233 INFO [main] com.quest.nitro.service.ServiceMBeanUtil - Database Upgrade Service Starting...
2013-10-16 15:39:45.469 FATAL [main] com.quest.nitro.service.upgrade.db.DatabaseUpgradeService - Fatal error connecting to database. Shutting down Foglight server
... Check and make sure your database configuration is correct and the database server is up running.

Unable to perform upgrade due to RAC Configuration due to upgrade overwriting the oracle-ds.xml file.

WORKAROUND 1

Starting with Foglight 5.7.5.3, the server.config file allows you to specify the full JDBC URL (by editing the server.database.url property, which is by default commented out), removing the need for users to edit *-ds.xml or datasource-*.properties files .

If the "url" parameter is being used in "datasource-oracle.properties", its value can be copied and added to "server.database.url" in "server.config" before proceeding with the upgrade.

Example:

server.database.url = "jdbc:oracle:thin:@myListener:1521/myFoglightDB";

WORKAROUND 2

For Foglight version 5.7.x and lower:

1. Shut down FMS
2. Save oracle-ds.xml and server.config files.
    Location:
   $FMS_HOME/config/server.config
   $FMS_HOME/server/default/conf/oracle-ds.xml
   NOTE:  Path changed in FMS 5.7.1 to $FMS_HOME/server/jboss/conf/oracle-ds.xml
3. Run upgrade installer but choose to defer database schema upgrade.
4. If there's no option for that the schema upgrade will likely fail and the user should accept that as expected behaviour.
5. Manually enter/copy the original connection parameters from your backed-up oracle-ds.xml and server.config files.
6. Start FMS with -Dfoglight.database.upgrade=true -Dquest.debug=1
7. Check FMS log for upgrade-related errors
8. If successful, restart FMS in usual manner.

STATUS

Documentation enhancements included with Foglight 5.7.5.3+. Latest Technical Documents for upgrades and installations with an external Oracle Database available here.