Windows 2022, SSRS 2019 version15.0.1102.1084
Downloaded and installed WINDOWS.X64_193000_client.zip as Administrator, successfully registered managed DLL in GAC as requested here: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15
C:\Oracle64\product\19.0.0\client_1\odp.net\bin\4\OraProvCfg.exe /action:gac /providerpath:C:\Oracle64\product\19.0.0\client_1\odp.net\managed\common\Oracle.ManagedDataAccess.dll
INFO: c:\oracle64\product\19.0.0\client_1\odp.net\managed\common\oracle.manageddataaccess.dll is registered successfully in GAC.
restarted the server, successful connected to oracle DB via SQLPLUS using SERVICE NAME so I know connectivity via tnsnames.ora works fine but SSRS Data sources connectivity test is failing with error “An attempt has been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services.”
I also checked the C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\reportserver.config and the ORACLE extention is there uncommented as it should
Does anyone has some ideas what else should be done in order for this ODP.NET connection to work?