Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
hanna_choi
Partner - Creator
Partner - Creator

Failed Oracle Connector

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

Labels (1)
1 Reply
Jay_Brown
Support
Support

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.

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.