Oracle database gateway error

[Anonymous]

Hi,

First time using Oracle database as source.

I was successfully able to connect database, but coudn't setup gateway for my datasource.

What can be reason for this error, what can i do to resolve this. 

Thank you.

[Anonymous · Accepted solution]

Finally, i have managed to find the solution.

The reason behind the error is gateway is not configured with required Oracle database. So, now they have configured it. I could able to add it to Gateway.

The error message was regarding Oracle client. That was nor correct. So if someone is having same error look into the configuration of Gateway within Organisation.

Thank you for all the help.

[GilbertQ]

Hi there

Are there any additional error details.

What happens if you try and connect from the Gateway server to the datasource, does it connect?

[Anonymous]

Hi Here is the error message i get.

[GilbertQ]

Hi @Anonymous 

Please review the error message and update the software.

[GilbertQ]

Hi @Anonymous 

If you could follow these steps to ensure you can get it working:

Power BI – On-Premise Gateway Configuration steps to an Oracle Database - Reporting/Analytics Made easy with FourMoo and Power BI

[Anonymous]

Thank you for the response @GilbertQ 

I have gone through this, but didn't work.

I am trying to add Oracle datasource to Gateway installed within organisation. They have installed Oracle client on Gateway.

In Power BI Desktop, i have installed Oracle client latest version in my remote desktop and i was able to connect to datasource. 

What are the mandatory steps to do while installing Oracle client? 

Couldn,t understand where exactly the error is occuring.