Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jmiridium
Helper IV
Helper IV

Connect To Oracle Database

I need a connection solution for Oracle. This shouldn't be this difficult. I am trying to connec to an Oracle server and get the following:

oracleissue.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

However, the Oracle client is installed. I try to connect:

 

oracleissue2.JPG

 

When I connect I get the following error:

 

oracleissue3.JPG

1 ACCEPTED SOLUTION

Figured it out. After finding the path for the .ora file I entered the information in the file. Then in PowerBI I added the connection name from the .ora file to the connection string

View solution in original post

28 REPLIES 28

IP address in HOST.

 

I have created serveral conections to different Oracle databases using this connection method without issue

where would I find the Oracle DB ip address? 

 

I get access denied when I try to query it in sql developer. 

 

I had the old DB admin ping it as xx.xx.x.x a few months ago before turnover and turmoil turned everything into a mess where it's not even clear if there is a DB admin anymore. 

 

Now the error is: 

 

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

 

tnsnames.ora file is now: 

 

du1p.company.com =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipaddress)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = du1p.company.com)))

 

When Power BI asks for a "server", I tried typing in: 

 

(1) the ip address

(2) du1p.company.com

(3) du1p 

 

In each case, the error was: 

 

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

If it means anything, I can log onto the server from SQL Developer ONLY on a virtual machine. 

 

I tried to install a local copy of SQL Developer and even imported the connection from the vm version, and i get the following error: 

 

"An error was encountered performing the requested operation:

IO Error: The Network Adapter could not establish the connection

Vendor code 17002"

 

If the issue is (1) an ip mismatch issue between my PC and the data base IP, how would I go about resolving it? (first, I need help finding what the oracle ip is) or (2) a firewall issue, how would i fix the firewall issue? 

You would have to troubleshoot this outside of PowerBI

starting with what? 

Not sure. You would have to troubleshoot the Oracle side of things

I have the same error Details: "Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"

and i couldn't Fix it . I am New to power BI . Can you please tell me how to fix it

 

How about this thread?

 

https://stackoverflow.com/questions/18252635/ora-12545-connect-failed-because-target-host-or-object-...

 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors