After installing Oracle security patch (19.24.0.0.240716) on clarity non-production environments, the application fails to connect to the DB and the applications are down.
The following error is seen in the logs:
ERROR ... [Config Monitor] persistence. PersistenceController (clarity:none:none:none) Exception due to DB Connection failure
ERROR ..Config Monitor] cache. OptionsCache (clarity:none:none:none) OptionsCache.getFromPersistence:PMD error
The DB can be reached by using Oracle SQL developer successfully, but not from the Clarity application. Nothing was changed from an infrastructure point of view. The Oracle security patch was the last change.
Clarity 16.0.x
Clarity release below 16.0.3 is using clarity driver (Progress DataDirect). The Oracle security patch breaking clarity driver (Progress DataDirect) - "com.ca.clarity.jdbc.oracle.OracleDriver"
Connecting to the database via SQL developer is successful as it was using Oracle native driver.
Options: