ShipConsole Fails to Start – ORA-28040: No Matching Authentication Protocol

Problem:

Problem: ShipConsole Fails to Start – ORA-28040: No Matching Authentication Protocol 

Error : SEVERE: Exception Message: Cannot create PoolableConnectionFactory (ORA-28040: No matching authentication protocol.)

Root Cause : This issue occurs when ShipConsole tries to connect to a 19c Oracle Database using an older JDBC driver or incompatible authentication protocol.

Oracle 19c disables older authentication protocols by default for security reasons.

Solution:

Update SQLNET Compatibility Settings in Oracle DB

To resolve the issue, you need to configure the database to allow backward-compatible authentication protocols.

1. Edit the sqlnet.ora file on the database server:

• Typically located at:
  /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/sqlnet.ora

2. Add or modify the following line:

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 11

This allows clients using Oracle 11g-compatible authentication (like older ShipConsole deployments) to connect to a 19c database.

3. Restart the Oracle Listener for changes to take effect:

lsnrctl stop lsnrctl start