Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.