Forum Discussion
Post ProdigyNot able to connect oracle database. pls. help.
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
HI saivina2920
See if these help point you in the right direction
Solved: Gateway connection to Oracle (TNS:listener error) - Microsoft Power BI Community
Phil
8 Replies
- parry2k
Super User
saivina2920 not sure why, I hardly worked with oracle but replying that you shouldn't share credentials publically. Just a piece of advice.
- 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.
saivina2920i 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.
- saivina2920
I have installed driver and mentioned in environment variables. below is the screenshot.
but, still not connecting...?
- saivina2920
any update pls.
- 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.⚡
- PhilipTreacy
HI saivina2920
See if these help point you in the right direction
Solved: Gateway connection to Oracle (TNS:listener error) - Microsoft Power BI Community
Phil
