Forum Discussion

vakshi's avatar
vakshi
Frequent Visitor
9 years ago
Solved

Oracle connection error

Hi all,   I'm getting this error message when trying to get data from oracle DB. the error message appears when I choose "Oracle", Before choosing the relevant DB and user/password:   "The recom...
Jamey's avatar
Jamey
Helper I
9 years ago

For my experience, I installed on a 32-bit system and one on a 64-bit system. It's the same install on each except you must use the matching bit version of the Oracle products that matches the PowerBI Desktop bit version.

 

In my case I installed the following Oracle Client on my respective installs:

32-bit  win32_12201_client.zip

64-bit winx64_12201_client.zip

both can be found at the link below:

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-windows-3633015.html

Note: in my case I change the default path of the install to C:\app\Oracle\product\12.2.0\client_1 but it doesn't matter where you put it.

 

After installing the client I had to install the following: (IT WILL NOT WORK WITHOUT THIS!)

32-bit ODAC121021Xcopy_32bit.zip 

http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html

64-bit ODAC121024_x64.zip 

http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

 

To install the above you must open a Administator Command Prompt and change to the path that you extracted the files to. Then run this command:

install all C:\app\Oracle\product\12.2.0\client_1 odac (the path is where you installed the above client to)

 

you also need to make sure the following is included in the 'path' of the Environment Variables:

C:\app\Oracle\product\12.2.0\client_1;C:\app\Oracle\product\12.2.0\client_1\bin (or wherever your path is loacted)

 

You need to have a TNS_ADMIN entry in the Environment Variables that points to the directory that the tns_names.ora file lives.

 

This all worked for me and hope it helps you as well.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I am still confused. Do I need to install this on my PC, or do I need to install on the server? in my company the oracle server is in another computer, and I am only an end-user.

    • AmitK's avatar
      AmitK
      Frequent Visitor
      8 years ago

      You need to install this on your pc where you have power bi desktop setup. 

  • TinHau's avatar
    TinHau
    Frequent Visitor
    8 years ago

    Our Oracle drivers are distributed by packages within the company. Based on my information we currently have Oracle 12.2.0.1 drivers on the clients. However when I try to connect with Power BI to an Oracle database I get this message:

     

    DataSource.Error: The provider being used is deprecated:

    'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater'

     

    And later on

     

    Oracle database

     

    The recommended provider ('Oracle.DataAccess.Client') is not installed. You can continue with your current provider, however it has been deprecated and may not work correctly.

     

    Confused from these messages. Could anybody help me out ?