Encountered when running long-running operations (forecast, deploy) from the GUI while using a VPN. Typically using a VPN is necessary when the database is secured by internal firewalls (DMZ).
- Symptom: Client session termination or timeout while connecting using a VPN. The operation times exceed the connection idle-time limit set by the firewall.
- Solution: Configure
SQLNET.EXPIRE_TIME
insqlnet.ora
.
Starting in Datical DB 5.6, Oracle Instant Client will use an installed sqlnet.ora
file for configuration. It is part of the Datical DB installation of Oracle Instant Client. The file is in the following location:
${DATICAL_HOME}\instantclient\network\admin\sqlnet.ora
Edit the sqlnet.ora
file to set the desired value in minutes. The following example sets the expiration time to five minutes:
SQLNET.EXPIRE_TIME=5