Cannot start Foglight server. Error "ORA-12505 - TNS:listener does not currently know of SID give (41146)

The Foglight server cannot be started.

Getting the following error in the Management Server Log file:
"Reason: java.lang.RuntimeException: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLException: Listener
refused the connection with the following error:"
"ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"

This is caused by a misconfigured Database parameter in one of the following Foglight config files:

foglight.config (Foglight 5.5.8)
or
server.config (Foglight 5.6.*)

1. Check that the database instance is correct by issuing the following command
tnsping instancename

2. Copy the Foglight config file (foglight.config or server.config) file to foglight.config.bak to back up the file.

3. Edit the Foglight config file (foglight.config or server.config) file.

Enter the correct instance name in the following line:
foglight.database.name = <instance_name>

4. Restart the Foglight server.