Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
15.4k views
in SQL Server Reporting Services by 12 12 19

I encountered this error "The selected data extension ORACLE is not installed or cannot be loaded.  Verify that the selected data extension is installed on the client for local reports and on the report server for published reports." when trying to use "Oracle Database" as a connection type in the SSRS data source in Microsoft Report Builder!

SSRS The selected data extension ORACLE is not installed or cannot be loaded.  Verify that the selected data extension is installed on the client for local reports and on the report server for published reports

Why I get this error and how I can fix it?


1 Answer

1 like 0 dislike
by 159 188 375
selected by
 
Best answer

Actually, this error "The selected data extension ORACLE is not installed or cannot be loaded. Verify that the selected data extension is installed on the client for local reports and on the report server for published reports." usually occurs in the following cases:

How to use Oracle Database Connection type in SSRS? 

To be able to use the Oracle Database connection type in a data source in SSRS report Builder, you should make sure that you are using the correct Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio and ODP.NET based on your Oracle Database Server version.

Steps

  1. Uninstall the current installed ODAC from your machine.
  2. Install one of the following releases for "ODAC, ODP.NET, and Oracle Developer Tools" based on your Oracle Database Server.
    • ODAC 18.3 (Oracle 11g Release 2 or later)
    • ODAC 12.2 (Oracle 10g Release 2 or later)
    • ODAC 11.2 (Oracle 9i Release 2 or later)
    • Note: Each ODAC has the following Components:
      • Oracle Developer Tools for Visual Studio
      • Oracle Data Provider for .NET
      • Oracle Providers for ASP.NET
      • Oracle Database Extensions for .NET -- available in 12.2 and earlier for upgrade only
      • Oracle Provider for OLE DB
      • Oracle OLAP Provider for OLE DB -- 18c and higher
      • Oracle Services for Microsoft Transaction Server
      • Oracle ODBC Driver
      • Oracle SQL*Plus
      • Oracle Instant Client
  3. Once the installation is done successfully, you have to configure the tnsnames.ora file as mentioned at tnsnames.ora for Oracle or at SSRS: ORA-12154: TNS: could not resolve the connect identifier specified

    Don't forget to restart the SSRS service or Power BI report server service in the case you are installing the ODAC and change tnsnames.ora file on the same reporting server.

  4. Try now to open Microsoft Report Builder or Power BI Report Builder and connect to Oracle Database as a connection type that should be now connected successfully.
    connect to Oracle stored procedure from SSRS and Power BI report builder

Note: Oracle Developer Tools for Visual Studio will not be installed if you don't have Visual Studio installed on your current machine, and in this case, you have to uncheck this option during installing ODAC.

Oracle Developer Tools for Visual Studio

Note: In case the above steps don't help, I would recommend using Visual Studio with Bussiness Intelligence Tools Template with ODAC for Visual Studio

Oracle Developer Tools for Visual Studio

Read also

by 12 12 19
0 0
Yes It's solved my issue, the problem was on the current installed ODAC, it was ODAC 11 and I uninstalled it then install ODAC 12.2 for Oracle 11g database. Thanks Mohamed for all your kind of support
If you don’t ask, the answer is always NO!
...