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:

[jmiridium]

IP address in HOST.

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

[dniedrauer]

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"

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