Question / Problem

If CRX is configured to use an Oracle database, and when using a firewall, it is possible that the repository 'hangs' after some time.

Answer / Resolution

This problem may be caused by a firewall that drops idle TCP connections.

Usually CRX automatically re-connects to the database when the connection is broken, but this mechanism does not work efficiently with the Oracle JDBC driver, because the default read timeout of the Oracle driver is too long. That means the firewall timeout for idle-connections may block the connection.

If you run into this problem, enable Oracle Net DCD by setting SQLNET.EXPIRE_TIME=1 in the sqlnet.ora file on the server-side.

Applies

CRX1.3.x, CRX1.4.x

Esta obra está licenciada sob uma licença não adaptada da Creative Commons Attribution-Noncommercial-Share Alike 3.0  As publicações do Twitter™ e do Facebook não são cobertas pelos termos do Creative Commons.

Avisos legais   |   Política de privacidade online