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 Amit, 

 

Thanks for your reply. I have added the path but it's still the same.


Path = E:\app\client\famis\product\12.1.0\client_1\odp.net\bin;E:\app\client\famis\product\12.1.0\client_1;E:\app\client\famis\product\12.1.0\client_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft VS Code\bin

 

Thanks

Santhosh

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

Hi santhoshpowerbi ,

Please follow this viedo about installing oracle 19c on Windows Server 2012 R2:

Oracle 19c Installation on Windows Server 2012 R2 Step by Step | Oracle 19c on Windows Server 2012! 

 

If your oracle could work fine, try to update your power bi desktop to the latest version(May 2021)

 

In addition, please note:

Choose a version of Oracle Data Access Client (ODAC) which is compatible with your Oracle Server. For instance, ODAC 12.x does not always support Oracle Server version 9. Choose the Windows installer of the Oracle Client. During the setup of the Oracle client, make sure you enable Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level by selecting the corresponding checkbox during the setup wizard. Some versions of the Oracle client wizard selects the checkbox by default, others do not. Make sure that checkbox is selected so that Power BI can connect to your Oracle database.

 

Refer: Connect to an Oracle database with Power BI Desktop 

 

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.