Oracle Problems Power BI Desktop

[dniedrauer]

I'm having issues with connecting Power BI Desktop to an Oracle database. 

"Oracle: ORA-12154: TNS:could not resolve the connect identifier specified"

Here was the info I was given (I've changed some letters): 

Connection Name: BI_BRUCE_USER 1 PROD

USER NAME: USER_NAME

Password: ****

Hostname: lira2

Port: 1521

SID: du1b

I edited the tnsnames.ora file to 

BI_PRICE_USER1 PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lira2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = du1b.company.com)
)
)

Now, the error I get is ORA-12170:TNS:Connect timeout occured. What's going on? Am I missing tons of information or not? 

EDIT: tried  connecting via an IP address instead. Now, the error I get (which is the same error I get in Excel using the tnsnames.ora file) is: 

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

.....am I at least closer now? where do I go from here? 

[v-shex-msft]

Hi @dniedrauer,

Perhaps you can take a look at below article:

Troubleshooting

You may encounter serveral errors from Oracle when the naming syntax is either incorrect or not configured properly.

• ORA-12154: TNS: could not resolve the connect identifier specified
• ORA-12514: TNS listener does not currently know of service requested in connect descriptor
• ORA-12541: TNS: no listener
• ORA-12170: TNS:Connect timeout occurred
• ORA-12504: TNS listener was not given the SERVICE_NAME in CONNECT_DATA

These errors could occur if either the Oracle client is not installed, or if it is not configured properly. If it is installed, you will want to verify the tnsnames.ora file is properly configured and you are using the proper net_service_name. You will also need to make sure that the net_service_name is the same between the machine using Power BI Desktop and the machine that is running the gateway. For more information, see Installing the Oracle Client.

Regards,

Xiaoxin Sheng

[dniedrauer]

I'm actually trying to connect via Phone Bi desktop. Is a gateway even relevant here?

Would also be nice to know: (1) what's a net service name? (2) what does it look like and (3) what other things is it usually called ?

[v-shex-msft]

Hi @dniedrauer,

On my side, I can direct use service name connect to oracle database. Have you test to use command line to connect to your oracle server?

Establishing a Connection and Testing the Network

In addition, you can also check your oracle service to confirm it has turned on.

Regards,

Xiaoxin Sheng