Cannot connect to Oracle database

[Anonymous]

Hi All

I am trying to connect to Oracle database . I gave the Server name, database user name and password, after clicking OK it keeps spinning for a while and then i get the below message

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

Any Advice

Thanks

[v-yiruan-msft]

Hi @Anonymous ,

Which format do you use when entering database information into Server input box? Like ServerName/database name or other format? And whether the related database in backend is working well?

In addition, please review the solution in the following threads and check if they can resolve your problem.

On premise Gateway and an Oracle Datasouce

Error - Oracle: ORA-12154: TNS (check the posts from bjerbe and nollc)

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

Best Regards

Rena

[Anonymous · Accepted solution]

Thanks All

The below video resolved it

https://www.youtube.com/watch?v=2VeqOMAda1o

[Anonymous]

Hi, but this solution is via an ODBC connection.

[v-yiruan-msft]

Hi @Anonymous ,

Glad to hear that your problem has been resolved. Thank you very much for sharing your solution, it will help others find the solution easily if they face the same problem with you. 

Best Regards

Rena

[amitchandak]

@Anonymous , please install the driver given on the page.

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

The driver installation folder has a read only file. And please follow the steps you do not miss.

Also, make sure you add the path is added in the windows environment

[Anonymous]

Thanks amitchandak

I spent half a day but was not able to install. ok i downloaded the 64 bit and from the downloads i extracted the files to my C drive (C:\ODAC122010Xcopy_x64)

Then in the command prompr

i typed in the commands and i get a message

install.bat is not a recognized as an internal or externalommand.

Also in the beginning of the document is see under general information

 The files of this zip file are NOT to be installed on top of an existing Oracle Universal Installer (OUI) based Oracle Home installation.

Please advice.

Thanks