Data connection issue

[Tool_Tip]

Dear all,

I am unable to create oracle data connection from enterprise server but able to connect in desktop:

On server getting below error :

ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-12170: TNS:Connect timeout occurred

[marksouzacosta]

Is Qlik Desktop installed on the same Qlik Sense Server machine?
If not, make sure you have the same TNS configuration file and same access to the Database, user rights, etc.

[Tool_Tip]

No. desktop is installed on different machine but they are using same TNS file.

[Jill_Masinde]

@Tool_Tip The error message you’re encountering indicates a timeout issue when trying to connect to an Oracle database using the Oracle Call Interface (OCI). Here are some common reasons forORA-12170: TNS:Connect timeout occurred.

1. Network Issues: The connection might be blocked by a firewall or there could be network latency causing delays.

2. Incorrect Connection String: The TNS (Transparent Network Substrate) entry may be incorrect. Double-check the syntax, service name, and any parameters in your connection string.

3. Listener Not Running: The Oracle listener service on the database server might not be running, preventing connections.

4. Database Down: The target database instance may be down or unreachable.

5. Configuration Issues: There may be issues in the tnsnames.ora file, such as incorrect IP addresses, ports, or service names.

[marksouzacosta]

I would try to create a Windows ODBC connection from the Qlik Sense Server. This way you can check if your server can access the Oracle Database or not.