Skip to main content
Waters Employee Login
 
Waters

Empower error: Database Connection Terminated - ORA-03135 - WKB8756

  1. Last updated
  2. Save as PDF
Article number: 8756

SYMPTOMS

  • During use of Empower, application closes randomly with error message "Database Connection Terminated - ORA-03135" 

ENVIRONMENT

  • Empower Enterprise
  • Empower Workgroup

CAUSE

SQLNET Expire Time

This issue can arise from latency of the network or delay due to antivirus or firewall activity.

FIX or WORKAROUND

  1. Add the following parameters in the sqlnet.ora file on the Empower database server: 

SQLNET.EXPIRE_TIME = 10 

The file is located in %installationdrive%\Empower\Oracle\OracleXXc\NETWORK\ADMIN (XX indicates the version of Oracle for a given Empower release). This is where the change needs to be made, not in the similar sqlnet.ora found in the client folder on the same server. There are two sqlnet.ora files on the server, be sure to modify the one in the path specified above.

2. Restart the associated Oracle Listener Service (e.g., 'OracleEmpowerOracleXXcTNSListener').

ADDITIONAL INFORMATION

SQLNET.EXPIRE_TIME

Purpose

Specify a time interval, in minutes, to send a check to verify that client/server connections are active. The following usage notes apply to this keepalive parameter:

  • Setting a value greater than 0 ensures that connections are not left open indefinitely, due to an abnormal client termination.

  • If the probe finds a terminated connection, or a connection that is no longer in use, it returns an error, causing the server process to exit.

  • This parameter is primarily intended for the database server, which typically handles multiple connections at any one time.

  • Limitations on using this terminated connection detection feature:

    • It is not allowed on bequeathed connections.

    • Though very small, a probe packet generates additional traffic that may downgrade network performance.

    • Depending on which operating system is in use, the server may need to perform additional processing to distinguish the connection probing event from other events that occur. This can also result in degraded network performance.

Default

0

Minimum Value

0

Recommended Value

10

id8756, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, SUP

Not able to find a solution? Click here to request help.