Forum Discussion

santhoshpowerbi's avatar
santhoshpowerbi
New Member
5 years ago
Solved

Power BI Connecting with Oracle Database

Hi Experts,   I am a newbie to this community.   I am trying to install Oracle ODAC (64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64 - 287 MB) from this link (https://www.oracle.com/databa...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi santhoshpowerbi ,

    Please note:

    You might encounter any of several errors from Oracle when the naming syntax is either incorrect or not configured properly:

    • ORA-12154: TNS:could not resolve the connect identifier specified.
    • ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
    • ORA-12541: TNS:no listener.
    • ORA-12170: TNS:connect timeout occurred.
    • ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA.

    These errors might occur if the Oracle client either isn't installed or isn't configured properly. If it's installed, verify that the tnsnames.ora file is properly configured and you're using the proper net_service_name. You also need to make sure that the net_service_name is the same between the machine that uses Power BI Desktop and the machine that runs the gateway. 

     

    For configuring TNS listener and .ora file, you can refer:

    1. Oracle Network Configuration (listener.ora , tnsnames.ora , sqlnet.ora) 
    2. Create TNS in Oracle 19c Windows 10 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

santhoshpowerbi's avatar
santhoshpowerbi
New Member
5 years ago

Hi Yingjie Li,

Thank you for your reply.

As suggested, I have updated my POWER BI Desktop to the latest version and

I have followed the two links "Connect to an Oracle database with Power BI Desktop " and downloaded ODAC from it and installed and configured the tnsnames.ora file.

For a Test Check, I run the sqlplus to connect the destination database from my local machine (Where ODAC was installed), and it's successful.

Whereas POWERBI Connection is still giving the error.

 

Please suggest, what I am missing here.

 

Thanks

Santhosh

 

 

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi santhoshpowerbi ,

Please note:

You might encounter any of several errors from Oracle when the naming syntax is either incorrect or not configured properly:

  • ORA-12154: TNS:could not resolve the connect identifier specified.
  • ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
  • ORA-12541: TNS:no listener.
  • ORA-12170: TNS:connect timeout occurred.
  • ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA.

These errors might occur if the Oracle client either isn't installed or isn't configured properly. If it's installed, verify that the tnsnames.ora file is properly configured and you're using the proper net_service_name. You also need to make sure that the net_service_name is the same between the machine that uses Power BI Desktop and the machine that runs the gateway. 

 

For configuring TNS listener and .ora file, you can refer:

  1. Oracle Network Configuration (listener.ora , tnsnames.ora , sqlnet.ora) 
  2. Create TNS in Oracle 19c Windows 10 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.