Database Connection Error

DebanjanKabiraj — Thu, 06 Mar 2025 10:52:16 GMT

We are facing issues while connecting client's database server, tns ping is occurring, telnet is occurring, normal ping is also occurring.

We can established the connection on qlik cloud, with on prem database using both the oracle and oracle (Via direct access gateway) but data is not fetching from database and test the connection that giving the following error:

Oracle Error:

ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-03135: connection lost contact

Oracle (Via direct access gateway) Error:

Status(StatusCode="Internal", Detail="Command testconnection returned non-success: Error message:
Please check the values for Username‚ Password‚ Host and other properties. Description: General error - ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-03135: connection lost contact

ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-03135: connection lost contact
[Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-03135: connection lost contact
")

Re: Database Connection Error

diegozecchini — Mon, 17 Mar 2025 09:25:23 GMT

Hi!
Oracle may be terminating idle sessions due to timeout settings.
On the Oracle database server, check and increase the value of SQLNET.EXPIRE_TIME in sqlnet.ora: SQLNET.EXPIRE_TIME=10
This setting ensures that keepalive packets are sent every 10 minutes.

If the issue is related to timeouts, you may need to increase CONNECT_TIMEOUT, RECV_TIMEOUT, and SEND_TIMEOUT in the sqlnet.ora file on the client-side.
CONNECT_TIMEOUT=60
RECV_TIMEOUT=300
SEND_TIMEOUT=300

topic Re: Database Connection Error in Connectivity & Data Prep

Database Connection Error

Re: Database Connection Error