Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Connection to an Oracle Database

I've read a lot of threads about this specific issue but none of the solutions offered have solved it for me.

I'm trying to connect Power BI Desktop to an Oracle Database.

I installed the Oracle Client 12.1.0.2 64bit (same as Power BI).

I editted the tnsnames.ora file and added the info for the server in question.

After that I click on Get Data, select Oracle Database.

 In the "server" box I tried the following string (as suggested in another thread): 

"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<myservername>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<myservicename>)))"

I made sure the service_name was exactly the same as in tnsnames.ora

When I click on OK, it prompts me for my username and password.

Upon all that I get the following message: 

Details: "Oracle: ORA-12545: Connect failed because target host or object does not exist"

Any help would be appreciated.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Please use CMD to test if you can connect to Oracle Database:

    sqlplus username/password@ip:port/servername

    Please refer to this article: https://kb.informatica.com/solution/5/Pages/18751.aspx.

    Hopefully works for you.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • venal's avatar
    venal
    Icon for Memorable Member rankMemorable Member
    6 years ago

    Anonymous 

    Please refer the link for the issue.

    If you have any concerns, please let us know.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more
    If this post was helpful may I ask you to mark it as solution and click on thumb symbol?