Connect To Oracle Database

[jmiridium]

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:

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

When I connect I get the following error:

[dniedrauer]

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? 

[jmiridium]

You would have to troubleshoot this outside of PowerBI

[dniedrauer]

starting with what? 

[jmiridium]

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

[Brindha]

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

[Greg_Deckler]

How about this thread?

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