FMS Upgrade Error ORA-12505 connecting to database for RAC (4328438)

The upgrade procedure failed to connect to the database to complete the upgrade so we ran the foglight_db_upgrade script as documented.
This also failed with "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"

• The foglight_db_upgrade script fails to connect to RAC instances as it only uses the $FGLHOME/config/foglight.config parameters.
• This script does not utilize the oracle-ds.xml file for DB connection
• The F5.6.2 upgrade overwrites the connection-url in the $FGLHOME/server/default/conf/oracle-ds.xml file
  ie. ${foglight.database.url}

• NOTE:  FMS 5.7.1 and higher the path has changed to $FGLHOME\server\jboss\conf\oracle-ds.xml.

1) Edit the $FGLHOME/server/default/conf/oracle-ds.xml and enter your correct RAC connection parameters which existed before the upgrade.

• NOTE:  FMS 5.7.1 and higher the path has changed to $FGLHOME\server\jboss\conf\oracle-ds.xml.

2) Start the FMS with the DB upgrade switch equating to true.

ie. cd $FGLHOME/bin

UNIX: fms -d -Dfoglight.database.upgrade=true

WINDOWS: fms -Dfoglight.database.upgrade=true