-
Title
Foglight unable to complete startup - End of TNS data channel -
Description
Upon starting Foglight, we see a "Fatal error connecting to database" message displayed.
Restarting with Debug Logging enabled (SOL41911), we see the following:
2012-09-28 09:43:19.479 DEBUG [main] com.quest.nitro.service.upgrade.db.DatabaseUpgradeService - Fatal error connecting to database
java.lang.RuntimeException: org.jboss.util.NestedSQLException: Could not create connection; - nested throwable: (java.sql.SQLRecoverableException: IO Error: End of TNS data channel); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLRecoverableException: IO Error: End of TNS data channel))
at com.quest.nitro.service.util.JDBCHelper.getConnection(JDBCHelper.java:124)
at com.quest.nitro.service.util.JDBCHelper.getConnection(JDBCHelper.java:136)
at com.quest.nitro.service.upgrade.db.DatabaseUpgradeService.startService -
Cause
Previously held connections between the FMS & the external database remain open.
-
Resolution
Shutdown and restart the database to clear any stale connections.