How to solve Firewall Problems when using Oracle

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

 Adobe

更快、更輕鬆地獲得協助

新的使用者?

Adobe MAX 2024

Adobe MAX
創意大會

10 月 14 至 16 日邁阿密海灘和線上

Adobe MAX

創意大會

10 月 14 至 16 日邁阿密海灘和線上

Adobe MAX 2024

Adobe MAX
創意大會

10 月 14 至 16 日邁阿密海灘和線上

Adobe MAX

創意大會

10 月 14 至 16 日邁阿密海灘和線上