Foglight server does not start after upgrade to 5.9.5 - error: "Borrow prepareStatement from pool failed..." (4246837)

After upgrade to Foglight version 5.9.5, the server does not start anymore. In the logfile the following error appears:

JDBC bug in ojdbc8.jar when using characterset WE8ISO8859P15.

Oracle provides further details here.

WORKAROUND

Please follow the steps below to fix the issue.

1. In case a backup has been restored, do the Foglight upgrade again
2. Please move the file ojdbc8.jar from $FMS_Home/server/core/ folder to another folder outside of $FMS_Home.
3. Download the attached ojdbc0-0923.zip file
4. Unzip the file
5. Now copy the new file to $FMS_Home/server/core/ folder and make sure it has the same permissions like the old ojdbc8.jar file
6. Finally start Foglight

Oracle itself does not have a fully patched driver file available yet, but they provided the needed files to replace them in the ojdbc8.jar file. The attached ojdbc0-0923.zip contain the new files.

STATUS

Quest bug ID FGL-20252 was fixed in the 5.9.7 and higher releases of the FMS