Forum Discussion

Nizar's avatar
Nizar
Icon for Nimbostratus rankNimbostratus
Oct 03, 2023

Error message in the /var/log/DBDaemon-0.log file: java.sql.SQLException: ORA-28040: No matching

Hello,

I have encountered an error message in the /var/log/DBDaemon-0.log file:
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol
java.sql.SQLException: ORA-28040: No matching authentication protocol

After reading the KB article at https://my.f5.com/manage/s/article/K40226145, it appears that the issue is related to the BIG-IP Oracle health monitor failing for Oracle DB versions 12.2 or higher.

I would like to inquire about how to check or if there is a CLI command to determine which pool member is causing the appearance of this message: java.sql.SQLException: ORA-28040: No matching authentication protocol ?