Qlik Sense connect to Oracle with wallet

Jeffrey_Li — Thu, 10 Mar 2022 15:09:27 GMT

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

Re: Qlik Sense connect to Oracle with wallet

Ayaka_Hanazono — Tue, 12 Apr 2022 07:34:34 GMT

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/Create-Oracle-connection.htm

topic Re: Qlik Sense connect to Oracle with wallet in Connectivity & Data Prep

Qlik Sense connect to Oracle with wallet

Re: Qlik Sense connect to Oracle with wallet