SSRS in SharePoint integrated mode - ORA-03135 when querying Oracle database
NickName:Petr Ask DateTime:2017-10-02T23:55:34

SSRS in SharePoint integrated mode - ORA-03135 when querying Oracle database

We have successfully installed SSRS in SharePoint integrated mode. We can run reports with data sources pointing to MS SQL database. We need to add support for reports querying Oracle 12c database.

After the drivers installation we can create a data source with "Oracle Database" data source type. But when we try the "Test Connection" button, we always get the "ORA-03135: connection lost" error. Reports based on this data source always fail.

We use these versions: SharePoint 2016, MSSQL 2016, Oracle 12c.

Did anybody come across this error? How did you solve it?

Thanks.

Copyright Notice：Content Author:「Petr」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/46529173/ssrs-in-sharepoint-integrated-mode-ora-03135-when-querying-oracle-database

Products recommended by Amazon
More >>>
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
 HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
 AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
 Timberland Men's 6-Inch Premium Waterproof Boot
Timberland Men's 6-Inch Premium Waterproof Boot
More about “SSRS in SharePoint integrated mode - ORA-03135 when querying Oracle database” related questions
SSRS in SharePoint integrated mode - ORA-03135 when querying Oracle database

We have successfully installed SSRS in SharePoint integrated mode. We can run reports with data sources pointing to MS SQL database. We need to add support for reports querying Oracle 12c database.

Show Detail
Converting SSRS from Native Mode to SharePoint Integrated Mode

I am trying to follow this article to convert an SSRS instance from Native Mode to SharePoint Integrated Mode. I am stuck at section “Configure SSRS in SharePoint integrated mode”, step 9. As you ...

Show Detail
Subscriptions not being fired in SSRS SharePoint integrated mode

We have a SharePoint farm with SSRS in SharePoint integrated mode. Reports rendering works fine, but suddenly we started to have problems with subscriptions. The SQL Server agent successfully run...

Show Detail
SharePoint Integrated mode not shown while installing new instannce

I need to convert SSRS Native mode to SharePoint Integrated mode. Similar Question was asked here Converting SSRS from Native Mode to SharePoint Integrated Mode. As a resolution I followed this blo...

Show Detail
Deploying a custom assembly to SSRS in Sharepoint Integrated Mode

I'm having some trouble deploying a custom assembly used in some of my reports to our SSRS server in Sharepoint integrated mode. According to Microsoft the two methods to deploy an assembly to SSRS...

Show Detail
Data Alerts disabled in Sharepoint 2010 installed in Integrated mode with SSRS

I am using Sharepoint 2010 configured in Integrated mode with SSRS (2012 RC0). Now I am trying to create a Data Alert in my Report. But my Data Alert is always disabled. I created a Report using R...

Show Detail
Create SSRS report in SharePoint 2010 integrated mode using SharePointList

I am new to SSRS and now have a requirement to create reports in SharePoint 2010. I have successfully configured SSRS with SharePoint integrated mode. I am using VS2008 BIDS instance coming with SQL

Show Detail
What is the new SSRS 2012 Web Service End Point (SharePoint 2013 Integrated)

I have deployed the SharePoint Service Application of Reporting Services 2012 on SharePoint 2013 in SharePoint integrated mode. My SSRS Service Application runs on a dedicated box. (WFE and SSRS a...

Show Detail
Set parameter value in SSRS report in sharepoint integrated mode with dropdown

I have a SSRS report, deployed in sharepoint integrated mode. It has a parameter ProjectId which is associated with a dataset means it has a drop down where the user can select any project. I want...

Show Detail
SSRS integration with SharePoint

I am working on a task where I need to run SSRS and SharePoint on different servers, but right now, SSRS is working in integrated mode. Is it possible to configure a remote SSRS instance in integra...

Show Detail