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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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-...

 


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors