Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...