Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.Join Us
Agenda:To confirm the Oracle Client connections are taking place to Oracle Server
Note:Once connection is Success from outside Qlik , Use the same in Qlik.
Pre-requisite;Oracle client installed and configured to reach Oracle Server
Validate Oracle connection Outside the Qlik Product:
On Qlik Engine machine(This is the windows machine from where we need to start making connection to Oracle Server)
Open command prompt and type the below command -> For further reference :https://docs.oracle.com/cd/E11882_01/network.112/e41945/connect.htm#NETAG357
TNS Ping Utility for 64-bit Windows: Version 220.127.116.11.0 - Production on 23-AUG-2018 09:35:46
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = INBAN-BJM.qliktech.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (0 msec)
Note:Once connection is Success from outside Qlik , Use the same in Qlik Sense
Logging: Help manual -->To trace the logs:
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.Submit a case
Experiencing a serious issue, please contact us by phone. View phone numbers and hours by region.