06 Jan 2026 09:07 AM
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?
Solved! Go to Solution.
13 Jan 2026 12:16 PM
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,
13 Jan 2026 01:09 PM
Awesome ! I'll try your trick as soon as possible ![]()
Featured Posts