cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ll
New Member

Connect to REMOTE Oracle Error: Oracle: ORA-12170: NS:Connect timeout occurred

Hello,

I tested PBI with my local Oracle and I did not get problem and I tried conect to a REMOTE (AWS) Oracle database and I get this error message:

"Oracle: ORA-12170: TNS:Connect timeout occurred"

I can connect to this database with my PL/SQL Developer via SQL*Net, TNSNAMES:ORA is ok, Oracle client is installed, need other network or port or firewall setting for PBI? Thanks for your assist,

LL 

2 REPLIES 2
v-ljerr-msft
Microsoft
Microsoft

Hi @ll,

 

Could you try using the syntax "hostname:[port number] /SID" in the servername to see if it works?

 

In addition, I also found some proposals for you to troubleshoot this issue.Smiley Happy

1. Make sure you have installed the latest version of Oracle client following the instructions in this article. Ensure that your Oracle client, Oracle Server and Power BI  Desktop have the same bitness(32bit or 64bit).
2. Make sure the Host IP you update in listener.ora is correct, you can use ipconfig command to verify the Host IP.
3. Restart LISTENER with the following commands.

    lsnrctl  stop

    lsnrctl  start
4. Use TNSPING to test the connectivity from Desktop to Oracle server.
5. When connecting to Oracle from Power BI desktop, enter the connection details in TNSnames.ora file, then check if it is successful. Alternatively, you can connect to the Oracle Database via EZConnect connection string. For more details, please review this similar blog.

 

Regards

Hello,

I'm an Oracle dveloper, I use Oracle databases every day, no Listener or TNS problem, I have problem with the remote databases only, but I replaced the 64bit PBI with 32bit version and I can connect to remote databases too, I think my Oracle 10.2 client and 64bit PBI are incompatible in remote connection.  32bit is not bad for developing but I hope I can fix the 64bit problem,

Thanks,

LL

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!