Oracle

Most connections to Orcale work out-of-the box.

Occasionally we get questions about advanced configuration of the connection. We do support this but this requires advanced configuration on our side as-well.

For example, when your Oracle instance requires SSL. it will throw an error like this:

oci_connect(): ORA-12270: Client NOT using TCPS protocol to connect to server

In this case you need to create an .ora file on your system that contains the WALLET_LOCATION to the .pem file.

How to configure .ora configuration files:

Within the configuration file (wbe.config.toml) please add the following "tns_admin" environment key to the section writeback-extreme.env with the value of $ORACLE_HOME/network/admin/ (please expand ORACLE_HOME into a absolute path).

See example below

[writeback-extreme]
domain = 'localhost'
host = ':8899'

[writeback-extreme.env]
tns_admin = '/absolute/path/to/oracle/home/network/admin'

This exposes a TNS_ADMIN environment variable to the background service of the application. Therefore the application/our oracle driver uses the TNS_ADMIN to locate the '.ora' files.

Docker

When running WriteBackExtreme in Docker, pass the variable prefixed with WBE like so:

WBE_TNS_ADMIN = /absolute/path/to/oracle/home/network/admin