Liquibase Enterprise was formerly known as Datical DB.

Oracle Database Connection Times Out Over VPN

Owned by Former user (Deleted)
Last updated: Jan 29, 2024 by Amber Williams
1 min read

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 in sqlnet.ora.

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




Copyright © Liquibase 2012-2022 - Proprietary and Confidential