79515786

Date: 2025-03-17 21:29:35
Score: 3.5
Natty:
Report link

So I've had this issue trying to configure this in DBeaver. I lost a lot of time in the OCI console following a false lead (the ACL error usually means it's a authorization issue). I expect other JDBC clients might have a similar issue, so this is how I eventually solved it.

Under driver manager / Oracle / libraries:

enter image description here

Under connection settings / Driver properties set the keystore and the truststore (location, password and type for both). The password is the one provided when you downloaded the Wallet from the portal.

The connection settings are just using the TNS setup.

enter image description here

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Me too answer (2.5): have a similar issue
  • Low reputation (1):
Posted by: Alex