Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Aussiegreenmarks
Contributor
Contributor

Connect oracle Database using static IP

Hi 

I was trying to connect to the Oracle database but this is showing me the error that

"Error[HY000][Qlik][OracleOCI](3000) Oracle caller interface : ORA-12170: TNS Connect timeout occurred"

I contacted our vendor because we are using an ERP system from a third party and they can provide us the database views.

They replied me :

Aussiegreenmarks_0-1679881439416.png

 

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?

 

Thanks

Labels (1)
1 Solution

Accepted Solutions
Lucas_Gatling
Support
Support

@Aussiegreenmarks this is something outside of Qlik products and needs to be done on your server. I found this link that hopefully will assist  you further:

 

https://www.trendnet.com/press/resource-library/how-to-set-static-ip-address

If the issue is solved please mark the answer with Accept as Solution.

View solution in original post

1 Reply
Lucas_Gatling
Support
Support

@Aussiegreenmarks this is something outside of Qlik products and needs to be done on your server. I found this link that hopefully will assist  you further:

 

https://www.trendnet.com/press/resource-library/how-to-set-static-ip-address

If the issue is solved please mark the answer with Accept as Solution.