topic Failed Oracle Connector in Connectivity & Data Prep

Failed Oracle Connector

hanna_choi — Tue, 20 Sep 2022 23:58:35 GMT

Hello.

I need your help.

I got the error message from Qlik Oracle Connector & Qlik ODBC Connector.

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

The below test is succeed.
- SQL Developer connection
- Window ODBC 64 bit Test Connection

I can not find the solutions.
What should I request to Oracle DBA?

Best Regard.

hanna.choi

Jay_Brown — Wed, 02 Nov 2022 11:45:11 GMT

Hello @hanna_choi , thanks for posting!

Can you test the actual data retrieval outside of Qlik?
https://community.qlik.com/t5/Knowledge/How-to-fetch-data-via-ODBC-DSN-without-using-Qlik-Products/t...
https://community.qlik.com/t5/Knowledge/How-to-fetch-data-with-ODBC-DSN-connections-using-Powershell...

Sometimes we see scenarios where the Test Connection function works but the user does not have access to the actual data. This would be a good test to see if the same account can retrieve the data from that server.