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.yaml) please add the following "tns_admin" environment key to the section writeback-extreme -> env -> tns_admin with the value of $ORACLE_HOME/network/admin/ (please expand ORACLE_HOME into a absolute path).

See example below (The indentation of 2 spaces per level is important!)

http:
 address: 0.0.0.0:8090
writeback-extreme:
 domain: localhost
 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.