"Interrupt task is already scheduled for the thread" and SO_TIMEOUT errors in Oracle agent SQL PI (4311186)

SQL PI cannot monitor Oracle instances at the version 11gR2 and higher releases. An error similar to the following appears in the Oracle or Oracle RAC agent log files which includes the words "Interrupt task is already scheduled for the thread" and SO_TIMEOUT. 

WORKAROUND

Upgrade to the most recent ojdbc8.jar file from Oracle.

The ojdbc8.jar file that was included with Oracle 21.3 (released on July 1, 2021) is attached to this KB article.

Included in the zip file is a replacement ojdbc8.jar file from Oracle 

1. Stop the Foglight Agent Manager (or FMS if this is an All in One install)
2. Remove and backup to a different folder the file beginning with the name ojdbc8 (for example ojdbc8-19.10.0.0.jar) located in this folder {fglam}\agents\DB_Oracle\{version-number}\lib
3. Copy the new ojdbc8-21.3.0.0.jar file to the same folder ({fglam}\agents\DB_Oracle\{version-number}\lib)
4. Restart the Foglight Agent Manager (or FMS if this is an All in One install)
5. Confirm if the issue continues to happen or if it is resolved.
6. Contact Support if this continues to be an issue.

STATUS

This issue was logged as defect FOG-2982. The Oracle cartridges have been updated with the newer driver beginning in the 6.1.0.10 and higher releases.