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:
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.
Starting with Foglight 188.8.131.52, 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.
server.database.url = "jdbc:oracle:thin:@myListener:1521/myFoglightDB";
For Foglight version 5.7.x and lower:
Documentation enhancements included with Foglight 184.108.40.206+. Latest Technical Documents for upgrades and installations with an external Oracle Database available here.