Not able to connect oracle database. pls. help.

[saivina2920]

I am trying to connect oracle database. but, i am getting below error.

below is sample credentials (for reference only).

host:xxxx.xxxxxxnet.minum.intranet
SID:xxxx
schema:xxxx
user : user01
password : xxxx

[PhilipTreacy · Accepted solution]

HI @saivina2920 

See if these help point you in the right direction

Solved: Gateway connection to Oracle (TNS:listener error) - Microsoft Power BI Community

oracle - ora-12504: tns:listener was not given the service_name in connect_data in windows 10 - Stac...

Phil

[parry2k]

@saivina2920 glad to know that was fake credentials. Search on google for environment variable there are tons of posts.

How to change environment variables on Windows 10 | Architect Ryan

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[amitchandak]

@saivina2920 , You should not share connection details here.

For oracle , please refer :https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database

You need to install the driver given on the page. Plus make sure you do the entry of the driver install path in Windows environment variable, else you will keep on getting this.

[saivina2920]

I have installed driver and mentioned in environment variables. below is the screenshot.

but, still not connecting...?

[saivina2920]

can anyone pls. update the status.

still i am facing the problem even i installed driver in environment variables..

[saivina2920]

any update pls.

[saivina2920]

i already installed oracle driver . because we are connecting other BI tool with oracle.

Plus make sure you do the entry of the driver install path in Windows environment variable ??? ==> How do we check..

Note : whatever i mentioned the credentials, its for understanding and reference only.

[parry2k]

@saivina2920 not sure why, I hardly worked with oracle but replying that you shouldn't share credentials publically. Just a piece of advice.