Forum Discussion
Error: ORA-12650: No common encryption or data integrity
hi guys, I started getting this weird error in the copy activity, have you seen this error before ? any idea ? Oracle 11.2 Failure happened on 'Source' side. ErrorCode=UserErrorFailedT...
You can review the issue on this article https://learn.microsoft.com/en-us/azure/data-factory/connector-troubleshoot-oracle#error-code-argumentoutofrangeexception. I saw it yesterday, but I couldn't find the link to the older version, so I wasn't able to downgrade my SHIR and test it.
Here is the download link:
https://download.microsoft.com/download/E/4/7/E4771905-1079-445B-8BF9-8A1A075D8A10/IntegrationRuntime_5.35.8686.1.msi
I tested it just now and it's working.
Hi,
Thank you, I was looking for the link, but the problem with reverting being that we are missing on several key other fixes and updates on integration runtime if this is downgraded.
Are you planning to do this as a temporary fix, we have raised a ticket with Microsoft, seems really weird that this keeps happening.
Thank you, I was looking for the link, but the problem with reverting being that we are missing on several key other fixes and updates on integration runtime if this is downgraded.
Are you planning to do this as a temporary fix, we have raised a ticket with Microsoft, seems really weird that this keeps happening.
- That makes sense.
We tried a few things at our end, passing the encryption_levels multiple to the server along with different combinations of algorithms, as suggested here. ACCEPTED is the default, so I guess Azure is passing an algorithm the oracle server is not able to match, to make our life worse we have a private cloud hosted oracle machine and no access to sqlnet.ora file.
We are going the same route as you guys are doing, got to keep the show running as Microsoft finds and fixes the root cause.
Thanks and cheers. - Yes, we've already implemented this workaround. You are correct. By downgrading we're missing out on updates.
Since this is affecting our all of our environments, we need to implement this while we work on addressing the root cause of insecure algorithms.