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:
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
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
