Forum Discussion
Oracle 2.0 Upgrade Woes with Self-Hosted Integration Runtime
In my case the root cause ended up being that the source Oracle server was version 11g which is not supported in the new connector.
Instead, I am connecting to the Oracle data using ODBC connector going forward. Hope this helps someone else!
We faced the same issue with this upgrade and connection.
First, we upgraded our IR to 5.52 as it was lower than 5.50. Then, we used 2.0 version of Oracle Linked service. Ended up with the same error.
Then we understood that it's related to connection encryption that is enforced by default.
So, we try some testing using various parameters and ended up finding a temporary solutions.
After using "accepted" in both "Encryption client" and "Crypto checksum client" under the "Additional Connection Properties", we were able to test the connection successfully.
Some info about these parameter.
Hope it's useful for someone!
Thank you!
First of all thanx for posting that. I tired the same config and test connection succeeded, but only for once, then it still fails with the same error. Any ideas why? I'll try to have my DBA to provide a list of encryption or data integrity algorithms accepted by Oracle DB, the issue might be here, but sill in my config I listed almost all of them, and still failing