Forum Discussion

dramus's avatar
dramus
Continued Contributor
8 years ago
Solved

Unable to connect using Oracle database even after ODAC install.

I have 64bit December 2017 Desktop Installed.   I have 64bit Oracle 12.1.0.2 runtime client installed (and can use SQLPLUS to connect to the database from the command prompt).   I have installed ...
Need Help
  • dramus's avatar
    dramus
    8 years ago

    Alrighty...Finally got it to work.

     

    Installed 64bit runtime client 12.2. Then installed ODAC122010_x64. INTO THE SAME ORACLE HOME. 

     

    By default ODAC tries to install itself into a new Oracle Home. Which doesn't work.

danielhough's avatar
danielhough
Helper II
5 years ago

Hey dramus , can you please paste in the links for the downloads you performed? Both the Runtime and ODAC?

dramus's avatar
dramus
Continued Contributor
5 years ago

It looks like Oracle have removed the links for the Oracle 12.2 Client from thrir Software downloads page. You have to request it now.

 

I'll try installing with the latest version and report back here.

  • danielhough's avatar
    danielhough
    Helper II
    5 years ago

    So, I am really new to this stuff and there seems to be several files to download, can you refer me to the link in Oracel or file name of what I should download? Thanks for responding, your post is a few years old now lol 

    • dramus's avatar
      dramus
      Continued Contributor
      5 years ago

      ODAC 12.2.0.1.1 installer 

       

      There are a couple of things to note when installing, see me replies above for details.

      • danielhough's avatar
        danielhough
        Helper II
        5 years ago

        Thanks, is this the only download needed? I try this and it will for a split second show an install then nothing works?

         

  • dramus's avatar
    dramus
    Continued Contributor
    5 years ago

    I couldn't get Power BI Desktop to work with the Oracle19 ODAC tools. However a clean install of The full ODAC tools for 12.2.0.1.1  did work. I didn't need to install an "Oracle Client" at all.

    NOTE: Make sure to check the box about installing the drivers machine wide.

    • dramus's avatar
      dramus
      Continued Contributor
      5 years ago

      One more gotchya. I had to copy the oraons.dll from the main client directory into the client/bin directory.

      • dramus's avatar
        dramus
        Continued Contributor
        5 years ago

        More digging this morning. Found this on the Oracle website for the ODAC 19.2 install:

        Machine-Wide Configuration

        Machine-wide configuration is no longer supported beginning with ODAC 18c. Administrators can still place ODP.NET in the GAC and add the configuration section handler and DbProviderFactory information to machine.config manually if they wish to override ODP.NET settings for individual applications.

         

        So it seems Power BI Desktop doesn't see the drivers because Oracle no longer installs them at the machine level. If someone smarter than me with ODP.NET knows how to add that machine level configuration, I would be interested in trying it out.