Extensions
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Oracle Wallet Authentication for Custom SQL Extensions

jegron
DynaMight Champion
DynaMight Champion

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?

Observability Engineer at Phenisys - Dynatrace Professional
3 REPLIES 3

SofiaPersia
Observer

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,



Phenomenal!

jegron
DynaMight Champion
DynaMight Champion

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

Observability Engineer at Phenisys - Dynatrace Professional

Featured Posts