https://community.qlik.com/t5/QlikView/Connect-oracle-Database-using-static-IP/m-p/2053287#M1231783 <P class="xmsonormal">Hi&nbsp;</P> <P class="xmsonormal">I was trying to connect to the Oracle database but this is showing me the error that</P> <P class="xmsonormal"><STRONG>"Error[HY000][Qlik][OracleOCI](3000) Oracle caller interface : ORA-12170: TNS Connect timeout occurred"</STRONG></P> <P class="xmsonormal">I contacted our vendor because we are using an ERP system from a third party and they can provide us the database views.</P> <P class="xmsonormal">They replied me :</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aussiegreenmarks_0-1679881439416.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/103514iDAEEB77DB4E56B58/image-size/medium?v=v2&amp;px=400" role="button" title="Aussiegreenmarks_0-1679881439416.png" alt="Aussiegreenmarks_0-1679881439416.png" /></span></P> <P>&nbsp;</P> <P>Can anyone please guide me, on how we can set up the static IP, so I can provide that to the vendor and they can whitelist the ID?</P> <P>&nbsp;</P> <P>Thanks</P> Mon, 26 Jan 2026 16:26:21 GMT Aussiegreenmarks 2026-01-26T16:26:21Z https://community.qlik.com/t5/QlikView/Connect-oracle-Database-using-static-IP/m-p/2053287#M1231783 <P class="xmsonormal">Hi&nbsp;</P> <P class="xmsonormal">I was trying to connect to the Oracle database but this is showing me the error that</P> <P class="xmsonormal"><STRONG>"Error[HY000][Qlik][OracleOCI](3000) Oracle caller interface : ORA-12170: TNS Connect timeout occurred"</STRONG></P> <P class="xmsonormal">I contacted our vendor because we are using an ERP system from a third party and they can provide us the database views.</P> <P class="xmsonormal">They replied me :</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Aussiegreenmarks_0-1679881439416.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/103514iDAEEB77DB4E56B58/image-size/medium?v=v2&amp;px=400" role="button" title="Aussiegreenmarks_0-1679881439416.png" alt="Aussiegreenmarks_0-1679881439416.png" /></span></P> <P>&nbsp;</P> <P>Can anyone please guide me, on how we can set up the static IP, so I can provide that to the vendor and they can whitelist the ID?</P> <P>&nbsp;</P> <P>Thanks</P> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/Connect-oracle-Database-using-static-IP/m-p/2053287#M1231783 Aussiegreenmarks 2026-01-26T16:26:21Z https://community.qlik.com/t5/QlikView/Connect-oracle-Database-using-static-IP/m-p/2056822#M1231786 <P><SPAN style="background: var(--ck-color-mention-background); color: var(--ck-color-mention-text);"><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/222956">@Aussiegreenmarks</a></SPAN> this is something outside of Qlik products and needs to be done on your server. I found this link that hopefully will assist &nbsp;you further:</P> <P>&nbsp;</P> <P><A href="https://www.trendnet.com/press/resource-library/how-to-set-static-ip-address" target="_blank">https://www.trendnet.com/press/resource-library/how-to-set-static-ip-address</A></P> Tue, 04 Apr 2023 11:29:45 GMT https://community.qlik.com/t5/QlikView/Connect-oracle-Database-using-static-IP/m-p/2056822#M1231786 Lucas_Gatling 2023-04-04T11:29:45Z