Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeffrey_Li
Creator
Creator

Qlik Sense connect to Oracle with wallet

Hi, All,
I want to make QS app connect to Oracle db through wallet . So far I did the following steps:
1. Copied two wallet files (.p12, .sso) to a folder on QS server.
2. Modified sqlnet.ora (on QS server) to include wallet location.
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = D:\<walletfolder>)
)
)

3. Modified tnsnames.org to include Oracle db which have wallet implemented.

Then I tried to create a new Oracle connection in QS hub, it failed with this error. ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-12547: TNS:lost contact.

I don't know what I missed. Any help would be appreciated.

Thanks

Labels (2)
1 Reply
Ayaka_Hanazono
Support
Support

Hi, @Jeffrey_Li  May I assume you are using the Qlik ODBC connector package?

if not, please try to see if it works.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Oracle...