SSRS: The selected data extension ORACLE is not installed or cannot be loaded

Question

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!

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

Answer 1

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:

• You didn't install Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio and ODP.NET.
• You have already installed an incorrect ODAC version that doesn't match the correct Oracle Database Version.

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.
   

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.

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

Read also

• How to install Oracle Client Data Access for Microsoft Report Builder?
• Oracle Data Access Components Runtime Downloads

Comments

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