Oracle Wallet Authentication for Custom SQL Extensions

jegron — Tue, 06 Jan 2026 09:07:15 GMT

Hi!

We would like to execute Oracle queries using a custom SQL extension. We must connect using an Oracle Wallet.

Do you know of any workaround or supported approach to use this authentication method with custom SQL extensions?

Re: Oracle Wallet Authentication for Custom SQL Extensions

SofiaPersia — Tue, 13 Jan 2026 12:16:45 GMT

Hi there! 😊

To use the Cloud Wallet for connecting to an Oracle Autonomous Database, I used the following approach:
In the configuration (I’m attaching a screenshot), I used a connection string and intentionally omitted the Cloud Wallet section, which is configured later.

On the ActiveGate side, it was necessary to grant read permissions to my dtuser on the directory that contains the Cloud Wallet ZIP file.

Inside the ZIP file, in the tnsnames.ora file, make sure the following entry is present:

(SECURITY =
(MY_WALLET_DIRECTORY = <custompath/walletcloudfolder>)
(SSL_VERSION = 1.2)
(SSL_CLIENT_AUTHENTICATION = FALSE)
(ssl_server_dn_match = no)
)

At the ActiveGate service level, I ran the following command:

systemctl edit --full dynatracegateway.service

and added this environment variable, pointing to the directory where the Cloud Wallet ZIP file is stored:
Environment="TNS_ADMIN=<custompath>/walletcloudfolder"

After that, I executed:

sudo systemctl daemon-reexec # reload systemd sudo systemctl restart dynatracegateway.service

PS: Make sure that the MY_WALLET_DIRECTORY path matches exactly the path configured in TNS_ADMIN

Hope this was helpful.
Regards,

Re: Oracle Wallet Authentication for Custom SQL Extensions

y_buccellato — Tue, 13 Jan 2026 12:28:03 GMT

Phenomenal!

Re: Oracle Wallet Authentication for Custom SQL Extensions

jegron — Tue, 13 Jan 2026 13:09:14 GMT

Awesome ! I'll try your trick as soon as possible

topic Re: Oracle Wallet Authentication for Custom SQL Extensions in Extensions

Oracle Wallet Authentication for Custom SQL Extensions

Re: Oracle Wallet Authentication for Custom SQL Extensions

Re: Oracle Wallet Authentication for Custom SQL Extensions

Re: Oracle Wallet Authentication for Custom SQL Extensions